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

["the dragon" <ceprn@hotmail.com>]

If you're using a somewhat current version of PS, isn't there an sqc that 
inclused that code?  Like in the rotname.sqc series?

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

It is impossible to defeat an ignorant man in argument.

William G. McAdoo

----Original Message Follows----

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

_________________________________________________________________
Stay in touch with old friends and meet new ones with Windows Live Spaces 
http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us


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