Forum Discussion
split 1 column into more columns
It can be done with the formula bar or the Advanced Editor.
Typically I would choose some text colum and choose Format - Trim in the Transform menu, just to create some base code.
Sometimes I even create some dummy text colum first and use this column to create the base code.
Then I adjust the code to the required transformation.
If applicable, the step in which the dummy text column was created, can be removed.
It can be done with the formula bar or the Advanced Editor.
Typically I would choose some text colum and choose Format - Trim in the Transform menu, just to create some base code.
Sometimes I even create some dummy text colum first and use this column to create the base code.
Then I adjust the code to the required transformation.
If applicable, the step in which the dummy text column was created, can be removed.
Thanks Marcel.