Hello, how can I split a column label.
So far I have always done this with EXCEL.
Would like it but synonymous in JMP15Pro can.
In EXCEL 2019:
Column Name = QMHBS016AO_Ap_female_worker
= LEFT (B2; 10) -> QMHBS016AO
= RIGHT (B2; 13) -> female_worker
= LEFT (E2; 6) -> female
= RIGHT (E2; 6) -> worker
Many thanks for your help.