Focal Point
"unescape" in WebFOCUS

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

November 02, 2005, 06:35 PM
Francis Mariani
"unescape" in WebFOCUS
I have a report that reads a log file that contains URLs. The URLs are "escaped" - blanks and other values are encoded using %20, etc.

I don't imagine there's a WebFOCUS function that "unescapes" these escaped values. Does anyone have any ideas on how to unescape a URL inside WebFOCUS?
November 03, 2005, 02:28 AM
j.gross
Been there, done that. Use MAINTAIN to transform the records. Its string manipulation functions outclass the traditional 'FUSELIB' ones.
November 03, 2005, 10:55 AM
Tony A
Another 'messy' alternative is to use the OVRLAY function (e.g. OVRLAY(URL_Field,length,'% ',3,pos of percentage sign,'Ann'). Trouble is that you will end up with a string that contains the correct character plus two blanks so you might need to then remove excessive blanks?

As I said - messy Frowner