Copying certain lines from a text file
We would try
Add help column;
Go down whole list row by row;
If Like "SC*" then dirty 3 rows in help column accordingly
Go up help column;
Delete rows with no entry;
Delete help column
--
Regards
"Michael A" wrote in message
...
Hi, I have a text file with 30,000 lines. I need to figure out a way to
copy
only the lines that start with [SC] and the surrounding lines (1 above, 1
below) to my excel sheet. I can import the whole sheet into excel, but I
cant
figure out how to sort it and still keep the 3 lines I need together.. Any
help pls? Thank you!
|