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

[vizbiz]

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

[danrh]

I'm not able to reproduce either error. Can you share your workflow or reproduce it with some dummy data and share?

When I put your two ranges in a Text Input and run them through the macro, I'm getting the right results:

And I've tried a few different things that could possibly break the macro, but it hasn't been throwing the error you described. Any additional info you can give will help.

[vizbiz]

Please see attached, I have input 3 rows of data to test the Macro, where it is failing.

10.250.129.4-10.250.129.9 

10.250.127.12-10.250.128.0 

10.250.129.250-10.250.130.0

[danrh · Accepted solution]

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.