String to Decimals

[dkma]

Hello all, 

I have this Number "8.33333333333321e-0" in String format, How to convert this to Fixed Decimals format. 

Kindly help

[atcodedog05]

Hi @dkma 

using a select tool and setting to fixed decimal like below should work. If it doesn't work can you provide sample data.

Hope this helps : )

[dkma]

Solved!!!!!

Trimright("8.33333333333321e-0", "e")  and then to Fixed Decimals

[atcodedog05]

Hi @dkma 

Strange it should have worked like that only. Anyways happy to hear it's solved.

Cheers and have a nice day!

[dkma]

Hi @atcodedog05 ,

Actually , The data contains many numbers and strings in a columns, as per Solved: Re: Converting string to Number - Alteryx Community, 

Used regular expressions to find only numbes in the string the above number contains string and numbers, so I trimmed and changed it to Fixed Decimals.

Thanks for looking into it