Data Extraction from TEXT file for Microsoft Excel

Imefungwa Ilichapishwa Miaka 6 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

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.

Kutengeneza Data Excel Microsoft Access Visual Basic Visual Basic kwa Vitufe

Kitambulisho cha Mradi: #16161061

Kuhusu mradi

43 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

43 wafanyakazi huru wanazabuni wastani wa $122 kwa kazi hii

semi786

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 Zaidi

$100 USD kwa siku 0
(Maoni 458)
8.2
P0L

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 kwa siku 3
(Maoni 455)
7.8
branislavm

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 Zaidi

$200 USD kwa siku 3
(Maoni 286)
7.8
mirniyazuddin92

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 Zaidi

$100 USD kwa siku 3
(Maoni 351)
8.0
paris2785

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 Zaidi

$90 USD kwa siku 3
(Maoni 349)
7.9
polarjin2017

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

$155 USD kwa siku 3
(Maoni 103)
6.8
avinav606lx

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 Zaidi

$155 USD kwa siku 3
(Maoni 199)
6.7
gangabass

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 Zaidi

$100 USD kwa siku 1
(Maoni 198)
6.7
katilinas

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 kwa siku 2
(Maoni 123)
6.6
sknadeem123

A proposal has not yet been provided

$150 USD kwa siku 3
(Maoni 78)
6.3
aubrey03

I can create a macro that can read directly from the text file, process the data and put it on an Excel worksheet.

$35 USD kwa siku 1
(Maoni 181)
6.6
vlayausa

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 Zaidi

$98 USD kwa siku 3
(Maoni 147)
5.9
supper5guy

A proposal has not yet been provided

$133 USD kwa siku 5
(Maoni 83)
5.8
archanaoswal

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 Zaidi

$120 USD kwa siku 3
(Maoni 95)
6.0
sonarkaushik

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 kwa siku 2
(Maoni 55)
5.8
katiewells3

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 Zaidi

$111 USD kwa siku 3
(Maoni 32)
5.3
abhinovpankaj

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 Zaidi

$155 USD kwa siku 3
(Maoni 66)
5.6
Imranatmoon

Hi There, This can be done using regular expression. Could you please share the text file for testing. Best regards Imran

$50 USD kwa siku 3
(Maoni 60)
5.1
insidenetsoft

Hello, I see that you would need an Excel VBA macro tool that will use an input sheet in order to process it and bring it to a manageable report format. We could do a short Skype call to discuss your project deta Zaidi

$90 USD kwa siku 3
(Maoni 28)
4.4
ongskjason

A proposal has not yet been provided

$100 USD kwa siku 2
(Maoni 7)
3.8