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.