You may find contacting them again isn't the annoyance
you expect. People tend to get annoyed if they think they're dealing with a computer. Get a genuine person get back to them and say "yes, we're trying to
fix this for you", and you've just turned someone from being anti into being a
prospective customer.
Anyways, my take (to save on all this CASEing ...) -
I'd use MATREAD rather than Matt's choice of READ, and ... can you preprocess on
the basis of, say, zip code? Have an MV file containing all the records you want
excluded or matchcodes thereof.
Let's say, John Smith of AB12345 contacts you and
says "take me off your list". You check, and his record has the correct zip code
in the CSV. So you edit your MV file, and discover that Will Carling also told
you to take him off some while back.
ED EXCLUDEFILE AB12345
-----: P
00001: *WILL*CARLING*
-----: I *JOHN*SMITH*
00002: *JOHN*SMITH*
-----: FI
So now, when you're processing your CSV, from each
record you can do
extract zip code
read zip-code-record from EXCLUDEFILE else record is
okay
if record matches LOWER(zip-code-record) else record is
okay
get next record
Gets rid of reams of case statements, saves you having
to rewrite the program every time, and is fast because most records will be validated on a single (failed) MV read.
Cheers,
Wol
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen
Sent: 27 January 2004 20:04
To: 'U2 Users Discussion List'
Subject: RE: looking for faster Ideas...
But
when the info is mailed in or emailed in or left on
a
voice mail, that's when we run into not having the
best
data to go with. Calling/emailing/mailing them
back
usually just increases the annoyance level on
their
end, since we are contacting them Again..
George
***********************************************************************************
This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system.
Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.
***********************************************************************************
_______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users