Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : UNQUOTE

UNQUOTE
Returns a string with the single quotation marks removed. (F)
Invocation
unquoted = UNQUOTE(string)
 
string without single quotation marks at the beginning and end. Pairs of single quotation marks within string are changed to single quotation marks.
Usage Notes
Only the first and last single quotation mark are removed. If you have a pair of single quotation marks at the beginning and a pair at the end, the returned string has one quotation at the beginning and one at the end.
Example
The following rule removes quotation marks from an entry that a user made on a screen and passes the unquoted string to be processed. The screen is called EMPINFO_SCR and the screen table into which the information is entered is called EMPINFO_SCRTAB.

 
CLEAN_INPUT;
_
_ ---------------------------------------------------------------------
_ ------------------------------------------------------------+--------
_ GET EMPINFO_SCRTAB(EMPINFO_SCR); | 1
_ CALL INPUT_EMPINFO(UNQUOTE(EMPINFO_SCRTAB.EMPNAME)); | 2
_ ---------------------------------------------------------------------

 
If you enter:
'AB''CD EF'
the string that is passed to the INPUT_EMPINFO rule is:
AB'CD EF

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved