Need a powerful multi-purpose sort utility
Posted on 2013-05-13
Hi gurus, I currently call a 3rd party sort utility within my Delphi app called "Opt-tech Sort". It's very good and does *almost* everything I need, including:
- handling files of unlimited size
- has a facility to Include/Omit records based on user-specified criteria
- has a facility to modify/rearrange the format of the output record any way you like with regards to field order.
The only drawback to this, and it's a big one for me, is that Opt-tech cannot handle fields from a CSV file that have multiple quotes (""") back to back like that. For instance, here is a legit field from a CSV file according to CSV convention:
Opt-Tech sort will see those first two back-to-back quotes and then disregard the whole rest of the field - thinking it has encountered an "empty" field with back-to-back quotes. This situation, naturally, will have disastrous results in my application. Does anyone know of a sort utility (commercial or free) that will handle the above case and tick all my boxes?