Quick Tip: Double Quoted CSV Data

Sometimes I get SAP data that is quoted with both single quotes and double quotes. The data looks something like this: “‘001′”,”’01′”,”‘100123′”,”‘#’”,”‘#’”,”‘#’”,”‘100123′” CSVFIX will strip out the extra single quotes with the following command: csvfix read_dsv -s “,” -csv Input_File1.csv > Output_File1.csv Seems unneeded but otherwise your output is double quoted. I blame SAP. The…