cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP Security Notice: CVE-2026-109618 and CVE-2026-109619

    JMP promptly initiated a review of its products, services, and relevant infrastructure for exposure to CVE-2026-109618 and CVE-2026-109619.

    Our assessment of JMP products has not identified exposure to these vulnerabilities. Where remediation was required within supporting environments, appropriate security updates and controls have been applied and validated.

    We have identified no evidence of successful exploitation or unauthorized access to JMP systems or customer information associated with these vulnerabilities.

    JMP continues to monitor the issue and relevant vendor guidance. No action is required by JMP customers at this time.

  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
Level XIII

Append a string to column names

What is the easiest way to append a string to columns names?

Not to all of them, but just to some selected ones.

 

Up to now, I used Rename Columns from the Jmp Scripting tools Add-In :
Scripting Tools 

hogi_0-1679406742553.png

But the actions of the Add-In are not captured by the Workflow Builder.

This is why I am interested in how to do it directly in Jmp without the help of an add-in.

 

Replace String from the Recode Column Names menu looks similar.

a)  Is there an option to apply the change just to some selected columns?

b) How must the Regex expression look like to add a string to the existing column names?
   Using the same syntax as in Jmp Scripting tools/Rename Columns,  the appended string is added twice:

hogi_1-1679407747917.png

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Append a string to column names

Here is an example of the way I approach adding text to a column name.

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << select columns( :height, :weight );

selCols = dt << get selected columns( string );

For Each( {col}, selCols,
	Column( col ) << set name( col || " " || "Added Text" )
);
Jim

View solution in original post

6 REPLIES 6
txnelson
Super User

Re: Append a string to column names

Here is an example of the way I approach adding text to a column name.

Names Default To Here( 1 );
dt = 
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << select columns( :height, :weight );

selCols = dt << get selected columns( string );

For Each( {col}, selCols,
	Column( col ) << set name( col || " " || "Added Text" )
);
Jim

Re: Append a string to column names

This might be a completely different direction than you were thinking, but the attached workflow adds a string to all the column names by moving the column names down, transposing the table, adding a column with the constant string of 'abcd,' then concatenating this new column with the column names, and finishes by re-transposing and moving the column names up. It does change all the column modeling data types though, which is likely a problem.

 

To make it add to just some of the column names, you could use a formula column, rather than a constant column.

 

Again, this is less of a solution and more of a potential catalyst for a way to think about it. Perhaps others will chime in with better ideas.

 

jthi
Super User

Re: Append a string to column names

Or using a bit similar idea as @Jed_Campbell had, you could

  1. select the columns of interest and first row
  2. subset with selected rows and columns
  3. drop headers down
  4. transpose
  5. create your new column names
  6. go to recode
  7. use apply mapping from table

 

jthi_1-1679420193421.png

jthi_2-1679420204899.png

jthi_3-1679420216070.png

jthi_0-1679420160617.png

 

-Jarmo
jthi
Super User

Re: Append a string to column names

For regex try using + instead of *

jthi_0-1679413792661.png

 

-Jarmo
hogi
Level XIII

Re: Append a string to column names

great, thanks @jthi .


Hm, for the "apply to some columns" I hope there is some easy solution hiding somewhere in Recode?

hogi
Level XIII

Re: Append a string to column names

Ok, doesn't seem so ....
So, Jmp could be improved by copying this functionality from the Scripting Tools .

Here you can find the corresponding suggestion in the Wish List:
Recode and Recode Column Names: apply for specific rows/columns 

Recommended Articles