Require a desktop script to convert a text file of keywords into formatted URLS.
Currently using Excel and pasting the text file into column A and using the following formula in column B:
=(PROPER(A1))&"|"&$C$1&(SUBSTITUTE(A1," ","-"))&".php"
In cell C1 the name of the url with folder is pasted manually. I would like to automate the entire process without having to copy and paste the text file in and out of Excel.
All the files are organized the same way:
Main folder is the main category where the script would be run from. Inside are several folders named as the root URL with 3 characters of text to be stripped from the end:
Widget Category has 3 folders called [login to view URL]; [login to view URL]; and [login to view URL]
Inside each of these folders are text files of keywords that need to be changed to urls. The name of the folders correspond with the folder name online:
In the subdirectory [login to view URL] has text files called [login to view URL] and [login to view URL]
The script would use the directory name for the url less the last 3 characters and the name of the text file as the subfolder:
[login to view URL]
[login to view URL]
The new file needs the text line properly formatted as follows:
The keyword lists have spaces between the words but in the urls they must be replaced with "-".
The keyword tag at the begining most be converted to proper case:
Keyword|[login to view URL]
Other Keyword|[login to view URL]
The new text file will be placed in the same directory as the text files and be named the same as the the text file except it will have "links-" as a prefix:
[login to view URL]
[login to view URL]
The script is to ignore files in the the folders that do not end in .txt
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Must be able to run on Windows XP.
Can be coded in PERL, VB, Python, C, a compiled application, anything you want as long as it does not time out or create memory crashes on large runs.
PLEASE SEE THE ATTACHED SAMPLE FILES AND DEMO OUTPUT TO CLARIFY THE DESCRIPTION.