Hi guys,
I have this question if it is possible to trim a string on a specific character and replace it with blank value?
example: I have 3 set of strings '0000001230023', '00045698000988', '002134'
what I want is to scan on these strings and replace the zeros with '' until it reaches the nonzero value. The first string containing 6 zeros from left until it reaches the no 1 should be replace with '' the rest will remain in the string.
is this possible?
thanks in advance
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.