topic Re: Renaming Columns in a script in Discussions

How to remove a prefix from multiple column names using JSL?

whom — Fri, 06 Oct 2017 20:39:29 GMT

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.

Re: Renaming Columns in a script

Anonymous — Tue, 26 Oct 2010 23:47:29 GMT

I don't know *why* it works, but if you replace OldName with expr(OldName), it works for me:
dt = current data table ();
i = 1;
OldName = (Column name(i));
newvar = Substr( expr(OldName), 4, Length(expr( OldName )) - 3 );
show(newvar);

Re: Renaming Columns in a script

whom — Wed, 27 Oct 2010 00:49:42 GMT

That worked! Thanks!

Re: Renaming Columns in a script

ms — Wed, 27 Oct 2010 07:15:37 GMT

Alternatively you can use

OldName = Char(Column name(i));

Then you do not need the Expr() within Substr().

The reason for not working without Char() (or expr) is that Column name() returns a name value, not a quoted string. See more in the scripting guide (under "obtaining column names" p. 121, JMP 9)

Message was edited by: MS

Re: Renaming Columns in a script

ms — Wed, 27 Oct 2010 11:20:52 GMT

Or this single line solution:

Re: Renaming Columns in a script

mpb — Wed, 27 Oct 2010 16:49:58 GMT

Or this which uses both set and get name: