Prev: Show a previous instance of app running in system tray
Next: VB6 and Excel
From: a a r o n . k e m p f on 22 Apr 2010 10:27
It's not really practical to code this.

I would call up Experian QAS and buy their address verification
software





On Apr 22, 7:20 am, "Jon Lewis" <jon.le...(a)cutthespambtinternet.com>
wrote:
> 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" <p...(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.le...(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" <nob...(a)nowhere.edu> wrote in message
> >>news:%23r7TD6h4KHA.4520(a)TK2MSFTNGP02.phx.gbl...
>
> >>> "Jon Lewis" <jon.le...(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: Dirk Goldgar on 22 Apr 2010 10:41
"Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message
news:OcAgCci4KHA.1424(a)TK2MSFTNGP04.phx.gbl...
>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!


Have you checked to see if you can do this by automating Outlook?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: "Jon Lewis" jon.lewis on 22 Apr 2010 17:31
I thought about it Dirk but I don't really want Outlook dependency - guess
I'll have to roll my own.
Thanks






"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message
news:%23rZs0ni4KHA.5808(a)TK2MSFTNGP02.phx.gbl...
> "Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message
> news:OcAgCci4KHA.1424(a)TK2MSFTNGP04.phx.gbl...
>>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!
>
>
> Have you checked to see if you can do this by automating Outlook?
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>

From: Boris Pauljev on 23 Apr 2010 01:45
dim sFirstName$
dim sLastName$
dim sTitle$
dim sStreet$
dim sZipCode$
dim sCountry$
(...)

dim sLines() as string
sLines = Split(uText, vbnewline)

dim l&
for l = 0 to ubound(slines)

dim sLine$
sLine = slines(l)

if len(sline)=0 then 'if this line is not empty and not erased by ourselves

'Try to find country first because it's most easy to determine it
if len(sCountry)=0 then
if IsCountry(sLine) then
sCountry = sLine
sLines(l) =""'erase it to clean up what was already processed
end if
elseif len(szipcode)=0 then
if iszipcode(sline) then
sZipCode = sLine
slines(l) = ""'erase it to clean up what was already processed
end if
else
(...)
end if
next l

.... the rest is your work.

From: Jon Lewis on 23 Apr 2010 06:20
Thanks Boris, I've now started working on very similar logic!

Jon


"Boris Pauljev" <nordiccoder(a)hotmail.com> wrote in message
news:%23ePifiq4KHA.4888(a)TK2MSFTNGP06.phx.gbl...
> dim sFirstName$
> dim sLastName$
> dim sTitle$
> dim sStreet$
> dim sZipCode$
> dim sCountry$
> (...)
>
> dim sLines() as string
> sLines = Split(uText, vbnewline)
>
> dim l&
> for l = 0 to ubound(slines)
>
> dim sLine$
> sLine = slines(l)
>
> if len(sline)=0 then 'if this line is not empty and not erased by
> ourselves
>
> 'Try to find country first because it's most easy to determine it
> if len(sCountry)=0 then
> if IsCountry(sLine) then
> sCountry = sLine
> sLines(l) =""'erase it to clean up what was already processed
> end if
> elseif len(szipcode)=0 then
> if iszipcode(sline) then
> sZipCode = sLine
> slines(l) = ""'erase it to clean up what was already processed
> end if
> else
> (...)
> end if
> next l
>
> ... the rest is your work.
>

First  |  Prev  | 
Pages: 1 2
Prev: Show a previous instance of app running in system tray
Next: VB6 and Excel