Also consider using SET VAR LastName=(SSTRIPI(LastName,(CHAR(32)+CHAR(39)))
char(32) is space char(39) is quote this will remove spaces and quotes Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 > >From: Jason Kramer <[email protected]> >To: RBASE-L Mailing List <[email protected]> >Sent: Fri, March 4, 2011 11:42:21 AM >Subject: [RBASE-L] - Re: EMAIL PDF > > Bill, > User SRPL to clean the intended file name: >R>SET VAR vmytest TEXT = 'James O''Connor' >R>SHOW VAR vmytest >James O'Connor >R>SET VAR vmytest = (SRPL(.vmytest,'''',NULL,0)) <-- Note this is four >single quotes, not two double quotes. >R>SHOW VAR vmytest >James OConnor >R>CLEAR VAR vmytest > >Jason > > > >Jason Kramer >University Archives and Records Management >002 Pearson Hall >(302) 831 - 3127 (voice) >(302) 831 - 6903 (fax) >On 3/4/2011 12:32 PM, Bill Owens wrote: > >>We have an application where we create a PDF file and email >>The file contains first name lastname.pdf >>If there is an apostrophe in the name ex: James O’Connor >> >>cannot create PDF >>If name = James Oconnor then PDF is created >> >>Any suggestions will be appreciated. >> >>Bill >>
