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.
ScriptingRe: 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;
