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

["Barry E. Cohen" <barryecohen@pobox.com>]

Hello,

I just code it like this >

let $lname = translate($lname, '''', '')

Best, Barry

> -----Original Message-----
> From: sqr-users-bounces+barryecohen=pobox.com@sqrug.org
> [mailto:sqr-users-bounces+barryecohen=pobox.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
> from Hyperion 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
>




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