I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type in properties and got this 'Microsoft Excel Comma Separated Values File (.csv)'.
I opened the csv file and saved it in CSV(comma delimited) format in Excel 2010. It asked me the csv may contain features that are not compatible with CSV(comma delimited) and remove all incompabilites while saving. After this step, I was able to generate PDF from the CSV.
I think some white spaces, special characters should have been removed while I did the save. Since this is intermittent, I cannot change the format of the CSV we get from the DB. Also, the data in CSV is huge,
1) Is there any method to keep the (Microsoft Excel Comma Separated Values File (.csv)) CSV format and remove all the special characters, white spaces?