rename cell

[#1]

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

[#2 · Accepted solution]

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";

[#3 · Accepted solution]

Hi,

Ok, it's good !

thanks