rename cell

Françoise

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

txnelson

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