In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Leading and Trailing Whitespace

beacc
7 - Meteor

Hi everyone,

 

I don't know if is possible, but I have a workflow where I don't want to use the Data Cleansing tool, because is taking too much time.

 

Is it possible to clean Leading and Tariling Whitesapce's with the RegEx tool, I have already tryied but I can't get there.

 

The main objective is to clean the spaces between the "|", before the text to columns tool.

 

Thank you all

5 REPLIES 5
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

@beacc ,

How about using Multi-Field Formula with Trim functions?

Yoshiro_Fujimori_0-1680006368965.png

 

alexnajm
18 - Pollux
18 - Pollux

How about this?Spaces Test.PNG

peterr_h
8 - Asteroid

This is the approach that I'd have suggested too. Looks good!

beacc
7 - Meteor

Thank you all 

txjohnnypops79
8 - Asteroid

txjohnnypops79_0-1682517828767.png

 

Labels
Top Solution Authors