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::", "-" ) ) ) );
);
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
hello Jim,
yes it works.
thank you very much for the code correction and also object property explanation. Very interesting.
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
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!!