CSV files with alternate record separators?

[MidiGuy]

I'm trying to work with CSV files that have HTML in some fields. Because of that, I have some line breaks within my files that are not supposed to indicate a new record. I now have the ability to export the data with a different character used as the record separator (not to be confused with the field separator (or delimiter)), but I can't find any way to import the data into either Microsoft Access or OpenOffice with a specific character used as my record separator. Any ideas?

Thanks!

-Midi

 

[DaveSimmons]

Line breaks are ignored in HTML, can you filter them out of your data before generating the CSV file?

Otherwise, if you have a coder there you could export with something like the pipe "|" or a high character (128-255) as the record separator, then write an applet or use a filter program to
(a) first remove all \r\n CR+LF
(b) then translate your special record character back into \r\n CR+LF