in reply to Re^2: Remove zero padding from excel mangled Ip addresses
in thread Remove zero padding from excel mangled Ip addresses

or just change the \d to a \w: s/(?<!\w)0+(?=\d)//g;.

True laziness is hard work

Replies are listed 'Best First'.
Re^4: Remove zero padding from excel mangled Ip addresses
by raybies (Chaplain) on Mar 22, 2012 at 14:44 UTC

    Beautiful!

    Testing this one, the only possible unexpected output I had was when I had a bareword (not a dotted quartet) that was all numbers with leading 0's.

    input:>

    040.300.000.048,00145,010.030.000.049,CDU00U04V43

    Output:>

    40.300.0.48,145,10.30.0.49,CD00U04V43

    Which I think most of us would agree is acceptable, assuming the second field is a raw integer value, and not intended to be a code that requires leading zeroes preserved. The nice thing is the word (last field) is preserved.

    Nice, anyhow, thanks for sharing your expertise.