Đã Đóng

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 *.* [url removed, login to view]). 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.

Kĩ năng: Xử lí dữ liệu, Excel, Microsoft Access, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: 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

Về Bên Thuê:
( 42 nhận xét ) Mount Vernon, United States

ID dự án: #16161061

48 freelancer đang chào giá trung bình $128 cho công việc này

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 Thêm

$100 USD trong 3 ngày
(237 Nhận xét)
7.5
guoxinliu917

Hello, I can provide you a smart .NET desktop application to implement your requirements. Here are my work samples: https://www.freelancer.com/jobs/project-548149/ https://www.freelancer.com/jobs/project-881339/ htt Thêm

$166 USD trong 3 ngày
(55 Nhận xét)
6.9
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 Thêm

$200 USD trong 3 ngày
(201 Nhận xét)
6.9
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 trong 3 ngày
(228 Nhận xét)
6.9
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 Thêm

$155 USD trong 3 ngày
(173 Nhận xét)
6.6
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 Thêm

$90 USD trong 3 ngày
(158 Nhận xét)
6.8
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 Thêm

$100 USD trong 0 ngày
(120 Nhận xét)
6.6
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 trong 2 ngày
(102 Nhận xét)
6.2
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 Thêm

$100 USD trong 1 ngày
(150 Nhận xét)
6.2
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 Thêm

$98 USD trong 3 ngày
(120 Nhận xét)
5.7
$100 USD trong 3 ngày
(58 Nhận xét)
5.5
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 trong 2 ngày
(53 Nhận xét)
5.8
sknadeem123

A proposal has not yet been provided

$150 USD trong 3 ngày
(47 Nhận xét)
5.6
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 Thêm

$155 USD trong 3 ngày
(55 Nhận xét)
5.6
$155 USD trong 3 ngày
(45 Nhận xét)
4.9
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 Thêm

$120 USD trong 3 ngày
(25 Nhận xét)
4.7
Imranatmoon

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

$50 USD trong 3 ngày
(35 Nhận xét)
4.6
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 trong 1 ngày
(22 Nhận xét)
4.9
orugantn

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 Thêm

$177 USD trong 4 ngày
(22 Nhận xét)
4.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 trong 3 ngày
(20 Nhận xét)
5.0