topic Using Column Name in Function in Discussions

Using Column Name in Function

abdulj — Tue, 30 Aug 2011 15:43:35 GMT

Can somebody help me out with the following??

Column1 = char(ColumnName(1));

Column2 = char(ColumnName(2));

Eval(Parse(EvalInsert("\[

obj << simulator(

Factors(

AB << Random( ^distNameOne^( ^strParameterOne^ ) ),

^Column2^ << Random( ^distNameTwo^( ^strParameterTwo^ ) )

Responses(

:Column 3 << No Noise

Automatic Historam Update(1),

Simulate

);

]\")));

If I name the first column "AB" manually, the profiler works fine for it. However attempting to automatically use the column name as in Column2 does not work. Any ideas on how to get it to work?

Thanks

Using Column Name in Function

pmroz — Tue, 30 Aug 2011 17:24:17 GMT

You're sending column actions to a string. Try these two variations:

:^Column2^ << Random( ^distNameTwo^( ^strParameterTwo^ ) )

column(^Column2^) << Random( ^distNameTwo^( ^strParameterTwo^ ) )

or maybe even

as column(^Column2^) << Random( ^distNameTwo^( ^strParameterTwo^ ) )

Re: Using Column Name in Function

abdulj — Tue, 30 Aug 2011 18:34:03 GMT

Thanks for the quick response.

At first your solution did not seem to work. Then, I decided to manually change the name of the columns to something simpler and that did the trick.

Any ideas why a column named something like "S/B nominal length-c" won't work, but if I renamed it to "SB nominal length c" it does work??

BTW, I used the following format:

:^Column1^ << Random

Or perhaps there's a way to have the script automatically remove any punctuation at the beginning?

Thanks

Using Column Name in Function

pmroz — Tue, 30 Aug 2011 19:46:55 GMT

That column name won't work because of the forward slash. This construct should work though:

:name(^Column2^) << Random( ^distNameTwo^( ^strParameterTwo^ ) )

Using Column Name in Function

abdulj — Tue, 30 Aug 2011 20:12:39 GMT

I get the following error when I tried that:

Name arg must be quoted string Line 5 Column 9: name(.....

Re: Using Column Name in Function

pmroz — Wed, 31 Aug 2011 11:31:58 GMT

You probably need quotes around the column name then.

:name("^Column2^") << Random( ^distNameTwo^( ^strParameterTwo^ ) )

Using Column Name in Function

abdulj — Wed, 31 Aug 2011 13:15:41 GMT

Great, everything works like a charm. Thanks again!