W Toku

Excel Vbscript ASAP

Scan through the text files and retrieve the words next to "FROM" and "JOIN" words and put into Excel

Pre-condition:

1)Use Excel Vbscript

2)In scripting refer to excel cell using Cells method NOT Range method

Example: Use this way "Worksheets("Sheet1").Cells(1,1)"

Steps to do:

1)Scan through the text files [url removed, login to view] and [url removed, login to view]

2)Get first word after "FROM" and "JOIN"

3)Remove duplicate values

4)In file [url removed, login to view], don't select words "[" and "(SELECT" after the JOIN

5)Step2, Step3 and Step4 should be in seperate methods

Fore more clarity, refer to attached word docs, where color blue should be in excel cell and color red should be avoided

Also provided sample excel file which I'm expecting after the scripting

Umiejętności: Excel

Zobacz więcej: vbscript remove duplicate values text file, vbscript excel find, datasource vbscript excel, vbscript excel text sheet, user vbscript excel, odbc vbscript excel, vbscript excel search string file, vbscript excel read file update save file database, open internet explorer vbscript excel, odbc connection vbscript excel, vbscript excel connect sql server, vbscript excel pivot, vbscript excel addition, vbscript excel merge, open xml vbscript excel, search vbscript excel

O pracodawcy:
( 5 ocen ) Sydney, Australia

Numer ID Projektu: #11787625

Przyznane użytkownikowi:

vlayausa

Hello, I am proficient with Excel and VBA and I would love to help you with this project. I fully understand your requirements. It sounds quite simple for me. Please contact me for more information.

$40 AUD w 1 dzień
(66 Ocen)
5.0

9 freelancerów złożyło ofertę na średnią kwotę w wysokości $126 do tego projektu.

MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel macros and i've never had a single problem. If you are interested message me and i will be more than happy Więcej

$50 AUD w ciągu 1 dnia
(164 Ocen)
5.7
zebracaro

i can do it for you quickly and exactly

$150 AUD w ciągu 2 dni
(67 Ocen)
5.5
customizedata

I have gone through the attached stuff. File1.txt and File2.txt looks like a data from sql joins query.I can do all 5 points using Excel VBA. 1- Which produce the output as specified in "Sample Output file". 2- Wi Więcej

$160 AUD w ciągu 3 dni
(12 Ocen)
4.0
narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 6 years of experience. I have successfully completed few projects for US clients which involved web sc Więcej

$83 AUD w ciągu 2 dni
(14 Ocen)
3.3
graphicaa

Greetings, This is GOPAL for STALLIONi, Let me assist in this. Best results & optimum cost guaranteed here. Now, I am available for live chat. If you are convenient - now we can discuss more about this project. O Więcej

$263 AUD w ciągu 10 dni
(3 Ocen)
2.6
MinaBoushra2014

Hello I am engineer with more than 5 years experience in excel and word and I can help you to do your job accurately, quickly and with high quality, available 24/7 to support you and promise I will meet your expecta Więcej

$30 AUD w ciągu 0 dni
(1 Ocena)
0.7
denopaul98

I am a talented and experienced Data Entry Operator. I have good experience with Data Entry and I have been working as a Data Entry Operator for the Aga Khan University Hospital and as a freelancer for many years. I am Więcej

$155 AUD w ciągu 3 dni
(0 Ocen)
0.0
carmenne

I have experience in Excel (including VBA) and also coding skills (C#). I am looking forward to this task.

$45 AUD w ciągu 1 dnia
(0 Ocen)
0.0
Nbabita

Hello Sir/madam, I have been working with excel and data entry from last 6 years. if you give me the chance for completing the project. you will definitaly fine the 100% accuracy and the best timing. sir, if you wa Więcej

$200 AUD w ciągu 3 dni
(0 Ocen)
0.0