I have a column with value in string format i.e 00000036, i want to convert it to decimal i.e it should show 36.000000 in the output or let say if i have 00000006 then it should show 6.0000000, The value always needs to be 8 characters
Please let me know how can i achieve this. I used decimal function but it did not help me get the desired result
try format-number and pad-string-right:
