Oninit cdi / Archive
Talk to an expert →

URL decode an attribute

Posted in 2008

Topics: Data Types & Schema Design

belingueres@gmail.com — — source: Usenet: comp.databases.informix

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

↪ replying to belingueres@gmail.com
Fernando Nunes — — source: Usenet: comp.databases.informix

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,

↪ replying to belingueres@gmail.com
Claus Samuelsen — — source: Usenet: comp.databases.informix

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

↪ replying to belingueres@gmail.com
Paul Watson (Oninit) — — source: Usenet: comp.databases.informix

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