Find Jobs
Hire Freelancers

An automated search and replace application with the ability to create and save files based on a template

£20-250 GBP

Completed
Posted over 10 years ago

£20-250 GBP

Paid on delivery
Overview: This project requires an application / program that will use a WILDCARD words from a list of words to create multiple html pages on an automated basis (ie: an automated search and replace application with the ability to create and save files based on a template) . The Project: I have a list of nearly 7,800 river names from around the world. I am needing to auto create a separate html web page for each of these rivers. The basic template for each of the web pages will be identical. In each instance a river name from the list must replace the word WILDCARD wherever it appears in the template. After all instances of the word WILDCARD in the template have been replaced by one of the river names from the list the modified template file must be auto saved at [login to view URL] This process must be auto repeated for each of the river names in the list. For example using the following paragraph as the template text:- The WILDCARD river flows through sunny hillsides. Many villages depend on the WILDCARD river for drinking water. The WILDCARD river is vital to irrigation of subsistence agriculture. and when the list of words to replace WILDCARD are Red, Blue, Green, etc. the application will replace the word WILDCARD in the template with each one of the listed words as follows: The Red river flows through sunny hillsides. Many villages depend on the Red river for drinking water. The Red river is vital to irrigation of small scale agriculture. and then save the modified file as [login to view URL] The Blue river flows through sunny hillsides. Many villages depend on the Blue river for drinking water. The Blue river is vital to irrigation of small scale agriculture. and then save the modified file as [login to view URL] The Green river flows through sunny hillsides. Many villages depend on the Green river for drinking water. The Green river is vital to irrigation of small scale agriculture. and then save the modified file as [login to view URL] , etc.. Hence, if the attached [login to view URL] page was the template after it had been auto modified I would have three new files named [login to view URL] , [login to view URL] and [login to view URL] where each instance of the word WILDCARD in the template had been replaced with red, blue or green respectively. It is important that when saving the modified template file that the format of the template is not altered. I have the full MS Office suite and would prefer to use something that can work in that if you are not able to provide a stand-alone application / program. The list of river names is presently saved in one column of an Excel spread sheet but can be easily saved in alternative format as needed. If this type of application needs to be server based I will be able to get a cheap VPS / shared server from the likes of GoDaddy but am not certain if they would grant the root access you will likely need for this type of account. I would prefer a desktop application but if it does need to be a server side application then I must be able to download the created html files and save them to my computer as static html. I am not very technical and know very little about programming so will need a 'plug-and-play' solution for this project. I will be most pleased if someone is able to assist with an easy to use application that will do the above for me. Thank you and Happy New Year! Paul
Project ID: 5272795

About the project

7 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello Paul I am an Excel VBA developer with many projects completed here on Freelancer. I can quickly (and cheaply) build you a macro-based solution using Excel that will run in Excel and generate the HTML files with the appropriate wildcard replacements. This is actually a simple task and can be done within an hour or two. I am available right now to work on this for you. Best regards, Brent
£25 GBP in 1 day
5.0 (38 reviews)
4.2
4.2
7 freelancers are bidding on average £128 GBP for this job
User Avatar
Hi Paul, The best solution in your case is to convert the excel sheet you have into a MySQL database and generate the pages on the fly. This way, you'll be able to modify the template easily for all the pages anytime you like by just editing one file, and you'll be able to change data within the database dynamically and they'll get reflected on the pages. Pages can have keywords in the url and they can end with .html. Let me know if this works for you for further discussion.
£309 GBP in 3 days
5.0 (248 reviews)
7.9
7.9
User Avatar
I can deliver a Windows PC standalone program, no setup, no other files required. Easy to use, select input file (template), select list of rivers, select output folder, process files. Can you send me the template file and the list, your exact files, format doesn't really matter. Delivery time is 3 days because of New Years.
£44 GBP in 3 days
5.0 (455 reviews)
6.3
6.3
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
£133 GBP in 5 days
4.9 (80 reviews)
5.7
5.7
User Avatar
Hi, Sounds I can do it quite easily. I'm professional PHP programmer. Just send me more details how do you see it and maybe one example . Regards Jakub
£111 GBP in 5 days
5.0 (3 reviews)
2.9
2.9

About the client

Flag of UNITED KINGDOM
Ipswich, United Kingdom
5.0
12
Payment method verified
Member since Sep 14, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.