I need to extract a string of words from a text field. The field is a log for processing freight orders, with each log entry added as a line of text at the start of the field contents. Each log entry is a line ending with a carriage return.
The string I want always lies 5 to 10 lines down from the start of the text, and its line always ends with the string "DELIVERED = X". At the beginning of the same line, about 10 or so words to the left, is the date and time, which is the information I need.
The clip below shows a sample of the text:
09/01/2014 3:21:32 PM: By Nicole, PRICE = 350
09/01/2014 3:21:29 PM: By Nicole, CAR_INV_N0 = 409093
06/01/2014 10:06:35 AM: By Rose, DELIVERED = X
03/01/2014 1:03:18 PM: By Rose, PICKED_UP = X
02/01/2014 11:20:58 AM: By David, PRICE = 400
Is there a simple way to do this? I have looked at custom functions but they are more complex than my current level of Filemaker expertise.