topic List of columns starting with in Discussions

List of columns starting with

Jo_E — Wed, 25 Feb 2026 15:44:12 GMT

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.

Re: List of columns starting with

txnelson — Wed, 25 Feb 2026 16:04:48 GMT

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

Jo_E — Thu, 26 Feb 2026 10:39:27 GMT

Thank you, that was helpful.