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 ...