How to delete specific rows by script?

StevenChan

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.  

txnelson

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;