Scan through the text files and retrieve the words next to "FROM" and "JOIN" words and put into Excel
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
I strongly recommend Ivan. After all, He is very responsible until meeting a client requirement even thought the project was exceeding my expectation. [18 March, 2016] Designer should be not only drawing good but also so smart that he could understand what the client require.. I worked with two other freelancers before meeting Ivan. Both have 200+ reviews, but they are not such excellent guys as I had thought. This project was small amount cost, but he didn't complain even spending unexpected extra working time unlike most freelancers here and try to accomplish and meet my requirement . I am 200% satisfied with his dedicated work and my selection on him. Tghank you Ivan
Hi I'm mathematician and software developer with many years of experience.
I am civil engineer have 2 years experience in design and drawing skeletal structures of concrete and steel, and also have very good experience in design and drawing of RC pools and tanks, have a very good experience with Analysis programs (STAAD, ETABS, SAP, RAM & SPcol), and AUTOCAD.
Eager to work & learn. Good communication skills. Proficient at automating Excel using VBA programming. Web scraping any information you need. Converting PDF to any text format. Experienced in testing websites and mobile applications (iOS/Android). I offer efficiency and high quality work.
5+ years experience with MS Office, VBA, Auto CAD, Autodesk Inventor, Solid Work. Revit, Google Sketchup, 3D Max...I have creative skills focuses on best quality works. I supply for: - Visual Basic code, VBA for Microsoft Office, Autocad, Inventor... - Mechanical system and product design, CAD/CAM Designer - Structural, Architectural, 3D rendering, 3D Animation. - Industrial Machinery Design, 3D Modelling, 3D Printing , Assembly, 2D and 3D drawing, Sheet Metal, Customer product design... - We always assure our clients with: * Quality and timely service * Good work with commitment and professionalism. *Continued support after the delivery of final product *Clear communication throughout the project *100 % satisfaction guaranteed * The best price :) YOUR CHOICE IS OUR HONOR
The Hague, Romania
I am a talented and experienced C# Developer. I have good experience with C# and I have been working as a C# Developer for many years. I am a hard worker and enjoy working at all critical conditions. If hired by you I will be responsible to complete the task within the stipulated time frame and with utmost confidence. Outsource me for your project and I promise to bring in the best output.
Dedicated and hard worker
Our team consists of 24 developers. We have specialized programmers for various php frame works. So we are comfortably accommodating wide range of programming systems. With our 9 year experience, we understand clients and their Business needs better by all means and adding values to their ideas. We keep client regularly updated about the project progress & accept addition, alteration comments for betterment of the final product. We provide service guarantee, post-implementation application support & maintenance ::: We don't work for Adult , unauthorized clone , Dating, & Gambling kind of websites at any circumstance :::
Expertise in IT services I have more than 7 years of IT experience with sound knowledge of software's. I provide the following service 1) Web Scraping/Web research 2) Programming/Scripting 3) Lead generation & 4) Data entry. Key features of my work are as follows: 1) Always within schedule 2) Always within scope 3) High quality 4) Best tools and techniques used for the completion of tasks
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 a hard worker and enjoy working at all critical conditions. If hired by you I will be responsible to complete the task within the stipulated time frame and with utmost confidence. Outsource me for your project and I promise to bring in the best output. I Specialize in *DATA ENTRY *SPREAD SHEET CALCULATIONS *DATA TABULATION *PDF TO EXCEL CONVERSION *WORD TO EXCEL CONVERSION.
Hi If you want 100% accuracy with on time work, then you are on the right place. i have more than years of experience. now i joined freelancer because i need more money urgently. Please allow me a chance.