Hi, I’ve some problems while I’m trying to copy-paste a list of IPs into the cells,
basically even if the preview seems to be correct, when I hit OK, some of those IPs in the B column are missing/loosing their dots.
My purpose is to have a text file like this:
IP1 - IP2
IP3 - IP4
...
As I’m quite noob with NP++ regex editor, I though I could use CALC in the middle.
can I please have some help?
1.0.1.0 1.0.3.255 768
1.0.32.0 1.0.63.255 8,192
1.0.8.0 1.0.15.255 2,048
1.1.0.0 1.1.0.255 256
1.1.2.0 1.1.63.255 15,872
1.10.0.0 1.10.9.255 2,560
1.10.11.0 1.10.127.255 29,952
1.116.0.0 1.117.255.255 131,072
1.119.0.0 1.119.255.255 65,536
1.12.0.0 1.15.255.255 262,144
1.180.0.0 1.185.255.255 393,216
1.188.0.0 1.199.255.255 786,432
1.2.0.0 1.2.2.255 768
1.2.4.0 1.2.127.255 31,744
1.202.0.0 1.207.255.255 393,216
1.24.0.0 1.31.255.255 524,288
1.3.0.0 1.3.255.255 65,536
1.4.1.0 1.4.127.255 32,512
1.45.0.0 1.45.255.255 65,536
1.48.0.0 1.51.255.255 262,144
1.56.0.0 1.63.255.255 524,288
1.68.0.0 1.71.255.255 262,144
1.8.0.0 1.8.255.255 65,536
1.80.0.0 1.95.255.255 1,048,576
101.0.0.0 101.0.3.255 1,024
101.1.0.0 101.1.3.255 1,024
101.101.100.0 101.101.100.255 256
101.101.102.0 101.101.127.255 6,656
101.101.64.0 101.101.95.255 8,192
101.102.100.0 101.102.102.255 768
101.102.104.0 101.102.127.255 6,144
101.102.64.0 101.102.95.255 8,192
101.104.0.0 101.107.255.255 262,144
101.110.116.0 101.110.127.255 3,072
101.110.64.0 101.110.111.255 12,288
101.120.0.0 101.124.22.255 268,032
101.124.24.0 101.126.255.255 190,464
101.128.0.0 101.128.3.255 1,024
101.128.8.0 101.128.63.255 14,336
