homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
Forum Library, Charter, Moderators: Receptional & mademetop

Website Analytics - Tracking and Logging Forum

pipe delimited file - ---
looking for a way to collate info

 5:00 pm on Oct 10, 2001 (gmt 0)

we have zip codes from our zip code search database written to a pipe delimited file - we need a way to coolate and view the lines of the database -

-- for instance we would like to see how many times zipcode 55412 was pulled up -

here is a few lines of the file...

¦South Hadley¦MA¦2-8-2001
¦portsmouth hamphire¦¦2-8-2001
¦santa cruz¦ca¦2-8-2001



 5:26 pm on Oct 10, 2001 (gmt 0)

If you want to do it offline just download the file , do a find and replace on "¦" replacing it with "," (comma), then you just import the cleaned file into access, filemaker pro or any standard database for viewing and tweaking.


 6:03 pm on Oct 10, 2001 (gmt 0)


i thought of that -

how can i easially collate the information into a report based on zipe code or date for instance...

we would like to see the most common occurences...

maybe a report something similar to the we a web logging app reports usage

many thanks


 7:03 pm on Oct 10, 2001 (gmt 0)

This stuff is cake in perl, if you wanted to go that route.


 7:21 pm on Oct 10, 2001 (gmt 0)

any pointers on where i can go to lealn "pearl" to do the job??

many thanks


 7:39 pm on Oct 10, 2001 (gmt 0)

[wdvl.com...] isn't a bad start.


 8:42 pm on Oct 10, 2001 (gmt 0)

Lots of companies have a copy of Access lying around. Import your database into that, then use the query wizard to generate various reports. Its easier than programming, harder than find/replace.


 9:07 pm on Oct 16, 2001 (gmt 0)

Use common *nix tools, e.g. awk, sort, uniq, sed

awk '{print $1} logfile ¦ sort ¦ uniq -c ¦ sort -nr

Or if you really want to import it into Access, you can convert the pipes to commas:

sed 's/¦/,/g' logfile > logfile.new

Global Options:
 top home search open messages active posts  

Home / Forums Index / WebmasterWorld / Website Analytics - Tracking and Logging
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved