How to replace special characters with the newline from CSV file?
Posted on 2007-09-28
I have a field called MessageBody in my CSV file and I would like to keep the format of that field.
I use to perl to parse data file into a CSV file and because of the CSV file, I had to replace the newline with the special character, `_` in my case.
What I want to do is import the CSV file into the SQL database.
I open the CSV in EXCEL to see I parse the data correctly in PERL.
From Excel, I try to use find/replace function to find `_` but it didn't go.
Basically I want to restore the newline in my CSV file to keep the format when I import into the SQL sever.
Any idea if I can do this.