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.