how to validate data formate befre pushing in to data base from csv file.
I have an application which is reading data from csv file and push in to data base. But I want to check the data formate before push in to database. Whether the data formate is correct or wrong. if the data is correct then this should push in to data base. if the data is wrong then this should push in to failed csv file. (please remember the data formate is only data types like int, string, date like that).
Can any body help on this!