[prev] [thread] [next] [lurker] [Date index for 2006/12/18]
I've been given a CSV file produced by something called "Enterprise MRM"*. Every line looks something like this: "Foo","Members List Report","00003816","Somebody Incorporated23B Snibbits Building69 Foonly StreetLondonFO0 8AR+44 20 7123 4567","a couple","of other", "fields here","Report Run Time: 05 Dec 2006 at 10:53:50","Page -1 of 1","Company Name Snipped ","Enterprise MRM" Firstly, note the four totally useless fields at the end of every line. They're identical every time. Then direct your attention to the fourth field, which has a name and address with all the linebreaks removed. It's my job at the moment to parse this and turn it back into a usable address. Which means a big pile of munging code filled with special case exceptions (international address formats, anyone?). No, they can't give us the data in any other format. HATE. HATE. HATE. * http://www.enterprisemrm.com/: "Membership, Charity, Golf, Leisure, Retail and Schools software. Fully integrated with Sage and Pegasus Accounts." -- Earle Martin http://downlode.org/ http://purl.org/net/earlemartin/
Generated at 00:01 on 20 Dec 2006 by mariachi 0.52