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 !
Solved! Go to Solution.
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
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
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
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!
I think this will work - Thank you !! Will test it out this weekend and reach out again if I need further clarification !
Thank you !!