300112 txt file sorter
N/A
착불
I have a .txt file that containes all the searches on my search engine for a given month, it is arranged as follows.
Sat Sep 20 15:13:18 2003|[url removed, login to view]|web|unethical advertising on the internet
Sat Sep 20 15:13:20 2003|[url removed, login to view]|news|[url removed, login to view]
Sat Sep 20 15:13:20 2003|[url removed, login to view]|web|[url removed, login to view]
Sat Sep 20 15:13:20 2003|[url removed, login to view]|web|Hosting
Sat Sep 20 15:13:20 2003|[url removed, login to view]|web|tag syntax parser java
Sat Sep 20 15:13:24 2003|[url removed, login to view]|web|free advertising
Sat Sep 20 15:13:24 2003|[url removed, login to view]|web|free advertising
Sat Sep 20 15:13:25 2003|[url removed, login to view]|web|Ringtones
Sat Sep 20 15:13:26 2003|[url removed, login to view]|web|text parsing url java
Sat Sep 20 15:13:26 2003|[url removed, login to view]|web|S Corporation
Sat Sep 20 15:13:26 2003|[url removed, login to view]|web|S Corporation
Sat Sep 20 15:13:29 2003|[url removed, login to view]|web|Genealogy
Sat Sep 20 15:13:30 2003|[url removed, login to view]|web|phpshellphp webpage
Sat Sep 20 15:13:30 2003|[url removed, login to view]|web|free internet advertising
Sat Sep 20 15:13:30 2003|[url removed, login to view]|web|free internet advertising
Sat Sep 20 15:13:31 2003|[url removed, login to view]|web|driving directions
Sat Sep 20 15:13:31 2003|[url removed, login to view]|web|driving directions
Sat Sep 20 15:13:34 2003|[url removed, login to view]|web|allinurl php filephp
Sat Sep 20 15:13:36 2003|[url removed, login to view]|web|free classified advertising
Sat Sep 20 15:13:36 2003|[url removed, login to view]|web|free classified advertising
Sat Sep 20 15:13:36 2003|[url removed, login to view]|web|recipes
Sat Sep 20 15:13:37 2003|[url removed, login to view]|web|recipes
Sat Sep 20 15:13:37 2003|[url removed, login to view]|web|[url removed, login to view]
Sat Sep 20 15:13:37 2003|[url removed, login to view]|web|execute c from php tutorial
Sat Sep 20 15:13:40 2003|[url removed, login to view]|web|in -s target linkname
Sat Sep 20 15:13:41 2003|[url removed, login to view]|web|Msn
Sat Sep 20 15:13:42 2003|[url removed, login to view]|web|free web advertising
Sat Sep 20 15:13:43 2003|[url removed, login to view]|web|zip codes
Sat Sep 20 15:13:43 2003|[url removed, login to view]|web|free web advertising
Sat Sep 20 15:13:45 2003|[url removed, login to view]|web|php display current temperature
Sat Sep 20 15:13:45 2003|[url removed, login to view]|images|Pamela Anderson
Sat Sep 20 15:13:46 2003|[url removed, login to view]|videos|literotica
Sat Sep 20 15:13:46 2003|[url removed, login to view]|web|literotica
Sat Sep 20 15:13:48 2003|[url removed, login to view]|web|stofanet modem mib
I need a program/script of some type that counts the number of duplicates and saves that 'keyword' in another txt file with the number of times it's been searched next to it, i.e. number of duplicates in file.
so the final file for the short list above would be:
unethical advertising on the internet|1
[url removed, login to view]|2
Hosting|1
tag syntax parser java|1
free advertising|2
Ringtones|1
text parsing url java|1
S Corporation|2.........
Then i need the script to arrange the list in order of the highest number of searches, i.e.
[url removed, login to view]|2
free advertising|2
S Corporation|2
unethical advertising on the internet|1
Hosting|1
tag syntax parser java|1
Ringtones|1
text parsing url java|1.........
This would not take very long (only a couple of minutes of a fast programmer). If someone would be willing to do it for a good review that would be great!
프로젝트 ID: #2046186