Welcome to WebmasterWorld Guest from 54.145.144.101

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)

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



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)

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



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

10+ Year Member



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)

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



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

WebmasterWorld Senior Member 10+ Year Member



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)

10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month