TOPIC: [SOLVED] CVS fields not lining up

When somebody enters a lot of info in a comment field it screws up the fields lining up under when I export to csv. I've edited the data to make sure that there are no special characters.

What program are you viewing the data in?

I discovered that when there are hard returns in comment (text area) fields is screws up the field separations. BBEdit, Textedit, Excel, Word. If I remove the hard returns it works out fine. Here is a sample of the error: "02-18-2008[code] "02-18-2008