<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
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...<br>
<br>
gcat bigcountry.csv.gz |sed 's/,/\t/' |sed 's/; /\t/g'>bigco.tsv<br>
<br>
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.<br>
<br>
trixter aka Bret McDanel wrote:<br>
<blockquote type="cite"
cite="mid1132970254.3918.74.camel@rufus.home.tld">
<pre wrap="">On Fri, 2005-11-25 at 20:39 -0500, Bill Michaelson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
</pre>
</blockquote>
<pre wrap=""><!---->
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 :)
</pre>
<pre wrap="">
<hr width="90%" size="4">
_______________________________________________
Asterisk-Biz mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Asterisk-Biz@lists.digium.com">Asterisk-Biz@lists.digium.com</a>
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-biz">http://lists.digium.com/mailman/listinfo/asterisk-biz</a>
</pre>
</blockquote>
</body>
</html>