How to delimiter the "space" in the column?

TDK_Long — Thu, 30 Nov 2023 01:07:17 GMT

Hi folks,

I have one column with the following data format and I would like to split it into the multiple columns using jsl,

ABC D01 EF GGG

How to modify the following jsl to split the single column into four character columns.

dt << Text To Columns( delimiter( " " ), columns( :Column 1 ) );

I tried to use the TAB as the delimiter, but it also did not work.

dt << Text To Columns( delimiter( TAB ), columns( :Column 1 ) );

Thank you for the advice.

Re: How to delimiter the "space" in the column?

txnelson — Thu, 30 Nov 2023 02:59:10 GMT

The function needs to be applied to each row;

names default to here( 1 );
dt=current data table();
for each row(
	dt << Text To Columns( delimiter( "  " ), columns( :Column 1 ) );
);