Copy specific rows from a notepad to excel.

Post by **Anuj Dhawan** » Fri Dec 27, 2013 3:43 pm

Hi,

I've been trying to write a vb-script to work for me as a tool - copy some "specific lines" from notepad to excel and put them in specific columns. With initial hiccups I believe that - there seem to be some products available in market for this very purpose and it feels like I'm trying to reinvent the wheel - said that, have someone of you has used something of this sort and have some pointers. If you do - please suggest - it''ll be a great help.

Regards,

Post by **zprogrammer** » Mon Dec 30, 2013 12:08 pm

Just trying to understand ..

How many lines you have in notepad?

Post by **Anuj Dhawan** » Mon Dec 30, 2013 1:04 pm

Thanks for the interest Pk.

Notpads are unload of STROBE report - so they vary in "number of lines" they have. It can start from 100 lines to 1 million.

I'm trying to pick up "CPU" time related information from the notepad.

Mainframe, MVS and zOS Discussion

Copy specific rows from a notepad to excel.

Copy specific rows from a notepad to excel.

Re: Copy specific rows from a notepad to excel.

Re: Copy specific rows from a notepad to excel.

Create an account or sign in to join the discussion

Create an account

Sign in