Subscribe Bookmark RSS Feed

loop for and if for column name change

KinKame

Community Trekker

Joined:

Nov 30, 2015

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

);

4 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

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

Jim
KinKame

Community Trekker

Joined:

Nov 30, 2015

hello Jim,

yes it works.

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

M_Anderson

Staff

Joined:

Nov 21, 2014

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

KinKame

Community Trekker

Joined:

Nov 30, 2015

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