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

["Kaithi, Murali" <Murali.Kaithi@spencergifts.com>]

Four consecutive single quotes becomes one single quote
Eg: ''''

Murali 

-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org 
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On Behalf 
Of Overcashier, Patricia
Sent: Tuesday, October 17, 2006 12:30 PM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: [sqr-users] how to remove a single quote from a name

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

________________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning Services, 
utilizing MessageLabs proprietary SkyScan infrastructure. For more information 
on a proactive anti-virus service working around the clock, around the globe, 
visit http://www.paetec.com.
________________________________________________________________________

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