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
@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.
