DSXchange

I have one requirment.

My input is

telephoneno
09700020075
919889110102
918571233668

i want ouput is

telephoneno
09700020075
09889110102
08571233668 and length should be 11.If first two characters is "91" i need to replace as "0" in parallal jobs.

Assuming that the data type of Phone is string (of some kind):

Hi Ray,

Thank you for your reply.

In some times my telephone length is morethan 11 degitis
like 9198765432110254

In this example i want output 09876543211 and just ignore after 11 digits
As per your reply i am getting output is 06543211025.

1)Extract first two characters and check whether it is 91. If it is 91 extract n-2 right most characters and append with 0

Use string functions,if clausesub string operator