Extract number from text
I'm trying to extract a seven digit number from a text field. The number location is random in the text and has no significant prefix or suffix. It is not a phone number.
For example the text might read like this:
JoeFoo 6/17/2012: I found out that I need to order part 2469842 in order to complete the job. Please send via fed ex overnight.
or second case:
MoeFoo 6/18/2012: We need 5 copies of #9876543 sent out overnight please.
The goal is to extract 2469842 in the first case and 9876543 in the second. Is there a simple way to achieve this reliably?