Page 1 of 1

How to Replace one or more instances of a substring

Posted: Fri Aug 29, 2008 10:25 am
by Apotluri
Hi all, I have a CHAR(10) field with a value of 123-456789 and I have to map this to an output field of CHAR(9) without the '-', meaning populate the outpur field with 123456789. In server, we can do it using Change or Ereplace, but how to get this done in Parallel.

Help is appreciated.
Now, am I going to get few replies as "did u search", I truly did , but did not find the answer, I found a few discussions though.

Thanks, as always.

Posted: Fri Aug 29, 2008 10:48 am
by mikegohl
The convert functions should work for that.

Posted: Fri Aug 29, 2008 11:18 am
by Apotluri
Isn't Convert, a server function?

Can you give me the usage please, if it is parallel.

Posted: Fri Aug 29, 2008 11:29 am
by Apotluri
sorry, I got it.!