Welcome to WebmasterWorld Guest from 54.145.53.251

Forum Moderators: DixonJones & mademetop

Message Too Old, No Replies

pipe delimited file - ---

looking for a way to collate info

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

Junior Member

10+ Year Member

joined:Aug 1, 2000
posts:165
votes: 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

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Apr 3, 2001
posts:1609
votes: 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)

Junior Member

10+ Year Member

joined:Aug 1, 2000
posts:165
votes: 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

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

Senior Member

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

joined:June 17, 2000
posts:2924
votes: 0


This stuff is cake in perl, if you wanted to go that route.
7:21 pm on Oct 10, 2001 (gmt 0)

Junior Member

10+ Year Member

joined:Aug 1, 2000
posts:165
votes: 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)

Senior Member

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

joined:June 17, 2000
posts:2924
votes: 0


[wdvl.com...] isn't a bad start.
8:42 pm on Oct 10, 2001 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:July 4, 2001
posts:997
votes: 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)

New User

10+ Year Member

joined:Oct 16, 2001
posts:24
votes: 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