Think about when you need to remove zeros, then write a regex that does that. Be warned, it's trickier than you think and needs somewhat beyond basic level regex knowledge.
The requirements come down to remove all leading 0 digits except where there is no following digit. Consider:
use strict; use warnings; while (<DATA>) { s/(?<!\d)0+(?=\d)//g; print; } __DATA__ 010.231.000.049,41145,010.231.000.049,1363,CDU01V43 010.231.000.050,20,010.116.223.024,2803,ZVC629
Prints:
10.231.0.49,41145,10.231.0.49,1363,CDU1V43 10.231.0.50,20,10.116.223.24,2803,ZVC629
The (? bits are look back and look ahead anchors. See the perlre documentation for more info on what they do (look for "Look-Around Assertions").
In reply to Re: Remove zero padding from excel mangled Ip addresses
by GrandFather
in thread Remove zero padding from excel mangled Ip addresses
by symgryph
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |