81463_en-US

liliconcom

rename cell

hi,

 

I've wrote this jsl to rename cell with"portion" by "Portion".

It's doesn't work.

has someone a solution?

 

Names Default To Here( 1 );

dt= Current Data Table();

For( I = 1, I <= N Rows( dt ), I++,

if(dt:Format == "portion",

dt:Format == "Portion"

 

);

);

 

 

best regards

Re: rename cell

Hi,

 

Ok, it's good !

 

thanks

Re: rename cell

Your script needs to be updated to point directly to the row you want to evaluate and to change

Names Default To Here( 1 );
dt = Current Data Table();
For( I = 1, I <= N Rows( dt ), I++,
 If( dt:Format[I] == "portion",
  dt:Format[I] = "Portion"
 )
);

A more efficient way of coding this is:

Names Default To Here( 1 );
dt = Current Data Table();
dt:Format[dt << get rows where( :Format == "portion" )] = "Portion";