932563_en-US

liliconcom

List of columns starting with

I would like a script which inserts all columns with column names starting with "animal names" into the column list "animal list". I am sure it is simple but the AI-generated script is not working.

Automation and ScriptingRe: List of columns starting with

Here is a simple example of how I would do this

names default to here(1);
dt=open("$SAMPLE_DATA/blood pressure.jmp");

animal list = dt << get column names(string);

animal list = filter each( {col}, animal list,
	starts with(col,"BP")
);

Re: List of columns starting with

Thank you, that was helpful.