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