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

[ponraj]

are these  IPv4 addresses ?

[vizbiz]

YES dummy

[ponraj]

decimal number should be below 255 in that case.  Correct  me if I am wrong 

[vizbiz]

Yes correct, basically logic should be 255.255.255.255 so the formula should be written in such a way that the I.P range with . deliminator look of last and then when it becomes = then no need to add new row if not keep adding a new row until 255 once reached 255 it should increment the next decimal to 255 or equal and keep generating new rows of full I.P's

[JohnJPS]

Just FYI you have bad data in your sample: 455, 345, 937... .shouldn't be allowed.

[JohnJPS]

Seems like an R thing and because I'm lazy, I asked StackOverflow to help: https://stackoverflow.com/questions/51992620/r-generate-sequence-of-ip-numbers/

Based on that, I was able to generate the attached workflow, which should do the trick.  You will need to install the iptools R package.

[vizbiz]

Thank you John for the solution, unfortunately I don't have IP tools R package. Is there any other solution way without using R and stilla cheive the same result.

Appreciate your help.

[danrh]

Check out the solution provided here. This was the same question and I built an IP address generator macro. There are two versions of the macro, so scroll to the bottom to get the correct one.

[vizbiz]

Hi Pulsar,

Thank you for the updated Macro, it is working but with below 2 errors, I don't know where I am doing wrong. Please help me.

10.250.129.4-10.250.129.9    ----- this example range is working as expected

10.250.127.12-10.250.128.0  ----- this range is also working but 10.250.128.0  is not getting created as a separate row in IP1 output

And when I incorporate the macro in my workflow, it is running with results but with warning /error message saying (Iteration #1: Tool #11: The value did not change after the loop Expression) I am using the default Macro Configuration form the original sample Macro.

Thanks in advance.