topic Re: Clear selected row cells based off string that ends with in Discussions

Clear selected row cells based off string that ends with

rmthomas — Fri, 09 Jun 2023 18:03:37 GMT

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

Re: Clear selected row cells based off string that ends with

jthi — Mon, 25 Oct 2021 13:19:50 GMT

Syntax for Ends With seems to be wrong. Try:

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

and check what values curRows has.

Re: Clear selected row cells based off string that ends with

rmthomas — Mon, 25 Oct 2021 13:26:11 GMT

@jthi Thank you this works great!