19657_en-US

liliconcom

loop for and if for column name change<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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::", "-" ) ) ) );

);

Re: loop for and if for column name change

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!!

Re: loop for and if for column name change

hello Jim,

yes it works.

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

Re: loop for and if for column name change

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,

M

Re: loop for and if for column name change

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