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.