Renaming columns names with loop

axcelenator1

Hello, 

I have a table which I do the next steps:

The table contains several columns named : "TBG, TBS, TBV". All three columns are containing rows of a delimited content, for instance: 2|5|6|4|7|....

After doing "Text to columns" I will get 27 columns named: "TBG 1 TBG 2......TBG 19, TBS1...TBS19, TBV1...TBV19".

I want to make some loop for renaming the columns names with deleteting the number and appending a saved name. For example:

"TBG John TBG Mos......TBG Cook, TBS John...TBS Cook, TBV John...TBV Cook"

How can I do that?

 

I use JMP11

 

 

msharp

@mjoner has a simple script to do this here:

https://community.jmp.com/t5/JMP-Wish-List/lt-lt-Set-Column-Names-operation/idc-p/72566#M330

 

You would just need to do some text editing to change the numbers to names.