topic Re: Question on JSL filling row blanks within a column in Discussions

Question on JSL filling row blanks within a column

Sully — Thu, 24 Aug 2017 14:38:23 GMT

Hello All,

I am relatively new to JSL. I have a character column labeled State, within the column are the initals of the various US states. However, within this column there are blanks, I want to be able to created a JSL that will allow me to replace the blanks with the word "International". I have been looking all over and have been unable to find a coding that would allow me to replace the blanks within my State column with International.

Any advice would be appreciated!!

Re: Question on JSL filling row blanks within a column

Sully — Thu, 24 Aug 2017 14:39:50 GMT

The data table is being opened from a text file. I am not querying to get the data.

Re: Question on JSL filling row blanks within a column

pmroz — Thu, 24 Aug 2017 14:42:01 GMT

dt = New Table( "Untitled 24", Add Rows( 6 ),
	New Column( "State", Character, "Nominal",
		Set Values( {"PA", "DE", "NJ", "", "", "VA"} )
	)
);

blank_rows = dt << get rows where(as column(dt, "State") == "");

if (nrows(blank_rows) > 0,
	column(dt, "State")[blank_rows] = "International";
);

Re: Question on JSL filling row blanks within a column

Sully — Thu, 24 Aug 2017 15:03:18 GMT

That worked perfectly! Thank you!