I receive a couple of files daily in .csv format. I have a procedure to open them with file load, do the parsing I need and import them into the working DB.
The problem is when they send files where one of the fields contains a number over 1000, they include a comma in the number, which breaks the import procedure.
This must be a common problem, so wondering the best way to deal with it. Is there a Pan setting to import everything as tab delimited. Or a grep-like way of checking and deleting the offending comma?