Đã Đó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 *.* [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.

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, 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

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

ID dự án: #16161061

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


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
(296 Nhận xét)

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
(290 Nhận xét)

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
(283 Nhận xét)
$155 USD trong 3 ngày
(172 Nhận xét)

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
(61 Nhận xét)

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
(209 Nhận xét)

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
(204 Nhận xét)

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
(122 Nhận xét)

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
(193 Nhận xét)

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
(166 Nhận xét)

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
(67 Nhận xét)

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
(137 Nhận xét)

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
(65 Nhận xét)

A proposal has not yet been provided

$133 USD trong 5 ngày
(76 Nhận xét)

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
(80 Nhận xét)
$100 USD trong 3 ngày
(68 Nhận xét)

A proposal has not yet been provided

$150 USD trong 3 ngày
(55 Nhận xét)

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
(55 Nhận xét)

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
(28 Nhận xét)

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

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