[tz] Pulling the data apart ...
AndyLipscomb at decosimo.com
Fri Sep 13 19:32:43 UTC 2013
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
From: tz-bounces at iana.org [mailto:tz-bounces at 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
More information about the tz