cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

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

Add prefix column names (no scripting)

I am using JMP 19.1.0 with this fantastic function of "Columns manager". I was wondering if there is a way to add prefix to our columns names for all of them at once? I seem to not find any option in the menus that performs this automatically.

Thanks!

francescbernad_0-1778228205806.png

 

 

Francesc B (Stability Scientist)
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Add prefix column names (no scripting)

Use Recode Column Names

jthi_1-1778231779485.png

Though I'm not exactly sure if there are better options than utilizing regex (without some scripting)

jthi_2-1778232020850.png

 

-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: Add prefix column names (no scripting)

Use Recode Column Names

jthi_1-1778231779485.png

Though I'm not exactly sure if there are better options than utilizing regex (without some scripting)

jthi_2-1778232020850.png

 

-Jarmo

Re: Add prefix column names (no scripting)

Thanks for your answer Jarmo! Do you know by chance any easy webpage for "dummies" in regex like me, to be able to start using them?? Thanks in advance

Francesc B (Stability Scientist)
jthi
Super User

Re: Add prefix column names (no scripting)

In this case I did just know I could use Recode's Replace String with Regex to do what you asked.

In general, https://regex101.com/ is the one I use when testing regex, just be careful with company data as always.

jthi_0-1778668056676.png

LLMs are also quite good with regex, so you can try asking from them. 

-Jarmo

Recommended Articles