List of columns starting with

[#1]

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.

[#2 · Accepted solution]

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")
);

[#3]

Thank you, that was helpful.