Returning Values that have numbers in it
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello!
I am using REGEX_Match to try and return values that have numbers in it. I'm using the formula: "IF REGEX_Match([Field 1], ".*\d+.*")=-1 THEN [Field 1] ELSE Null() ENDIF".
I want the formula to return values even if it has a letter in the field. For example (0124AC243).
For some fields it is returning the values, but others that have letters at the end it isn't recognizing the numbers in it. Any suggestions?
Example of cells that aren't returning:
00002418MXF
Cells that are returning:
R21751076
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sachinhejeebu - it seems to be working correctly when I run the data you have provided. Can you attach a sample workflow containing your error?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Formula seems to be ok.
IF REGEX_Match([Field1], ".*\d+.*")=-1 THEN [Field1] ELSE Null() ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sachinhejeebu your formula is working for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure what you are facing, however if you will share some snippets we could check it, however everything seems to be fine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @sachinhejeebu Try this if this works-
IF REGEX_Match([Field 1], ".*[a-zA-Z].*") = -1 THEN [Field 1] ELSE Null() ENDIF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'll need to scrub the original workflow for sensitive information but here is an example
We're using the Text to Columns to split via a deliminator, then scanning it for an "Invoice Number" essentially. In theory, Row 2 and 3 should both have values in New_Description2.
Thanks for the help! I'll also try the A-zAZ formula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator