Sort isn't working correctly
I specified that the extracted data be output to a comma-separated values (CSV) file. In Excel, I opened the CSV file by ticking "Delimited", unticking the "tab" delimiter and ticking the "comma" delimiter. Â*Apparently, that "corrupted" the filenames so Excel couldn't sort the data correctly.
I re-extracted the data by specifying the data be output to a comma-separated values (CSV) file. In Excel, I opened the CSV file by again ticking "Delimited" but leaving the "tab" delimiter ticked. Â*This time, the filenames did not become corrupted and Excel sorted the data correctly.
|