Clear selected row cells based off string that ends with

[#1]

Hello everyone, 

Here is an example that I need help with.

I am trying to clear specific rows based off of the last part of column Characteristic (.X, .Y, .Z) and clear the LSL, Target, USL. this is just a basic table and I have many different Characteristics and the ones I need to clear are all that end in .X, .Y, .Z.

I have tried to use this JSL code but I cant seem to get anything to happen. just for the characteristic .X and the USL.

dt111 = data table ("Untitled");

curRows = dt111 << get rows where(:Characteristic (ends with(".X")));
:USL[curRows] =.;

Any help would be greatly appreciated.

Thanks, 

-Ryan

[#2 · Accepted solution]

 Syntax for Ends With seems to be wrong. Try:

curRows = dt << Get Rows Where(Ends With(:Characteristic, ".X"));

and check what values curRows has.

[#3]

@jthi  Thank you this works great!