Re^4: Remove zero padding from excel mangled Ip addresses

[raybies]

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

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.