Remove trailing whitespace

Hi,

I have a trial balance exported from source system in .csv

I have tried the Data Cleansing tool with Remove "Leading & Trailing Whitespace" checked, however it doesn't work.

So I suspect while it appears to be a trailing whitespace to me, Alteryx is reading it as something else. I am having a similar issue with this data source in Tableau.

If I also check "All Whitespace" within the Data Cleansing Tool, the apparent 'trailing whitespace' is removed but so are all the spaces in my account names

Any ideas?

Input

Accepted answers

MarqueeCrew

Please try:

Regex_replace([field],'[^\x20-\x7E]','')

Cheers,
Mark

MarqueeCrew

Use a multi-field formula on the current field.

All comments

MarqueeCrew

Please try:

Regex_replace([field],'[^\x20-\x7E]','')

Cheers,
Mark

mb1824

Thank you, that worked

RogerA

Hello, i have been trying to get this to work too, but it's not. My data may be slightly different in that i have a regex earlier on in the flow which is removing text between brackets so from:

AB1234 (XY23RG) Widget

AB1234 Widget

I think in doing this using \(.*?\) it's leaving a trailing space as i have two spaces inbetween now. Like the original poster the data cleanse tool is not getting rid of it, and the suggested regex here doesn't appear to work either.

Ishank26

Which of the following options of the Data Cleansing fool can only be used for numeric data types?

A. Leading and Trailing Whitespace

B. Replace with Blanks

C. Replace with 0

D. Tabs, Line Breaks, and Duplicate Whitespace

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703