Focal Point
[SOLVED] How to strip single quotes in multi-select prompt values

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2247076526

October 31, 2012, 12:44 PM
JC Zhu
[SOLVED] How to strip single quotes in multi-select prompt values
I have an amper variable that can have multiple values selected in the prompt. I see that the value passed from the prompt is like: 'England' OR 'France' OR 'Italy'

My goal is to translate that value into an string I can use as part of the report title, something like: England, France, and Italy.

I tried using CTRAN and STRREP to remove the single quotes and the "OR", but they don't work properly because they appear to assume there is a single pair of single quotes in the input string. So they return only the first value.

Does anyone know how this can be achieved?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.7.3
Windows, All Outputs
October 31, 2012, 12:54 PM
JC Zhu
Never mind, I later found the following technique. I was not using the CTRAN function correctly.

https://techsupport.informatio...om/sps/40712538.html


WebFOCUS 7.7.3
Windows, All Outputs