RE: [sqr-users] how to remove a single quote from a name

["Dwight Schrute" <schrute.dwight@hotmail.com>]

You must use four quotes ('''') instead of three.


>From: "Overcashier, Patricia" <Patricia.Overcashier@aam.com>
>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 reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: [sqr-users] how to remove a single quote from a name
>Date: Tue, 17 Oct 2006 12:30:28 -0400
>
>Hi everyone,
>I select a last name and before comparing it I remove all special 
>characters.
>Thanks to all of your help, I can do that successfully.
>The only character that I seem to struggle with removing is the single 
>quote
>
>I have the  name O'Hara
>I want it to be OHara
>I am using translate to remove all of the other oddities.
>let $lname = translate(lower($lname),'абвзийксуцн','aaaceeenooi')
>
>I have tried this:
>         find ''' in $lname 0 #pos   My errors happen here.  I can't find 
>the single quote to get rid of it.
>         if #pos > 0
>          let #pso2 = #pos + 1
>           let $newlname = substr(lname,0,#pos)||substr($lname,#pos2)
>         end-if
>
>Thanks again,
>
>Patti Overcashier
>Information Technology - PeopleSoft
>American Axle & Manufacturing, Inc.
>Detroit Gear Plant 3
>1840 Holbrook
>Detroit, MI  48212
>
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users

_________________________________________________________________
Add a Yahoo! contact to Windows Live Messenger for a chance to win a free 
trip! 
http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmtagline


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