[Asterisk-biz] global numbering plans

[Bill Michaelson]

Oh.  OK.  Since I don't have a specific application in mind, it doesn't 
matter much to me.  I converted for load into mysql with this...

gcat bigcountry.csv.gz |sed 's/,/\t/' |sed 's/; /\t/g'>bigco.tsv

I think it's convenient to have it separated into four fields, but I 
don't have a real good reason...  it was just good for noodling with 
various select inquiries.

trixter aka Bret McDanel wrote:

>On Fri, 2005-11-25 at 20:39 -0500, Bill Michaelson wrote:
>  
>
>>That's very nice.  Thanks for providing this.
>>
>>I looked at it briefly, and tried loading it into mysql.  I infer that
>>there are supposed to be four columns, which I described with this...
>>
>>create table intlphone (dialpat varchar(60), country varchar(60),
>>zonetype varchar(60), description varchar(60));
>>
>>The phone is followed by a comma, the country and zonetype by
>>semicolons.  I noticed that the the second semicolon is not
>>consistently present, so my importation process glues many of the
>>description fields onto zonetype.  This isn't deliberate, is it?  It
>>looks like it might be, but I don't think so.
>>
>>    
>>
>
>no its if I have the data I keep it in their format (they used
>semicolons) the only thing I added to their description string was the
>country.  You can be assured that its 
>number,country; other stuff may have semicolons or be empty
>
>also note that its a semicolon then a space.  Dunno if that matters to
>you.
>
>technically its a 2 column csv I could make it 3 easily enough by not
>adding the semicolon after the country and instead using a comma, if
>that is prefered ...  it wouldnt even be that hard to write a script to
>parse that out.  could even do it in bourne shell with cut and echo :)
>
>
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Asterisk-Biz mailing list
>Asterisk-Biz at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-biz
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-biz/attachments/20051125/06980f79/attachment.htm