URL decode an attribute
Gabriel asked whether Informix has a function to URL-decode a varchar column holding values like %20. Fernando Nunes said no, but with 9.40 or later one could write a UDR in Java or C. Claus Samuelsen suggested the regexp bladelet. Paul Watson (Oninit) added that it is built into the WebBlade, otherwise download the regexp datablade. No single confirmed solution.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I have a table where a varchar attribute is written as an URL encoded string, i.e. for example, space character is written as '%20' and so on. Is there any function in informix that allows me to url decode this attribute? TIA, Gabriel
belingueres@gmail.com wrote: > Hi, > > I have a table where a varchar attribute is written as an URL encoded > string, i.e. for example, space character is written as '%20' and so > on. > > Is there any function in informix that allows me to url decode this > attribute? > > TIA, > Gabriel No, but if you're using 9.40+ you could write one in Java or C: http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.udr.doc/udr66.htm (for v10) Regards,
belingueres@gmail.com wrote: > Hi, > > I have a table where a varchar attribute is written as an URL encoded > string, i.e. for example, space character is written as '%20' and so > on. > > Is there any function in informix that allows me to url decode this > attribute? > > TIA, > Gabriel You can do it with a regular expression, but to do this you have to install the regexp bladelet, see http://www.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_regexp.html
belingueres@gmail.com wrote: > Hi, > > I have a table where a varchar attribute is written as an URL encoded > string, i.e. for example, space character is written as '%20' and so > on. > > Is there any function in informix that allows me to url decode this > attribute? > > TIA, > Gabriel It is built into the WebBlade, otherwise download the regexp datablade Cheers Paul