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:
<text>Has joined the conversation.</text>
<text>Has left the conversation.</text>