Remove trailing whitespace

[mb1824]

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?

[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