csv input error check

davieboy_xr
04-14-2004, 01:26 PM
i have a a .csv file that i read into my database, i can read it in fine but if there is a comma that should be in the line it halts the input.

Is there any way i can make a error check so that it a user could edit the input line ,so if it has an extra comma in the line they could remove it and save it back to the .csv file and retry loading the csv file?

CrystalWizard
04-14-2004, 01:43 PM
Quick answer; probably not w/o a boat load of work.

However I would suggest trying to catch the comma on input into the csv file.

davieboy_xr
04-14-2004, 02:40 PM
i have trapped the error with on error so ill then delete the database and ask the user to edit the file and display the the line in the csv file which is corrupt. Does this seem like a good way of doing it?

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum