How to select columns which start with specific names in JSL?

[#1]

Hello, 

I have some problem when I want to select some specific columns.

If there have column header with "RD123", "RD345", "123RD"...etc.

I want to select the column only start with "RD", and the only script I know is below

dt = Current Data Table();
colList= dt << get column names( string );
For( i = 1, i <= N Items( colList ), i++,
If( Contains(colList [i], "RD")) << set selected)
);

How to modify the script to select only "RD123" and "RD345"? 

Thanks.

[#2 · Accepted solution]

You could use Starts With instead of Contains. Also it might be easier to first filter down to the list of columns of interest and then select those using << Select Columns. Below is one example

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");

all_colnames = dt << Get Column Names("String");
cols_of_interest = Filter Each({col_name}, all_colnames, Starts With(col_name, "NPN"));

dt << Select Columns(cols_of_interest);

[#3]

Thanks a lot!