Extracting a Set of numbers from String

[Grail030510]

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 solution]

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

find the workflow attached
mark done if solved.

[alexnajm · Accepted solution]

how about this?

[Grail030510 · Accepted solution]

@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 solution]

@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 solution]

@Grail030510 

FYI.