Hi,I have a file that is dropped into our FTP are and I will be using a data migration job to create a table from the data. The issues I am having are:one of the columns I need has carriage returns in it . Is there a way to strip them out when importing the data. The date format is 16/05/2023 12:09:25, is there a way to import date and timeThanks

Question

Data migration field formatting

+10

Hi,

I have a file that is dropped into our FTP are and I will be using a data migration job to create a table from the data. The issues I am having are:

one of the columns I need has carriage returns in it . Is there a way to strip them out when importing the data.
The date format is 16/05/2023 12:09:25, is there a way to import date and time

Thanks