Data Extraction from TEXT file for Microsoft Excel

i am seeking assistance with microsoft excel probably visual basic or macros too possibly.

i would like the ability to EXTRACT specific information from large text files. these text files can have hundreds or sometimes even thousands or tens of thousands of lines.

the lines of data will be from systems and hardware equipment, and show like make, model, serial number, versions, dates, times, flags, ups, downs, and more. the output would vary regarding the data requested from the hardware...but the format is expected to be the same for each data output. i suspect there would be a START and END for each systems, to which i am trying to EXTRACT and COLLECT the data between - the info inside the START and END of each system.

an example, hardware data....the data will "appear/present" the same format, but the data would be slightly different on each, make, model, serial number, system, files, dates, times, etc.

the files will be first pulled from 50-100 systems with a few commands, then all those files would be combined into ONE SINGLE FILE (example; copy *.* [login to view URL]). in this ONE FILE file would be all the information from each of the 50-100 systems. that information should be in the same format throughout the file, per system.

i would like someone to help me be able to EXTRACT specific data from the SINGLE FILE and put it into a sortable, filterable and reportable spreadsheet rows and columns.

example, i copy and paste the info from the SINGLE TEXT FILE into the Microsoft Workbook. i paste it into Sheet1 of the Workbook. afterwards, in Sheet2 of the same workbook, would then show me all the ROWS and COLUMNS of data automatically for me to be able then to sort, filter and report on.

Skills: Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps

See more: copy data from text file to excel using vba, extract data from text file into excel vba, open text file in excel vba, excel vba read text file line by line, vba read csv file, excel vba read text file into worksheet, vba read text file into array, how to extract data from text file to excel using vba, data to text file, data extraction text file, export data macro text file, data extraction image file, data extraction csv file, vba excel data entry text file, javascript export html data entries text file, form data entry text file, data extraction pdf file, insert data mysql text file, form php data appends text file, php append data form text file

About the Employer:
( 42 reviews ) Mount Vernon, United States

Project ID: #16161061

47 freelancers are bidding on average $127 for this job


Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I have always created a long-term collaboration with my clients through hard work and quality More

$100 USD in 3 days
(296 Reviews)

Hi Sir/Mam, It is being my pleasure to introduce you to me. I am expert in data entry, conversion and advance excel. Please review my profile. My profile is suitable for this project. I will complete this project More

$100 USD in 0 days
(290 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 USD in 3 days
(283 Reviews)
$155 USD in 3 days
(172 Reviews)

Hello, I can provide you a smart .NET desktop application to implement your requirements. Here are my work samples: htt More

$166 USD in 3 days
(61 Reviews)

Hello. My name's Paris. I'm an experienced Excel developer and specialized in retrieving, manipulating and formatting data from other Excel files, text or csv files to other formats. I'm really interested in your proj More

$90 USD in 3 days
(209 Reviews)

Hi! May I suggest something? To use Microsoft Access instead of Excel. As it seems there are lots of lines in the text file I guess it is much easier and faster to process that in the database program. We can send f More

$200 USD in 3 days
(204 Reviews)

Hi, I'm ready to work on "text data extraction" project. Relevant Skills Excel macros Milestones 96 usd - code writing 24 usd - userfriendly interface I would love to work on your project.

$132 USD in 2 days
(122 Reviews)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quali More

$155 USD in 3 days
(193 Reviews)

I can create simple GUI app that will allow you to select source text file, click Start button and it will open Excel file with parsed information. All I need to start is sample input file and output example. Tha More

$100 USD in 1 day
(166 Reviews)

Yes I have good skills in So i can help you I will never disappoint you. I have good skills in Thansk.

$155 USD in 3 days
(67 Reviews)

Hello! I am proficient with Excel and VBA and would love to help you with this project. You don't have to do copy/paste your text to one sheet and then expect to have a report in second sheet. I can make a scrip More

$98 USD in 3 days
(137 Reviews)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$155 USD in 3 days
(65 Reviews)

A proposal has not yet been provided

$133 USD in 5 days
(76 Reviews)

I have excellent command on MS Excel. I have gone through the project description and can extract the required data from the combined text file and present it in the desired format Few of my past projects - Built a More

$120 USD in 3 days
(80 Reviews)
$100 USD in 3 days
(68 Reviews)

A proposal has not yet been provided

$150 USD in 3 days
(55 Reviews)

I am very able to create a macro to extract data ***I am ready to start E mail me for further discussion. Waiting to hear from you. with thanks and regards

$133 USD in 2 days
(55 Reviews)

Hi, I’m good with VBA development and have experience handling and processing data from reading text file. I reviewed your requirements and interested in the project. If the file has 1000s of lines, I advise you to i More

$177 USD in 4 days
(28 Reviews)

I am a technical business analyst with over 15 yrs experience building complex automation and reporting solutions using Excel and VBA. I have worked on quite a number of similar projects involving programmatically maki More

$111 USD in 3 days
(25 Reviews)