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

Data migration field formatting

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

Be the first to reply!