Jul-26-2018, 04:26 AM
(Jul-25-2018, 09:38 PM)Larz60+ Wrote: the file is not csv, it's slsx
row 210 has html code enbedded in it.
probably some sort of formatting, but if it's not needed, open in a spreadsheet and delete that line, then save as csv file which will be easier to read.
I have attached modified file
I thought there must be a Python way to deal with this.
I have given the sample only, I have total 4000 records in which there are many product code with html data and that should be removed.