Re: Large text file to a CSV file...

From: Louie Warren (lwarren_at_ticom.com)
Date: 05/21/04 

Date: Fri, 21 May 2004 09:50:16 -0700

I have a WebsitePro Access Log Combined (W3C/NCSA) Format
file; and yes, I know there is an ODBC routine out there
to do this, but my company doesn't want to spend the money
to get it because we are abandoning WebSite Pro in the
next few months. The data is on a classified system so I
will attempt to recreate the problem with generic data. I
already see problems with the blank delimiters...

An example from the book (string these together with a
space between fields.

172.18.96.157 (IP Address)

gryphonaire.com (Hostname of server
receiving request)

Admin (Authentication user name)

[02/Jan/2001:09:44:56 - 0800] (Date timestamp UTC offset)

"GET /members.html HTTP/1.1" (Complete HTTP request)
 
200 (HTTP Response Code)

178 (Number of bytes transfered)

"http://gryphonaire.com/index.html" (Complete referring
URL)

"Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)" (ID of
browser)

"Member=WebSiteRules" (Cookie)

The problem in the Access import is if the Authentication
username isn't available. WSP puts in a - This is
common for most of the requests. When an actual ID is
present, it doesn't fit the pattern with the others. The
data is consistantly like the above example (", [, and
all).

Hopefully that explains it.

L