Generate multiple rows by ascending order of in between missing data for I.P Range

Hi,

I need help with a formula or the best approach to generate the ascending order of I.P address in between a range separated by "-" symbol.

Note, some data may need up to 2 decimal point ascending order range.

Attached is the sample data.

Column
12.234.455.234
89.345.235.2
98.937.234.4 - 98.937.235.8
10.234.235.6 - 10.234.235.9
10.235.657.7

Thanks

Help

Accepted answers

danrh

Hmm ... I still am getting the expected results. Because the last IP address happens during a second iteration of the macro, it isn't grouped with the rest of IP addresses that are created from this record, instead ending up at the end. In the attached, I've added a RecordID tool to better see which IP addresses go with which original record, and a Filter to show generated IPs that are equal to the second IP address called out in the original field:

Could you run the attached to confirm you're seeing the same results? If not, I'm not sure what the issue could be. Some sort of difference between our two environments.

Error_Macro_Sequence.yxmd

All comments

ponraj

are these IPv4 addresses ?

vizbiz

YES dummy

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703