Removing unwanted data when importing from CSV file

mrkipling

Registered User.
Local time
Today, 11:48
Joined
Mar 19, 2003
Messages
22
I have a script triggered by a timer, that imports csv files when they are uploaded to a file.
In one of the fields - "Car Description" each record has some unwanted characters at the beginning and the end. These unwanted characters are the same in each record.

Can i set anything in table design that will not allow these charactes to be imported, or will I need to remove these characters another way.

Thanks

Mark
 
You'll need to run an update query after the data is imported.
 

Users who are viewing this thread

Back
Top Bottom