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
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