Returning Values that have numbers in it

[sachinhejeebu]

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

[Bren_Spill]

@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

[Bren_Spill · Accepted solution]

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