Regex finding leading, trailing and double or more spaces

Hi All,

I'd like to request your support to understand what's wrong with the way I'm using the RegEx tool. I'm tring to find the leading, trailing and double or more spaces in a string. I've tested the regular expressions and seems to be working fine but, these does not work in Alteryx.

Best!

Test Data.xlsx

Whitespaces.yxmd

Regex

Accepted answers

PhilippK

ah got it - please find the solution attached.

Have a great day

Phil

Whitespaces_solution.yxmd

jdunkerley79

The match function is comparing the whole string so try:

Leading: ^\s+.*
Trailing: .*\s+$
Contains: .*\s{2,}.*

All comments

PhilippK

Hi @garaya ,

one of the cool thing about Alteryx is simplifying everything. You don't need complicated RegEx for this, just use the Data Cleansing Tool:

Best regards

Phil

garaya

Hi Phil,

Thanks, I know the Data cleansing tool can help me to remove the whitespaces. However, in this case I just need to pin point the errors, is more related to metrics.

Best regards,

Gustavo

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703