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.
47 freelancers are bidding on average $127 for this job
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 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