Extracting a Set of numbers from String

Question

I would like to ask for help and guidance,

What is the best format to use in RegEx in extracting the set of numbers coming from the following set

Example:

Loan Number: 423454546565_x000D_     Extracted Should be:   423454546565

or

Loan #: 1234567894_x000D_                    Extracted Should be: 1234567894

or

Re Loan #: 1234567890_x000D_               Extracted Should be: 1234567890

Thank you so much in advance

Raj · Accepted Answer

@Grail030510 
use this in reg ex
(\d+)_x000D_

find the workflow attached
mark done if solved.

alexnajm · Accepted Answer

how about this?

Grail030510 · Accepted Answer

@alexnajm AND @Raj

Sorry for the long feedback, Both of your solution works great, though I have one last question, Is there a way that I can solve this issue.

Given:

Serial Number: 204 345 1234

To be extracted:

2043451234

Thank you.

alexnajm · Accepted Answer

@Grail030510 fantastic - if you could then accept one or multiple replies as the solution, it would be greatly appreciated.

For your second question, you would just use a Replace function to replace the space with nothing - Replace([Serial Number], " ", "")

flying008 · Accepted Answer

@Grail030510

FYI.