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