Regex for strings

[mhafizyi]

Hi,

I have these data type string in one column,

0893411001

How can I convert it into a 5 column like below and change the last column 001 into a number type?

089

08934

0893411

0893411001

001

I tried using regex but didn't produce a result. Thank you

[ponraj · Accepted solution]

Here is the solution.  Converting last column into number type will remove 00. Hence, uploading workflow without converting last column into number type. 

[mhafizyi]

Hi ponraj,

It was easy than I expected. I have been googling around for an hour before came here. Thanks for the guidance.