Parsing file using unknown number of lines for each record

[Saraabdi955]

Hi everyone,

I have some files attached.

And I don't know how many IP does each domain have.

Could you help me, please?

[DenisZ · Accepted solution]

Please see attached workflow

[Saraabdi955]

Thanks @DenisZ 

It's exactly what I wanted to do!
Could you explain a bit about the process?

[DenisZ]

Sure, 

1: Text to Columns (rows): This is used to get all the lines on a separate row which would be easier for data processing 

2: Filter: we are not interested in empty rows

3: Searching for all lines that end with ".com". If you look through the data you are able to see that each website has its own line with IP adressess folloing after. So if the row is a website, I just put it out on a separate column 

4: Multi Row Formula Tool: Since I see that the IP adresses follow right after the website and then a new website comes, then I know that I can just fill in the empty rows with the website that belongs to the IP. This is because I already know that I want to use the summarize tool afterwards. 

5: Filter: Do not want any empty rows

6: Summarize to count number of occurrences.

Hope it helps!