Data Cleansing

[aberthiaume]

I need to cleanse a value field in my workflow.  The problem is I need to cleanse it of " " but not decimals.  When I cleanse punctuations it removes the decimals, thus skewing the numbers.  

Thank you! 

[Aaron_Harter · Accepted solution]

Hi @aberthiaume, 

You can perform this cleanse function with some RegEx or the attached formula:

[CharlieS]

Hi @aberthiaume ,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Happy Alteryx-ing!