topic Re: rename cell in Discussions

rename cell

Françoise — Fri, 26 Oct 2018 08:24:11 GMT

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

txnelson — Fri, 26 Oct 2018 11:20:51 GMT

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

Re: rename cell

Françoise — Fri, 26 Oct 2018 14:14:31 GMT

Hi,

Ok, it's good !

thanks