March 19, 200421 yr That's because CSV format does not permit carriage returns within fields themselves, because they are reserved for "end of record" characters. Try exporting as html.
March 19, 200421 yr Are you using a Mac? If so: I wrote a program for OS 9 that takes tab-delimited FileMaker exports and converts fields to lines. I just recoded it into an AppleScript for OS X last weekend. If you use Windows, I could see how hard it will be to port it (the algorithm is very simple). Let me know if you want it.
March 19, 200421 yr The only problem is that the resulting file likely won't be compatible with anything. A linebreak character will still indicate End-of-Record to the program that eventually imports the data. Maybe, if the field is enclosed in quotes it might work.
March 21, 200421 yr Author I am using a program called autoit www.hiddensoft.com It changes the file and makes it exactly as i need it. It is an amazing program once you learn how to use it.
Create an account or sign in to comment