Enterprise MRM: mangled CSV output

[prev] [thread] [next] [lurker] [Date index for 2006/12/18]

From: Earle Martin
Subject: Enterprise MRM: mangled CSV output
Date: 14:06 on 18 Dec 2006
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