January 2007 Entries

Delimited data - a pragmatic approach

In quite a few projects I have to process delimited data in some form, either from App.Config settings or via interfaces to other applications and systems. Normally people use CSV formatting, separation by the comma character, however that makes life complicated if the data needs to contain commas as well. Export a Microsoft Excel worksheet as CSV and look at the complex rules about using double quotes to retain commas, thereby introducing issues when a cell contains both a comma and double quotes ......

Long time no posts

Apologies for gap in blogs - major project launching a live shopping channel in the Netherlands meant I was horribly busy all the way up to Christmas.

New Year's Resolution - must do better.

Liam