Returning Values that have numbers in it

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

Regex

Accepted answers

Bren_Spill2

@sachinhejeebu - in your screen shot attached the * is missing from the regex_match formula

All comments

Bren_Spill2

@sachinhejeebu - it seems to be working correctly when I run the data you have provided. Can you attach a sample workflow containing your error?

cjaneczko

Formula seems to be ok.

IF REGEX_Match([Field1], ".*\d+.*")=-1 THEN [Field1] ELSE Null() ENDIF

OTrieger

@sachinhejeebu your formula is working for me.

OTrieger

Not sure what you are facing, however if you will share some snippets we could check it, however everything seems to be fine

TUSHAR050392

Hey @sachinhejeebu Try this if this works-

IF REGEX_Match([Field 1], ".*[a-zA-Z].*") = -1 THEN [Field 1] ELSE Null() ENDIF

sachinhejeebu

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

2a532ef5-3054-4871-adba-3cd6dd4c9cf8.PNG

Bren_Spill2

@sachinhejeebu - in your screen shot attached the * is missing from the regex_match formula

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703