parsing log files

[David Greene]

Hi, I would like to be able to parse a memo field and pull out IP addresses
from a memo field and put them in new text fileds. I would like some ideas on
the best way to design a query to do this.

The reason I am trying to do this is because I have a bunch of email alerts
from a sonicwall firewall that look like this:
Possible port scan dropped - 65.32.1.65, 53, WAN - 71.41.111.112, 33657,
WAN - UDP scanned port list, 33660, 33661, 33658, 33659, 33659

I have exported them into a csv and imported them into an access database. I
would like to be able to pull out the addresses into one or more fields so
that I can analyze addresses that might be a problem. Can anyone give me some
ideas?

Thanks!!
David

 

[Tom Wickerath]

Hi David,

You might try exporting this data to Excel. Then use Excel's Data | Text to
Columns feature (I don't know what the equivalent is in Excel 2007, sorry).
You can put a check to use the comma and space characters as the delimiters,
and another check in the option to treat consecutive delimiters as one. Or
perhaps use the fixed width option. Then reimport the data if you want it
back in Access.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________