Title: RE: looking for faster Ideas...
I like this idea.
 
Thanks
George
-----Original Message-----
From: Anthony Youngman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 3:09 AM
To: U2 Users Discussion List
Subject: RE: looking for faster Ideas...

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

Reply via email to