Invalid line break character in textarea data capture breaks my csv extract tools
Posted on 2007-03-17
I have various text area fileds in different forms.
Every now and then someone enters data which creates a funny line break character. It comes out as a rectangular box in SQL Server.
Although the data capture looks ok when viewed in HTML, if i build a CSV extract tool it breaks the record. When the CSV file approaches this line break, it breaks teh CSV extract because it thinks it is a new line.
Is there a way around this but converting the textarea data as it is being captured, or while it is being written to a CSV file?