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 :) -- Trixter http://www.0xdecafbad.com Bret McDanel UK +44 870 340 4605 Germany +49 801 777 555 3402 US +1 360 207 0479 or +1 516 687 5200 FreeWorldDialup: 635378 http://www.sacaug.org/ Sacramento Asterisk Users Group
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Asterisk-Biz mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-biz
