This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 !!