carriage returns within a field and exporting files

[Pia]

I migrated from 6 to 7, the solution contains 6 files. I have a script, which has worked for about 6 years, exporting selected records into a tab delimited text file, for uploading to online databases.

Now, in 7, some records which have one field wherein there are several paragraphs of text (when written a carriage return was used to create the paragraph separations), get extra tabs, and are rejected by the online databases, because they appear to contain more fields than they should, because of the paragraph separations appearing as tab markers. When I look at the textfile in BBEdit I can clearly see the "extra" tab markers. How can I deal with this?

thanks,

Pia