[sqr-users] RE: sqr-users Digest, Vol 32, Issue 17

["Leanne Harrisburg" <lharrisb@nu.edu>]

I had a similar request from a user.  I ended up encoding the apostrophe like 
this:

   ! Encode an apostrophe 
   Encode '<039>' Into $Apost

Then I searched for the apostrophe in the name field and proceeded from there.

Find $Apost in $Name 0 #Apost_Pos

Leanne Harrisburg
National University
Senior Programmer/Analyst
Voice: (619) 563-2635
 
 

-----Original Message-----
From: sqr-users-bounces+lharrisb=nu.edu@sqrug.org 
[mailto:sqr-users-bounces+lharrisb=nu.edu@sqrug.org] On Behalf Of 
sqr-users-request@sqrug.org
Sent: Tuesday, October 24, 2006 3:05 AM
To: sqr-users@sqrug.org
Subject: sqr-users Digest, Vol 32, Issue 17

Send sqr-users mailing list submissions to
        sqr-users@sqrug.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://www.sqrug.org/mailman/listinfo/sqr-users
or, via email, send a message with subject or body 'help' to
        sqr-users-request@sqrug.org

You can reach the person managing the list at
        sqr-users-owner@sqrug.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sqr-users digest..."


Today's Topics:

   1. how to remove a single quote from a name (Overcashier, Patricia)


----------------------------------------------------------------------

Message: 1
Date: Tue, 17 Oct 2006 12:30:28 -0400
From: "Overcashier, Patricia" <Patricia.Overcashier@aam.com>
Subject: [sqr-users] how to remove a single quote from a name
To: "This list is for discussion about the SQR database
        reportinglanguage from  Hyperion Solutions." <sqr-users@sqrug.org>
Message-ID: <F0652A9934B81649B13293685D1945E904BD6B62@WHQNT60.AAM.NET>
Content-Type: text/plain;       charset="iso-8859-1"

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


End of sqr-users Digest, Vol 32, Issue 17
*****************************************

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