dbTalk Databases Forums  

Country code to Country info

Go Back dbTalk Databases Forums Databases comp.databases Country code to Country info

comp.databases comp.databases


Discuss Country code to Country info in the comp.databases forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Esben
 
Posts: n/a

Default Country code to Country info - 09-01-2007 , 06:25 PM





I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?


:-) Esben

Mail: nameasofabove_h (AT) get2net (DOT) dk

FUT: comp.databases

Reply With Quote
  #2  
Old   
Thomas Kellerer
 
Posts: n/a

Default Re: Country code to Country info - 09-01-2007 , 06:52 PM






Esben wrote on 02.09.2007 01:25:
Quote:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?
A quick search with Google reveals e.g. this one:
http://www.prozzone.com/lookup/list_country_name.htm


Thomas


Reply With Quote
  #3  
Old   
Esben
 
Posts: n/a

Default Re: Country code to Country info - 09-01-2007 , 07:22 PM


Thomas Kellerer <FJIFALSDGVAF (AT) spammotel (DOT) com> wrote:

Quote:
Esben wrote on 02.09.2007 01:25:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?

A quick search with Google reveals e.g. this one:
http://www.prozzone.com/lookup/list_country_name.htm


Thomas
Google is your friend (when they don't intrude on you)

Great! - could actually cut'n'paste that into excel - usually I get
problems trying to do that from a browser. But I realize what a fool I
am, because I need this info in my own language: Danish. But surely I
should be able to find that.

Thanks!

Best regards

:-) Esben



Reply With Quote
  #4  
Old   
Esben
 
Posts: n/a

Default Re: Country code to Country info - 09-01-2007 , 07:36 PM


Esben <esha (AT) nospamget2net (DOT) dk> wrote:

Quote:
Thomas Kellerer <FJIFALSDGVAF (AT) spammotel (DOT) com> wrote:

Esben wrote on 02.09.2007 01:25:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?

A quick search with Google reveals e.g. this one:
http://www.prozzone.com/lookup/list_country_name.htm


Thomas

Google is your friend (when they don't intrude on you)

Great! - could actually cut'n'paste that into excel - usually I get
problems trying to do that from a browser. But I realize what a fool I
am, because I need this info in my own language: Danish. But surely I
should be able to find that.

Thanks!

Best regards

:-) Esben
Found that, too. Gosh I must have lost confidence in the allknowing
internet.

Esben


Reply With Quote
  #5  
Old   
Helpful Harry
 
Posts: n/a

Default Re: Country code to Country info - 09-01-2007 , 10:34 PM


In article <1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk>,
esha (AT) nospamget2net (DOT) dk (Esben) wrote:

Quote:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?
Here's two that a quick Google search turns up.

You should be able to copy paste this one into a spreadsheet:
http://bspage.com/inttel.html use the numbers in the third column.

This wikipeadia one would require a bit more work to extract the
numbers and countries
http://en.wikipedia.org/wiki/List_of..._calling_codes

You could also try the website for your own phone company (or others in
your country).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)


Reply With Quote
  #6  
Old   
Ursus
 
Posts: n/a

Default Re: Country code to Country info - 09-02-2007 , 04:25 PM



"Esben" <esha (AT) nospamget2net (DOT) dk> schreef in bericht
news:1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk...
Quote:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?


:-) Esben

Mail: nameasofabove_h (AT) get2net (DOT) dk

FUT: comp.databases
Esben you dont state version and platform, but generally this one of the
most basic things you are able to do with related tables. Every calculated
field can be the result of any number of related (or not) fields. So this
would be extremely easy to build once you master creating relations.

Keep well, Ursus




Reply With Quote
  #7  
Old   
Esben
 
Posts: n/a

Default Re: Country code to Country info - 09-02-2007 , 04:58 PM


Ursus <ursus.kirk (AT) wanadoo (DOT) nl> wrote:

Quote:
"Esben" <esha (AT) nospamget2net (DOT) dk> schreef in bericht
news:1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk...
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?


:-) Esben

Mail: nameasofabove_h (AT) get2net (DOT) dk

FUT: comp.databases

Esben you dont state version and platform, but generally this one of the
most basic things you are able to do with related tables. Every calculated
field can be the result of any number of related (or not) fields. So this
would be extremely easy to build once you master creating relations.

Keep well, Ursus
I'm not quite mastering it yet but soon will with help from a (once-)
Pro. I'm running Filemaker 9 Advanced on OS X 10.4. It was the data I
thought would be harder to find than they actually were!

Thanks for answering!

Esben


Reply With Quote
  #8  
Old   
Esben
 
Posts: n/a

Default Re: Country code to Country info - 09-02-2007 , 04:58 PM


Helpful Harry <helpful_harry (AT) nom (DOT) de.plume.com> wrote:

Quote:
In article <1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk>,
esha (AT) nospamget2net (DOT) dk (Esben) wrote:

I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?

Here's two that a quick Google search turns up.

You should be able to copy paste this one into a spreadsheet:
http://bspage.com/inttel.html use the numbers in the third column.

This wikipeadia one would require a bit more work to extract the
numbers and countries
http://en.wikipedia.org/wiki/List_of..._calling_codes

You could also try the website for your own phone company (or others in
your country).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
As you may have seen from a subthread, I didn't have my head at the
right place when posting!

But thanks for wanting to help - it's appreciated!

Esben


Reply With Quote
  #9  
Old   
Christoph Bouthillier
 
Posts: n/a

Default Re: Country code to Country info - 09-02-2007 , 07:14 PM





"Esben" <esha (AT) nospamget2net (DOT) dk> schrieb im Newsbeitrag
news:1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk...
Quote:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?


:-) Esben

Mail: nameasofabove_h (AT) get2net (DOT) dk

FUT: comp.databases
Esben,

a nice place to start is

http://www.freedownloadscenter.com/N...try_Codes.html



---
Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---




Reply With Quote
  #10  
Old   
Christoph Bouthillier
 
Posts: n/a

Default Re: Country code to Country info - 09-03-2007 , 05:00 AM





"Esben" <esha (AT) nospamget2net (DOT) dk> schrieb im Newsbeitrag
news:1i3sh0x.1pstspggwbta3N%esha (AT) nospamget2net (DOT) dk...
Quote:
I' d like to construct a relation where entering the name of a Country
automatically enters the country code dial prefix in another field.

For that I need the above info ideally in a tab-separated text file or
something like that.

Anyone who knows where I might find a file like that?


:-) Esben

Mail: nameasofabove_h (AT) get2net (DOT) dk

FUT: comp.databases

[message resent as it seems not to have arrived properly the first time]

Esben,

a good starting point might be:

http://www.freedownloadscenter.com/N...try_Codes.html

Met vriendelijke groet / Mit freundlichen Gruessen / With kind regards
Christoph Bouthillier
p/o\s/t atsign ohnotekstotaaloh nocom
Leave out: \ / oh no
---




Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top