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:

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

Thanks