AnsweredAssumed Answered

Extract number from text

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


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?

Thanks, Will