Axel
New member
Hi,
I've a monitoring-table from some testclients and one row is filled with internetdomains. I need for a reporting only a part of the domain.
In the field domain you can find typical internet domains, I would like to evaluate them further according to the domains.
My problem is that there are several entries in the form "..... 0.a.0.2.0.8.3.2.0.1.0.a.2.ip6.arpa" or "..... 73a15bb4c8.fp.measure.office.com".
For me it would be relevant to have the last three domains separated by a period in an additional column. I.e. with the two "2.ip6.arpa" and "measure.office.com".
Additionally, some domain values contain only two dots, e.g. "0x0d.de".
For this I have too little experience with the PowerQueryEditor how to create a new one with the reduced domain info from the one column.
Currently there are about 140.000 entries in the table, new ones are added constantly.
In the attached file in Table1 is an example of my monitoring-table. In Table new the new form.
I'm using Excel 365.
View attachment Demo.xlsx
I've a monitoring-table from some testclients and one row is filled with internetdomains. I need for a reporting only a part of the domain.
In the field domain you can find typical internet domains, I would like to evaluate them further according to the domains.
My problem is that there are several entries in the form "..... 0.a.0.2.0.8.3.2.0.1.0.a.2.ip6.arpa" or "..... 73a15bb4c8.fp.measure.office.com".
For me it would be relevant to have the last three domains separated by a period in an additional column. I.e. with the two "2.ip6.arpa" and "measure.office.com".
Additionally, some domain values contain only two dots, e.g. "0x0d.de".
For this I have too little experience with the PowerQueryEditor how to create a new one with the reduced domain info from the one column.
Currently there are about 140.000 entries in the table, new ones are added constantly.
In the attached file in Table1 is an example of my monitoring-table. In Table new the new form.
I'm using Excel 365.
View attachment Demo.xlsx
