Regex finding leading, trailing and double or more spaces

[garaya]

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!

[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

[PhilippK · Accepted solution]

ah got it - please find the solution attached.

Have a great day

Phil

[jdunkerley79 · Accepted solution]

The match function is comparing the whole string so try:

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

[garaya]

Thanks! this works!

[garaya]

Thanks this works!

[MarqueeCrew]

@jdunkerley79 ,

You answered exactly as I was about to do the same.

Cheers,

Mark