Author: nayanancha | Posted on: 7/13/2010 12:11:01 PM | Views : 496

I have a multiline texbox with address field.
it is being entered into the DB with its type varchar.
Since its a multiline textbox, User may press enter and it creates a new line.
When I am trying to export it into a CSV file its coming into a new row when theres a new line which I dont want to.
When I Exported to CSV, the new record is not formatted correctly - the address information wrapped to a new line, so the record is taking up 2 lines (see below)

Cust_ID
FirstName
LastName
Email
SecEmail
Bday
Aday
Phone
Addr
7795
AAAA

BBBBBB
Abc@xyz.com


Go to the complete details ...