Unanswered: How to convert newline/return carriage character
I am migrating data from an Oracle 8 databse to a DB2 database. The steps I am following are
1. Importing data into an excel sheet.
2. Rearranging the columns according to my current database design which is more or less similar
3. Then saving the excel file as a comma separated file .csv
4 Finally I import the data into DB2 using the import command.
The problem I am facing is that the current data in Oracle has some new line chars which appear like small rectangles in the dbase but when exported in to csv make the text go on to the nextline,
so data which is like this " Johna|than" in the oracle database appears as
because of which I get errors while importing data....