Hi,
I am trying to migrate data into Aps10 Upd10 using csv as input file. The data has newlines, tabs and some special characters like £,€,©,º,≠,≈
When the data has newlines, the CREATE_TABLE_FROM_FILE job reads it as the next record. I have to remove the newlines from the data if i have to load them correctly. Is there a solution for this so that i can retain the newlines in the data?
Also if the data has special characters like º,≠,≈ , then the csv file doesn’t display them properly. Hence when I load the data into IC table, it replaces these characters with ‘?’.
Some of the character do work fine like £,€ . Is there any list of special characters that is not supported when using csv migration?
Kindly guide.
