cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Use World Cup data to build models, explore spatial relationships, and create informative visualizations in JMP. Register. July 17, 2 pm US Eastern Time.
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

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