Create a temp file, and populate it with
variations of the name in question (upcase and remove
spaces). (Storing address
information in each record)
Then loop through your list, taking the
name, and parsing the various combinations of the words.
( John David Doe - JOHNDOE,
DOEJOHN JOHNDAVIDDOE, JOHNDOEDAVID)
And attempt to read the item from the temp
file, if it can read an item then verify the address information. Otherwise check the next item.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of George Gallen
Sent: Tuesday, January 27, 2004
12:13 PM
To: 'U2 Users Discussion List'
Subject: RE: looking for faster
Ideas...
in rethinking my take on
that. That would still be difficult
since the arrays would
only contain "parts" of the whole fields.
making the searching of
the arrays very difficult.
We can't store the exact
entry, since sometimes people will
call and say stop sending
me things and not give us the name
the same way it's in the
database we rent.
Basically it takes the
renting company a couple months to remove
the name, but we like to
filter it immediately to stop anything
from going out before the
renting company removes it, and it
also will catch it if the
renting company replaces it in a couple
-----Original Message-----
From: George Gallen
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 27, 2004
2:06 PM
To: 'U2 Users Discussion List'
Subject: RE: looking for faster
Ideas...
I can't just check for names, it has to a name with a
specific zip code
and if the name is fairly common,
we also add in part of the address to
make sure no one else is weeded out
that shouldn't be.
I suppose I could keep two or three arrays, do a
specific lookup in each
saving the position, and if all
three positions are identicle (asuming all
three arrays have the name,
address, zip in the same order) then that would
be a match....Thanks
George
>-----Original Message-----
>From: Jeff Schasny [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 27, 2004
1:51 PM
>To: U2 Users Discussion List
>Subject: RE: looking for faster
Ideas...
>
>
>how about keeping a list of
excluded names as a record in a
>file (or as a
>flat file in a directory with
each name/item/whatever on a
>line) and reading
>it into the program as a
dynamic array then doing a locate on
>the string in
>question. Something like
this:
>
>
>READ ALIST FROM AFILE,SOME-ID
ELSE STOP
>X = 0
>LOOP
> X += 1
> ASTRING =
INLIST<X>
>UNTIL ASTRING = ''
> LOCATE ASTRING IN
ALIST SETTING POS THEN
>
DO
>
OTHER
>
STUFF
> END ELSE
>
DONT
> END
>REPEAT
>
>Of course of you really want
speed then sort the list and use
>a "BY clause
>in the locate
>
>-----Original Message-----
