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
Solved! Go to Solution.
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?
@hi2019
REGEX_CountMatches([Payee Name],'[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+')
try this.