Data Extraction from TEXT file for Microsoft Excel
$30-250 USD
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.
Kitambulisho cha Mradi: #16161061
Kuhusu mradi
43 wafanyakazi huru wanazabuni wastani wa $122 kwa kazi hii
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.
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
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
Yes I have good skills in So i can help you I will never disappoint you. I have good skills in Thansk.
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
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.
I can create a macro that can read directly from the text file, process the data and put it on an Excel worksheet.
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
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
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
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
Hi There, This can be done using regular expression. Could you please share the text file for testing. Best regards Imran
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