community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Text To Column Help

Highlighted

I have a list of SKUs that come from our oracle business intelligence program as text OR scientific form (example, 1.01E07). I need the scientific form to come through as text (1010000000) so the workflow will calculate properly.  I tried text to column splitting up the data by the "E" but that splits up any SKU with the "E" character in it.  I need those to remain the same.  

 

How can I accomplish this?   

The attached workflow will use Regex to match Item string in Scientific format. It looks for a number followed by an E then an optional +/- and then final a number.

 

If it matches ti convert this to a value then to a string and replace the Item value.

 

This will convert back from the scientific notation but I would see if you can fix the source file to not have these in the first place if possible.

 

Hope it helps

James

 

Thank you so much!

 

We will try to get they system output to change however, the bureaucracy may take a while for that.  This will help in the mean time. 

Bolide

SN1.JPG

EDIT - This will not handle the e+15 or larger numbers.  I did not notice when I posted that it was an issue and was already solved anyway.

Labels