Code:
let
TFR = Table.FromRecords({[IP = "192.168"]}),
num1 = Table.AddColumn(TFR, "num1", each {0..255}),
num2 = Table.AddColumn(num1, "num2", each {0..255}),
Expand1 = Table.ExpandListColumn(num2, "num1"),
Expand2 = Table.ExpandListColumn(Expand1, "num2"),
TCC = Table.CombineColumns(Table.TransformColumnTypes(Expand2, {{"num1", type text}, {"num2", type text}}, "en-GB"),{"IP", "num1", "num2"},Combiner.CombineTextByDelimiter(".", QuoteStyle.None),"Result")
in
TCC
Result |
192.168.0.0 |
192.168.0.1 |
192.168.0.2 |
192.168.0.3 |
192.168.0.4 |
192.168.0.5 |
192.168.0.6 |
192.168.0.7 |
192.168.0.8 |
192.168.0.9 |
192.168.0.10 |
192.168.0.11 |
192.168.0.12 |
192.168.0.13 |
192.168.0.14 |
192.168.0.15 |
and so on |
192.168.255.246 |
192.168.255.247 |
192.168.255.248 |
192.168.255.249 |
192.168.255.250 |
192.168.255.251 |
192.168.255.252 |
192.168.255.253 |
192.168.255.254 |
192.168.255.255 |
Bookmarks