Alteryx Designer Desktop Discussions

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

Regex stuck

hi2019
8 - Asteroid

REGEX_CountMatches([Payee Name],'[A-Za-z]+\s[A-Za-z]+\s[A-Za-z]+\s+')

 

 

does this taking count of 3 spaces even if it has commas, or period?

 

thanks

2 REPLIES 2
hi2019
8 - Asteroid

I did this first when I removed the commas and now its not working once I left the commas in ---can I still use this?

 

 

Raj
16 - Nebula

@hi2019 
REGEX_CountMatches([Payee Name],'[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+')
try this.

Labels