|
Fields containing embedded reporter-er-line feeds threw me for a loop. The logic of handling embedded quotes is tricky as well.
Personally, I don't see any way to do this without using the FS object. But I really don't see that as a bad thing. Since we are dealing with data, CSV files can get big pretty quickly, which could cause problems with KiXtart's all-in-memory file handling as well.
What makes the standard I referenced so intriguing is that the rules are spelled out clearly. The trick is making a script follow those rules without becoming bloated and slow.
While I felt I could write code that would support the rules, doing it clearly and efficiently is a different matter, and it requires some pretty sophisticated reasoning/coding skills.
That's why I thought it would be a good challenge to this group. FWIW, I'm willing to play too, but I see no chance of me winning this one. I'll be lucky to actually get the code to work, much less make it an object of beauty.
| 
