AnsweredAssumed Answered

Parsing Text

Question asked by JimCobb on Aug 10, 2010

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!

Outcomes