2 Replies Latest reply on Aug 23, 2012 3:23 AM by scbody

    Parsing multiline text records

    scbody

      Title

      Parsing multiline text records

      Post

      Hi

      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