I had a csv file with some faulty values , i have used replace text and some appropriate regex expression to overcome these faulty values.
But still i am getting an error indicating that i have an abnormal value in one of my columns, but i have gone through each line of the csv file and i cant find anything wrong, leading me to believe that my replace text processor must have included some extra whitespaces in the csv file.
I am not sure that it is only whitespaces, it could be something else also. The csv files contains 1000's of lines and it looks similar to the non-faulty csv files in terms of data. So i am at wits end here, any kind of help would be appreciated.