Equivalent function for Server Oconv in Parallel job

Billyqing · Post by **Billyqing** » Tue Sep 28, 2010 12:51 pm

Hi
I have used Server function Oconv to retrieve numeric values from the string input.

Oconv("John Smith 1-234", "MCN")

How can I do the same thing in Parallel job?
Anyone knows how to do so?
Thanks in advance.

DS version: DS 7.5.2 E.E

Billy

vinothkumar · Post by **vinothkumar** » Tue Sep 28, 2010 12:55 pm

Check convert function

Billyqing · Post by **Billyqing** » Tue Sep 28, 2010 1:12 pm

Convert Function would not do work.

Input Output
-----------------------
"1234567" 1234567

vinothkumar · Post by **vinothkumar** » Tue Sep 28, 2010 1:15 pm

How did you try ? Can you please paste your exact statement

Billyqing · Post by **Billyqing** » Tue Sep 28, 2010 1:18 pm

The input string could contain any characters. The return should only contian intergers.

Samples are following:

1234.56--------------------------> 123456
123-456-789---------------------->123456789
ABCD(12-34+ "345")----------------------->1234345

Thanks,

vinothkumar · Post by **vinothkumar** » Tue Sep 28, 2010 1:27 pm

Can you try this
Convert(Convert('0123456789','','XYZ123.45ABC'),'','XYZ123.45ABC')

kandyshandy · Post by **kandyshandy** » Tue Sep 28, 2010 3:32 pm

Vinoth, that was a good one.

Billy, if you are not sure about what special characters can come in the string, you can go for a BASIC transformer in a PX job.

Billyqing · Post by **Billyqing** » Tue Sep 28, 2010 3:39 pm

Thank you all.

I was thinking to use Basic Transformer but it doesn't appear in the Palett.
I am not sure that it does not work or anything else wrong.

The convert function, Vinoth moentioned below, works now at least.

Thanks again.

Post by **daignault** » Tue Sep 28, 2010 6:30 pm

You have to go into the repository to access it, not the pallet. Go to stage types, parallel, and you will see the BASIC Transformer

Regards,

Ray D

Billyqing · Post by **Billyqing** » Wed Sep 29, 2010 1:21 pm

Thank you, Ray.