SOLVED
Regex Match No Space Only Numbers
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
slckkrky
8 - Asteroid
‎11-29-2019
04:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I am trying to capture records that contain only number and no space anywhere in the record. I am using REGEX_Match([Field1], '^\d.\s*') in my test input and it works as I desire (Column Regex).
However when I use same formula in my real data set (same data type as test dataset), it doesnot work properly.
Any idea what would cause that?
Thank you
Solved! Go to Solution.
Labels:
- Labels:
- Regex
1 REPLY 1
17 - Castor
‎11-29-2019
04:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @slckkrky
I think the ideal regex in this case would be
REGEX_Match([Field1], '\d+')
If you only want numbers in the record.
Cheers,
