Text to Columns
20 August, 2014
Hi,
Is there a possibility to convert text with spaces into multi columns (using the space as a seperator) just like MS Excel does?
Is there a possibility to convert text with spaces into multi columns (using the space as a seperator) just like MS Excel does?
Hi Yelloobee,
Currently there is no function in Yellowfin that will do this for you automatically.
I have raised an enhancement request for this (TASK ID = 170988)
However, if you can find some SQL to do this for you , you can use the SQL in a virtual table, or freehand calc field.
Please let me know if you manage to find some SQL to do this for you.
Regards,
David
Currently there is no function in Yellowfin that will do this for you automatically.
I have raised an enhancement request for this (TASK ID = 170988)
However, if you can find some SQL to do this for you , you can use the SQL in a virtual table, or freehand calc field.
Please let me know if you manage to find some SQL to do this for you.
Regards,
David