Ok, I guess I don't understand the JMP documentation. Short on good examples.
I'm trying to rename the columns in a JMP file that had columns names created with a prefix. All the column name start with "pre" and I want to strip that string from the column name.
In a loop, I was able to get all the column names extracted and displayed with a SHOW statement. I used
OldName = (Column name(i));
where i is the looping variable.
It seems like all I need to do is something like
substr(OldName,4,Length(OldName)-3)
but when I use that, I get all sorts of errors. Length function doesn't work for example.
WHAT am I doing wrong? The logic is so simple, but the JMP scripting language is killing me.