AnsweredAssumed Answered

Extract number from text

Question asked by WillLockwood on Jun 18, 2012
Latest reply on Dec 15, 2016 by FileMakerMentor

Title

Extract number from text

Post

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?

Thanks, Will

 

Outcomes