CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad. Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.
Check this link for steps on how to find and replace the new line character in excel.
Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job. REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))
CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad. Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.
Check this link for steps on how to find and replace the new line character in excel.
Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job. REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
