topic Re: Finding the Location of a Column Name Amongst a List of All the Column Names in a Data File in Discussions

Finding the Location of a Column Name Amongst a List of All the Column Names in a Data File

mostarr — Fri, 09 Jun 2023 19:50:40 GMT

As the post subject implies, I'm trying to find the loc # of a col identified by name in a given data file. I have the column name. Here is my code:

column_names = datatable << Get Column Names();
Write(column_names);
column_position = loc(column_names, "ARBITRARY COLUMN TITLE/NAME");
Write(column_position);

Write(column_names) works but Write(column_position) outputs an empty matrix []. I don't know why this doesn't work. Any thoughts? I copy pasted the title of the column name, replaced for confidentiality but here denoted by "ARBITRARY COLUMN TITLE/NAME", so it should match exactly.

Mike

Re: Finding the Location of a Column Name Amongst a List of All the Column Names in a Data File

mostarr — Wed, 23 Jun 2021 18:54:58 GMT

I did look up the info at <https://www.jmp.com/support/help/en/16.0/index.shtml#page/jmp/get-column-names.shtml> but it didn't help with the bug.

Re: Finding the Location of a Column Name Amongst a List of All the Column Names in a Data File

jthi — Wed, 23 Jun 2021 18:59:10 GMT

You might have to add String to << get column names also try using Contains() instead of Loc().

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
colNames = dt << Get Column Names(String);
Close(dt, no save);
Contains(colNames, "height");