AnsweredAssumed Answered

Parsing multiline text records

Question asked by scbody on Aug 22, 2012
Latest reply on Aug 23, 2012 by scbody


Parsing multiline text records



I've got large text files (1-200MB) containg multiple (1,000-1,000,000) text reports in each file that I need to import into FMP.

Each report begins with a line terminated by a LF that contains an identifier that defines a class of report and an identifier for a a person ID.  Following that line there are a variable number of lines each terminated by a LF, Finally the report ends with the text [endreport] and another LF.

I need to import these files and assign each report to a person using the person ID and to a report class based on that identifier.

I'd appreciate advice on how to do this.

Thank you