AnsweredAssumed Answered

Extracting line of text from logging field

Question asked by rlayman on Dec 10, 2017
Latest reply on Dec 10, 2017 by rlayman

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.