homepage Welcome to WebmasterWorld Guest from 50.19.172.0
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
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
iggy99

10+ Year Member



 
Msg#: 214 posted 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
35016¦¦¦2-8-2001
35016¦¦¦2-8-2001
¦portsmouth hamphire¦¦2-8-2001
¦portsmouth¦hampshire¦2-8-2001
¦santa cruz¦ca¦2-8-2001
¦Mississauga¦ON¦2-8-2001
93546¦¦¦2-8-2001
¦louisville¦ky¦2-8-2001
¦oxnard¦ca¦2-8-2001
62644¦havana¦IL¦2-8-2001

 

john316

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 214 posted 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.

iggy99

10+ Year Member



 
Msg#: 214 posted 6:03 pm on Oct 10, 2001 (gmt 0)

thanks--

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

littleman

WebmasterWorld Senior Member littleman us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 214 posted 7:03 pm on Oct 10, 2001 (gmt 0)

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

iggy99

10+ Year Member



 
Msg#: 214 posted 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

littleman

WebmasterWorld Senior Member littleman us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 214 posted 7:39 pm on Oct 10, 2001 (gmt 0)

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

ggrot

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 214 posted 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.

richcasto

10+ Year Member



 
Msg#: 214 posted 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