xillao

Please help I need your help very badly. Thanks

I´ll try (sorry, my english is not the best). I have multiple txt files and each file in the middle of other text this kind information Input rate : 1402096 bps (873 pps) Output rate : 4659616 bps (1088 pps) And I only need the data which is preceeded by "Input rate:" and "output rate:". This information for example 1402096 3434344 343434 3434434 etc (estracted from the txt files) send it to a unique file (txt or excel). If it´s possible, one column with the numbers estracted from "Input rate :" field and another column for the numbers estracted from "Output rate :" field. Like this Example of origin data txt file for macro MSERVICE@ADFED> show interfaces fe7-8-8 Input rate : 1402096 bps (873 pps) Output rate : 4659616 bps (1088 pps) New file created after macro Input output 1402096 562634 4659616 742560 1467047 704692 7075471 465964 Thanks, your help is very appreciated

Sorry, How can i do that with a macro? Thanks, I will be grateful

Every week i need to get some information from mutiple text files which is always preceded by "Input rate :" and " Output rate : ". It will be like this Input rate : 1111111 bps Output rate : 2222222 bps And I only need 1111111 and 2222222 and send them to a excel file (or text file) in two columns. One for Input Rate and another for Output Rate. Thanks in advance