Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

String to Decimals

dkma
8 - Asteroid
‎08-30-2021 12:17 AM

Hello all, 

 

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

 

Kindly help

Labels:
Reply
4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova
‎08-30-2021 12:21 AM

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.

 

atcodedog05_0-1630308071502.png

 

Hope this helps : )

 

Reply
0 Likes
dkma
8 - Asteroid
‎08-30-2021 12:26 AM

Solved!!!!!

 

 

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

Reply
atcodedog05
22 - Nova
22 - Nova
‎08-30-2021 12:28 AM

Hi @dkma 

 

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


Cheers and have a nice day!

Reply
0 Likes
dkma
8 - Asteroid
‎08-30-2021 03:41 AM

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

Reply
go to user group event calendar
Labels