SOLVED
Regex stuck
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hi2019
8 - Asteroid
‎08-15-2024
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Reporting
2 REPLIES 2
‎08-15-2024
08:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎08-15-2024
08:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hi2019
REGEX_CountMatches([Payee Name],'[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+[A-Za-z]+[\s,\.]+')
try this.
