OK, I suggested WILDCARD from home without the usual "lookup" first. :-)
Following the KISS philosophy, that about the something like the
following?
Granted, there's a minute possibility that the change may change something
before the intended '@-sign', but it qualifies as Quick and Dirty - and
fairly understandable - a key value for any code. And... it work with
ancient plumbing.
---<snip>---
/* EMAILFMT EXEC */
address COMMAND
malformed='bcgeodis.de mfclenovo.com rrcatt.com xxxnotfound.com'
domnames ='geodis.de lenovo.com att.com unused.com'
resultfile='EMAILFMT RESULTS A'
resultfail='EMAILFMT FAILED A'
'ERASE' resultfile
'PIPE (END ? NAME BuildMalformedStem)' ,
'| VAR malformed' ,
'| SPLIT' , /* One malformed per rec */
'| STEM malformed.'
'PIPE (END ? NAME BuildDomains)' ,
'| VAR domnames' ,
'| SPLIT' , /* One domain per rec */
'| STEM domains.'
changes=''
Do i = 1 to domains.0
changes=changes ,
'| CHANGE ANYCASE /'domains.i'/@'domains.i'/' /* Insert @ */
End
'PIPE (END ?)' ,
'| STEM malformed.' ,
changes ,
'| stillbad: LOCATE /@/' ,
'| >>' resultfile ,
'? stillbad:' ,
'| >>' resultfail
Exit rc
---<snip>---
Mike Walter
Hewitt Associates
Any opinions expressed herein are mine alone and do not necessarily
represent the opinions or policies of Hewitt Associates.
"Bob Cronin" <[EMAIL PROTECTED]>
Sent by: "CMSTSO Pipelines Discussion List" <[email protected]>
12/02/2008 08:55 PM
Please respond to
"CMSTSO Pipelines Discussion List" <[email protected]>
To
[email protected]
cc
Subject
Re: Need ideas for a lookup-like capability with a twist
I hadn't but I am now! :-) Thanks for the idea.
Cheers,
bc
On Tue, Dec 2, 2008 at 7:16 PM, Mike Walter <[EMAIL PROTECTED]>
wrote:
> Have you considered the WILDCARD stage?
>
> Mike Walter
> Hewitt Associates
>
>
> ----- Original Message -----
> From: "Bob Cronin" [EMAIL PROTECTED]
> Sent: 12/02/2008 04:11 PM EST
> To: [email protected]
> Subject: Need ideas for a lookup-like capability with a twist
>
>
>
> I have a list of domain names, e.g. "geodis.de lenovo.com att.com", etc.
>
> I have another list of (malformed) email addresses, e.g. "bcgeodis.de
> mfclenovo.com rrcatt.com", etc.
>
> I want to (somehow) use the list of domains and find those email
> addresses that END in any of the domain names (and then, of course,
> fix them up to insert the assumed-missing at-sign).
>
> It strikes me this this is a bit like lookup, but with modified
> matching criteria. It'd be infinitely cool if you could have lookup
> isolate the two fields being compared and pass them to an external
> function that could implement any sort of test it wanted (returning 1
> if it worked, or 0 if it did not).
>
> Failing that (if you'll excuse the expression) pipedream being
> realized, does anyone have any other ideas how I might tackle this?
>
> Cheers,
> bc
>
>
>
>
> The information contained in this e-mail and any accompanying documents
may contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if
this message has been addressed to you in error, please immediately alert
the sender by reply e-mail and then delete this message, including any
attachments. Any dissemination, distribution or other use of the contents
of this message by anyone other than the intended recipient is strictly
prohibited. All messages sent to and from this e-mail address may be
monitored as permitted by applicable law and regulations to ensure
compliance with our internal policies and to protect our business. E-mails
are not secure and cannot be guaranteed to be error free as they can be
intercepted, amended, lost or destroyed, or contain viruses. You are
deemed to have accepted these risks if you communicate with us by e-mail.
>
The information contained in this e-mail and any accompanying documents may
contain information that is confidential or otherwise protected from
disclosure. If you are not the intended recipient of this message, or if this
message has been addressed to you in error, please immediately alert the sender
by reply e-mail and then delete this message, including any attachments. Any
dissemination, distribution or other use of the contents of this message by
anyone other than the intended recipient is strictly prohibited. All messages
sent to and from this e-mail address may be monitored as permitted by
applicable law and regulations to ensure compliance with our internal policies
and to protect our business. E-mails are not secure and cannot be guaranteed to
be error free as they can be intercepted, amended, lost or destroyed, or
contain viruses. You are deemed to have accepted these risks if you communicate
with us by e-mail.
