Leading and Trailing Whitespace

[beacc]

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

[Yoshiro_Fujimori · Accepted solution]

@beacc ,

How about using Multi-Field Formula with Trim functions?

[alexnajm · Accepted solution]

How about this?

[peterr_h]

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

[beacc]

Thank you all 

[txjohnnypops79]