Recently I had the pleasure to work with CSV files. And it ended in a CSV hell for me! The functionality I wanted wasn't available anywhere (As often happens when you provide custom solutions to your clients!) The client didn't want to rely completely on the system! (I question the need for the system in such circumstances, but the client wanted the system! Brilliant! Kind of like 'hey, I'll be travelling in Bus but just in case lets have that train available and tracks laid out!) Anyway, I couldn't get them to change their preference and so this hell started. Now the situation is the client uses OpenOffice and/or MS Excel to edit the CSV's. They have excelsheets for the data and they export that to csv. I assumed I could write a parser for CSV and that would be it. But when I got to the task I just couldn't figure out the correct logic. One logic worked for some and failed for some other data and the other worked for some and failed for some other. Aft...