Convert %20 to a space

[szeiss]

I have several columns in my table where the data was imported in this fashion this%20is%20a%20test. I need to convert this to a space for reporting such as in a SELECT statement.

Thanks,
Sherry

 

[jimirvine]

Use the REPLACE function

 

[SantaMufasa]

Jim's suggestion about your using REPLACE is excellent. In case you have never used it before, here is an example, using your exact string:

SQL> select replace ('this%20is%20a%20test.','%20',' ') from dual;

REPLACE('THIS%2
---------------
this is a test.

Let us know how your use of REPLACE turns out for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[szeiss]

It didn't quite work for me because of some wild characters, so I started looking and ended up using

regexp_replace('this%20is%20a%20test.','%2.',' ')


Thanks,
Sherry