Regex match

[cactooos]

Hi,

I am looking for a way to parse a substring in the form ABCXXXX or ABC-XXXX where XXXX are any digits.

Below example of expected result

text	match
Max has a cat
orange cats ABC7897 are the best	ABC7897
maybe ABC-1234 better than dogs	ABC-1234
but DEF-5678 some not agree

[FrederikE]

Hey @cactooos,

This should do: 

.*ABC[-]?\d+.*

[cactooos]

Thanks but as a result I would need the matched substring rather than just true or false

[steven_king · Accepted solution]

Hey @cactooos, you can add a couple parentheses to the expression and change the Output method to Parse.

[cactooos]

works like a charm, thanks