Choose Language Hide Translation Bar
Highlighted
StevenChan
Level II

How to delete specific rows by script?

Dear experts

 

I have question about the function like "excel filter"

I would always need transfer raw data to new table by filter out rows include specific character to come out new table, example like below, filter out (_B) then come out new table.

How to write script to come out new table? thank you.Sample.jpg  

1 REPLY 1
Highlighted
txnelson
Super User

Re: How to delete specific rows by script?

names default to here(1);
dt=current data table();
dt << select where(word(-1,:item,"_") == "B");
// or
// dt << select where(contains(:item,"_B");
// or 
// dt << select Where( substr(:item,-,2) == "_B");
dt << delete rows;
Jim
Article Labels