VBScript Excel string manipulation. Adding to existing working Macro.
$30-250 AUD
Slutfört
Publicerad över tre år sedan
$30-250 AUD
Betalning vid leverans
Hello,
I worked for many years in I.T, and as part of my role I learned VBScript. I left I.T around 6 years ago, and over time I have continued to write scripts to help in my business. Now I am lacking time to write the VBScript, so I am looking for an experienced VBS programmer to help with some changes to an existing VBScript. I am rusty with not using my VBS skills, and I am finding that it is too slow going!
I have an existing VBScript for Excel that takes data from an Excel worksheet, and then manipulates the data by removing and sorting columns, and also modifying data in the spreadsheet.
The columns are formatted perfectly, and now there is some additional string manipulation needed.
Example of string manipulation within For loop
- Check each cell in a column, and modify then extract data from address string
e.g
"123 Example Street,
San Roque,
1801,
NCR,
Philippines, The"
Tasks:
- Change 'Philippines, The' to 'The Philippines'.
i.e If there is ", The" in the string remove ", The" and add "The " in front of country
- Extract location with state.
e.g in the example above extract location as "San Roque, NCR"
- Extract country name and write to a cell
Full instructions will be provided once the candidate has been accepted.
Some of the VBS functions that you should be familiar with:
Left, Right, Replace, InStr, InStrRev
I am looking for someone with good experience with writing VBScript macros in Excel, who works quickly and know what they are doing.
On selection of the right candidate I will provide the existing XLSM file along with example data to work with.
I'm an Excel/Excel VBA expert with rich experience in Excel/VBA application. I read the job details extremely carefully. I am absolutely sure that I can do this project very well. I'm ready to do it now. I will wait for your positive response.
Thank you.
Hello I have just saw your project and it's very cool to work over there we have 500+ trusted clients
please give a chance to work on your project
inbox me for further details
I'm developer since long and solving such problem almost on regular basis,, on few prestigious site ,, and I'm confident enough that I can handle & fix it,,, but on other side I also need complete information,,, what exactly are your need along with the expected output, to avoid any successive issue.
Please check my profile & portfolio, will help you to make decision.
Rajesh S.
I am a professional with all the experience and skills for project. Data Entry is one of the skills we have and can help you with the project as per your project.
MOSTLY I DONE EXCEL SHEET PROCESSING AND AUTOMATION USING MACRO. If you give chance I assure, i will do my best to finish your job as per your requirement. Thank you
Relevant Skills and Experience
I done excel sheet processing for college like NBA, publishing details and so on