Re: E-mail generator

[Art DiRamio <ADiRamio@OPENSOLUTIONS.COM>]

We use the translate command to rip out characters we don't want.  It works
like this:

Let $T_col7_15 = edit(SUBSTR(translate($IRS_MAIN-ServiceBureauTIN,'
-_,.\/()',''),1,9),'099999999')
        Let $T_col344_358 = translate($IRS_MAIN-bankphoneandext,'
-_,.\/()extnEXTN','')

The basic translate is Translate(Field,'stuff to change','what to change
stuff to')

As you can see from the examples, the command is pretty flexible, and allows
us to keep up with "creative customer input" ! ! !

More details in the SQR Language Reference ver 4, pg 177.

Hope this helps!

  - - Art


                -----Original Message-----
                From:   Sam Spritzer [mailto:SSpritzer@GW.CTG.COM]
                Sent:   Thursday, April 22, 1999 4:55 PM
                To:     Multiple recipients of list SQR-USERS
                Subject:        E-mail generator

                I m in the process of creating an e-mail generator which
will take an employee's name and create the user part of an e-mail address.
The requirement is to take the first letter of the first name and marry it
to the last name.  For example, Bill Clinton would be bclinton.
                Straight names are easy...its the non-letter characters I am
having trouble with such as O'Gore,Al / de Agnew, Spiro /
Rodham-Clinton,Hillary.
                Does anyone have a "stripper/scrubber" code that they would
be willing to share?
                Thanks in advance,
                Sam