Hi...Definitely need help on this one.
Do we have a formula on how to extract a specific set of numbers (loan number) on a group of text field. Usually the 1st 2 digits starts with 24 or 3 letters with TLC . Posted a sample below. Any help is greatly appreciated.

Sample 1
REF:20130813L1B78J1C000484 RELATED REF:TLC29292271 ID:001235737204 BNF BK: ID: PAYMENT DETAILS: TLC29292271 RTN SNDRF TLC29292271 DD13AUG13 UTA INVALID ACCOUNT

Sample 2
WIRE TYPE:WIRE IN DATE:081313 TIME:1129 ET TRN:2013081300162745 SNDR REF:G0132252494701 SERVICE REF:273692 ID:000759569534 247526918 RICH EDMUNDS 26175770

Sample 3
WIRE TYPE:BOOK IN DATE:081313 TIME:1215 ET TRN:2013081300175615 SNDR REF:13813A5838QN0T53 SERVICE REF: RELATED REF: ID:001235737204 BNF BK: ID: per your request john c chapman loan 247111212