Hi,
I have these data type string in one column,
How can I convert it into a 5 column like below and change the last column 001 into a number type?
I tried using regex but didn't produce a result. Thank you
Here is the solution. Converting last column into number type will remove 00. Hence, uploading workflow without converting last column into number type.
Hi ponraj,
It was easy than I expected. I have been googling around for an hour before came here. Thanks for the guidance.