cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Sully
Level III

Question on JSL filling row blanks within a column

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

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: Question on JSL filling row blanks within a column

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

View solution in original post

3 REPLIES 3
Sully
Level III

Re: Question on JSL filling row blanks within a column

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

pmroz
Super User

Re: Question on JSL filling row blanks within a column

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
Level III

Re: Question on JSL filling row blanks within a column

That worked perfectly! Thank you!

Recommended Articles