RE: [sqr-users] removing all special characters from a string

["saritha ventrapragada" <sperumudi@hotmail.com>]

I think translate is one option.

But with translate function, one should check for all the special characters 
except the one which are valid in email address.

Does SQR doesnot provide any built-in function to check this validation?

>From: "Bartlett, Dwain" <dbartlett@state.mt.us>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "'This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions.'" <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] removing all special characters from a string
>Date: Mon, 14 Jun 2004 10:32:56 -0600
>
>Use the translate sqr command.
>
>Dwain Bartlett
>SABHRS Services Bureau, ITSD
>HR Systems Analyst
>(406) 444-0418
>dbartlett@state.mt.us
>
>
>-----Original Message-----
>From: Overcashier, Patricia [mailto:Patricia.Overcashier@aam.com]
>Sent: Monday, June 14, 2004 10:25 AM
>To: Sqr-Users@Sqrug. Org (E-mail)
>Subject: [sqr-users] removing all special characters from a string
>
>
>In my sqr, I have a string  $inp-email-addr
>Before processing this string I want to make sure that it only contains
>alpha (no numerics), an @ sign and periods, and nothing else. ex:
>john.doe@abcd.com
>I want to make sure that there are no commas, hyphens, apostrophes, etc.
>(basically no special characters)
>What is the easiest way to verify my string before processing it?
>
>If there are any of these things, I don't want to replace them with
>anything, just remove them.
>
>Thanks.
>
>Patti Overcashier
>
>
>
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper for the presence of computer viruses.
>
>www.mimesweeper.com
>**********************************************************************
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Getting married? Find great tips, tools and the latest trends at MSN Life 
Events. http://lifeevents.msn.com/category.aspx?cid=married


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users