Removal of E error in text

[KSassone]

We have several records that contain field data of "30E33" that when uploaded will changes into "3.00E+34".  I need to find a Cleansing Tool that will recognize the error and correct during my workflow.  Please Note: I am not at liberty to change the offending data prior to upload.

Currently I manually change the data for all my reports but would love to find a tool that can help.

Any ideas, warmly welcomed ! 

[fmvizcaino]

Hi @KSassone ,

Where do you get this data from? Do you have a sample of your dataset for me to check all possibilities?

Do you want to keep the 30E30 as it is, right? To keep as text or to keep as a number 30E30?

Best,

Fernando Vizcaino

[KSassone]

Hi Fernando,

Sample data attached.  Yes I need to keep the examples as text, and not the automated excel error result.  I know what excel is doing, but I want to clean the data prior to input into my workflow process as I cannot change Location text.

Any help, very much appreciated !

Kindest regards,

Kiri Sassone

[fmvizcaino · Accepted solution]

Hi @KSassone ,

I'm attaching a not so elegant cleansing to the problem you're having.

Since I'm not sure if all your rows presents the same problem, I added a statement to leave as null other occurrencies.

Best,

Fernando Vizcaino

[KSassone]

Thank you for this!  I have come across a version issue as it looks like we are still on an earlier version of Designer. I will need to download the latest version to view your file! 

[fmvizcaino · Accepted solution]

Hi,

There is no need for that. You can change the workflow format temporarily
to xml and change the first or second line where it says the alteryx
version. You can insert yours or lower. Then change it back to yxmd

Best,
Fernando V.

[KSassone]

I think this will work - Thank you !!  Will test it out this weekend and reach out again if I need further clarification !

Thank you !!