nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Question on JSL filling row blanks within a column

Sully

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!!

Accepted answers

pmroz

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

All comments

Sully

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

pmroz

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

Sully

That worked perfectly! Thank you!