topic Re: loop for and if for column name change in Discussions

loop for and if for column name change

KinKame — Tue, 26 Jul 2016 05:29:53 GMT

all,

I would like to rename column name depending on some condition using a for loop with a if conditional.

But doesn't work.

If I set up the function out of the for loop then no issue.

code as below

For( i = 1, i <= 100, i++,

If(i > 0 ,

Column(i) << set name( char(munger(Column name(i), 1, "::try::", "-" ) ) ) );

);

txnelson — Tue, 26 Jul 2016 11:11:13 GMT

The Column Name() function returns an expression, not a literal string. So if you use:

Column(i) << set name( char(munger(char(Column name(i)), 1, "::try::", "-" ) ) ) );

it should work

MikeD_Anderson — Fri, 28 Oct 2016 13:28:38 GMT

You might have a look at xan@jmp 's Column Name Utility add-in for some tips on how to do this.

If you download the add-in and change the file suffix to .zip, you can unzip it and see what he's doing.

Best,

KinKame — Wed, 27 Jul 2016 01:31:06 GMT

hello Jim,

yes it works.

thank you very much for the code correction and also object property explanation. Very interesting.

KinKame — Wed, 27 Jul 2016 01:44:53 GMT

Hello Michael,

thank you for the resource. It seems good to me but preferable to use script and not add on.

but good for learning thank you!!