You could also run it through a regex (search for \s+ or [:space:]+ depending on your syntax, replace it with \t) and feed the result to your csv library. One thing to be aware of: the fields in zone-continuation lines are one step offset from the zone-start lines. That can also be fixed with a regex: replace \n\t with \n\t\t after doing the previous operation. Andy Lipscomb, CPA • ABV, ASA Senior Financial Analyst Decosimo Advisory Services Direct: 423-266-0292 Phone: 423-756-7100 -----Original Message----- From: tz-bounces@iana.org [mailto:tz-bounces@iana.org] On Behalf Of Lester Caine Sent: Friday 13 September 2013 15:26 To: Time Zone Mailing List Subject: Re: [tz] Pulling the data apart ... Paul Eggert wrote:
On 09/13/2013 11:38 AM, Lester Caine wrote:
Should there be a tab character between 'Zone' and the name?
No, just white space, i.e., a sequence of one or more white space characters. These are spaces, tabs, carriage-returns, form-feeds, or vertical tabs. In practice only spaces and tabs are used, and perhaps we should tighten up the spec along those lines.
The bulk of the data loaded cleanly into a spreadsheet using tabs, and it would not take long to clean up, so I was hoping to get away with the csv library to process records. Can I at least assume that there are no plans to split records across line boundaries? So each one is simply a new line ... -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk