CSV import with newline chars in fields

[twinspop]

The MySQL DB I'm attempting to import has many records with fields containing new line characters. FM treats these as record separators regardless of the various ways I try to delineate fields within records (eg, enclosing each field in quotes).

Any tips on how to handle records like this?

thanks!

[twinspop]

I gave up. :-(

Since FM ODBC is apparently badly b0rked on OSX, I had to resort to using a Windoze XP box over VNC to make an ODBC connection to the MySQL server. Worked like a champ on first attempt, after wasting hours fzcking around with FM and OSX ODBC.

<shaking head> can't understand why Apple and/or Filemaker can't make ODBC work as well as MS does. Arg.

[sbv0001]

Why did you decide not to try XML?

[twinspop]

XML failed as well. First, there were non-standard characters in the dataset. Then, after removing those, FM said upon import (trying to remember) something about 'password' entity not defined, referencing the very last line of the last record. Remove the last record, and the error ref moved up to the previous.

Granted, I'm an XML nooB, so the problem was very likely PEBCAK.

I'm still frustrated that ODBC worked so well in Windows and so poorly (read: not at all) in OSX.