0 Replies Latest reply on Aug 10, 2010 9:07 AM by JimCobb

    Parsing Text

    JimCobb

      Title

      Parsing Text

      Post

      OK, I'm stumped. I have a data file where I'd like to import the following into 3 fields, sender, date_time and Message.  I have been able to parse the text out of the lines, but I've not been able to get the 3 chunks of data into one record. It always winds up in 3 records.

      If I export to Excel, it's a simple matter of shifting the date_time and message columns up to sync the data. I've spend a couple of days now trying to consolidate the 3 fields into one in filemaker and cannot figure it out.

      So, I am guessing that the secret must be to get the data into the correct records during an import, not after the fact.

      I'd appreciate any ideas or suggestions-

      Here are 2 records out of the XML file:

      <message>

      <sender>Ryan Harrison</sender>

      <time>2010-05-19T21:02:32Z</time>

      <text>Has joined the conversation.</text>

      </message>

      <message>

      <sender>Jeremy Wright</sender>

      <time>2010-05-19T21:02:32Z</time>

      <text>Has left the conversation.</text>

      </message>

      Thank you!