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
