RegEx expression

Here is the description, the description is wrapped in one Excel cell.

Legal Entity: ABC Inc.

Account Name: ABC - JPM Chase account

Account #: 123456

ABA Routing #: 997889000

Currency: USD
Bank: JPM Chase

Bank Location: xxxxxxxxxxxxxxx

ID: xxxxxxxxxxxxx

How do I write the RegEx expression so that it extracts only the account number "123456" as my output?

Developer Tools

Input

Regex

Output

Expression

Accepted answers

All comments

@sylvia0218 - see attached. I'm sure the regex experts on here could do a more efficient job!

@sylvia0218
If we dont use the RegEx tool 😁

0626-sylvia0218.yxmd

@sylvia0218 use the following in formula tool:
REGEX_Replace([YourFieldName], ".*Account #: (\d+).*", "$1")

hope this helps.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703