Re: How can I convert strings efficiently?

"SoulSurvivor" wrote ...
> You can write your own function to loop through the string and replace
> any junk if you wish if you dont want to use Replace.
>
> Here is one i just done.
>

(snipped a bit)
>
> IF (ASCII(v_chr) >= 65 AND ASCII(v_chr) <= 90) OR -- A to Z
> (ASCII(v_chr) >= 97 AND ASCII(v_chr) <= 122) OR -- a to z
> (ASCII(v_chr) >= 48 AND ASCII(v_chr) <= 57) THEN -- 0 to 9
>

(snipped even more)
>
> 1* select Format_String('ABC;[=/#DEF12+3') FROM DUAL
> SQL> /
>
> FORMAT_STRING('ABC;[=/#DEF12+3')
> ---------------------------------------------------------------
> ABCDEF123
Hi,

thanks very much for taking the time to response. I really appreciate it. I like the use of ASCII function, it didn't come to my mind. But I think I'll go with what Andrew provided in his post because I also have to convert capitals to lower letters. He put it in his example so lazy me has got to do even less work ;-))

Bye,
Guido Received on Wed Apr 02 2003 - 09:08:50 CST