asked on

separate output strings into a flexgrid in order

On the attached project, I have a BlockList form that shows all blocked websites in among several text files. These text files are located in the test folder. When clicking "Show Blocked Sites" they output in the Immediate Window, but I would instead like them to output to a Flexgrid for viewing purposes.

For example, execute the program under the BlockedList Form and choose the date range from 11/11/2014 to 11/24/2014 and you will find all the typical results below in the immediate window.

30 adnxs.com: ib.adnxs.com. 192.168.1.100
3 blogspot.com: adsense.blogspot.com. 192.168.1.100

However I would like to separate these strings as indicated above into 3 columns in a flexgrid. Then also list them from greatest to smallest number of blocked sites

Any help is always appreciated.
CB.zip

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

al4629740

ASKER

Looking great. It is exactly in the order it should be.

The only thing I'm pondering is what to do when certain sites that come up as

^.*s(3|e)x: expertsexchange.112.2o7.net.

I have to figure out what those sites are

Martin Liss

Are you implying that you don't want any summarization?

al4629740

ASKER

Sounds good : ) What do you mean by summarization?

Martin Liss

Well I thought there might be duplicates that you'd want added up and shown as one total, but I see now that there aren't any complete duplicates. There are for example a lot that contain "tumblr.com" but none where the second column is exactly the same.

al4629740

ASKER

Is it possible to put the following headers in?

#Blocked Site IP Address

Martin Liss

Sure.
Q-28575780-1.zip

al4629740

ASKER

Thank you