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.
Replace value in parallal jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Assuming that the data type of Phone is string (of some kind):
Code: Select all
If (Len(InLink.Phone) = 11) Then InLink.Phone Else "0" : Right(InLink.Phone,10)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.