Address parsing algorithm needed please
in [Visual Basic]
|
From: Jon Lewis on 22 Apr 2010 08:34 Hi, I'm looking for an Address parsing algorithm in VB6/VBA, preferably for UK addresses. I want to replicate what Microsoft Outlook does if you paste an complete address in the address field of a Contact record when the Check Details box pops up with an estimated parsing into Street, City, Region etc. (Have Googled to no avail.) TIA
From: MikeD on 22 Apr 2010 09:19 "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message news:echZfgh4KHA.4156(a)TK2MSFTNGP06.phx.gbl... > Hi, I'm looking for an Address parsing algorithm in VB6/VBA, preferably > for UK addresses. I want to replicate what Microsoft Outlook does if you > paste an complete address in the address field of a Contact record when > the Check Details box pops up with an estimated parsing into Street, City, > Region etc. (Have Googled to no avail.) > What have you tried to do so far on your own? What problem(s) are you encountering? -- Mike
From: Jon Lewis on 22 Apr 2010 09:44 No problems as such. I'm refering to the logic required to parse a single address text string into street, city, region, post code etc. Just seeing if I can find a ready made algorithm before attempting to write my own. Jon "MikeD" <nobody(a)nowhere.edu> wrote in message news:%23r7TD6h4KHA.4520(a)TK2MSFTNGP02.phx.gbl... > > > "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message > news:echZfgh4KHA.4156(a)TK2MSFTNGP06.phx.gbl... >> Hi, I'm looking for an Address parsing algorithm in VB6/VBA, preferably >> for UK addresses. I want to replicate what Microsoft Outlook does if you >> paste an complete address in the address field of a Contact record when >> the Check Details box pops up with an estimated parsing into Street, >> City, Region etc. (Have Googled to no avail.) >> > > > What have you tried to do so far on your own? What problem(s) are you > encountering? > > -- > Mike > > >
From: Paul Shapiro on 22 Apr 2010 09:49 There won't be an easy answer. Even if you assume that all entries are correctly formatted, the allowed variations are too big to make this easy. There are commercial applications that do this nicely, but they were pricy the last time I looked. With the advent of web services, maybe some of these have more reasonably priced subscriptions now. You can search for "address correction software". "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message news:OW4d9Hi4KHA.1932(a)TK2MSFTNGP05.phx.gbl... > No problems as such. I'm refering to the logic required to parse a single > address text string into street, city, region, post code etc. Just seeing > if I can find a ready made algorithm before attempting to write my own. > > Jon > > > "MikeD" <nobody(a)nowhere.edu> wrote in message > news:%23r7TD6h4KHA.4520(a)TK2MSFTNGP02.phx.gbl... >> >> >> "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message >> news:echZfgh4KHA.4156(a)TK2MSFTNGP06.phx.gbl... >>> Hi, I'm looking for an Address parsing algorithm in VB6/VBA, preferably >>> for UK addresses. I want to replicate what Microsoft Outlook does if >>> you paste an complete address in the address field of a Contact record >>> when the Check Details box pops up with an estimated parsing into >>> Street, City, Region etc. (Have Googled to no avail.) >>> >> >> >> What have you tried to do so far on your own? What problem(s) are you >> encountering? >> -- >> Mike
From: Jon Lewis on 22 Apr 2010 10:20 I know it's not easy logic and I'm not bothered with data cleasing - I just need an algorithm to use for splitting a chunk of Contact data from say a web page to paste into a database of separate address fields via a check form (like the Outlook form described in my original post). I thought that Outlook's method may have been replicated though I'm not too hopeful! "Paul Shapiro" <paul(a)hideme.broadwayData.com> wrote in message news:eN3TyKi4KHA.980(a)TK2MSFTNGP04.phx.gbl... > There won't be an easy answer. Even if you assume that all entries are > correctly formatted, the allowed variations are too big to make this easy. > There are commercial applications that do this nicely, but they were pricy > the last time I looked. With the advent of web services, maybe some of > these have more reasonably priced subscriptions now. You can search for > "address correction software". > > "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message > news:OW4d9Hi4KHA.1932(a)TK2MSFTNGP05.phx.gbl... >> No problems as such. I'm refering to the logic required to parse a >> single address text string into street, city, region, post code etc. >> Just seeing if I can find a ready made algorithm before attempting to >> write my own. >> >> Jon >> >> >> "MikeD" <nobody(a)nowhere.edu> wrote in message >> news:%23r7TD6h4KHA.4520(a)TK2MSFTNGP02.phx.gbl... >>> >>> >>> "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message >>> news:echZfgh4KHA.4156(a)TK2MSFTNGP06.phx.gbl... >>>> Hi, I'm looking for an Address parsing algorithm in VB6/VBA, preferably >>>> for UK addresses. I want to replicate what Microsoft Outlook does if >>>> you paste an complete address in the address field of a Contact record >>>> when the Check Details box pops up with an estimated parsing into >>>> Street, City, Region etc. (Have Googled to no avail.) >>>> >>> >>> >>> What have you tried to do so far on your own? What problem(s) are you >>> encountering? >>> -- >>> Mike >
|
Next
|
Last
Pages: 1 2 Prev: Show a previous instance of app running in system tray Next: VB6 and Excel |