Tuesday, August 5, 2014

substring

Hi everyone,


I have a data like below


number


057740500


0410104


087219602


0020190


0077853


I need to take out last 2 digits of right side if the 2 digits are 00,01,02,03,04,05,06,07,08,09 only and take out all the zeros


in the front (left hand side) of the number


Can any one help.


No comments:

Post a Comment