06-09-2023, 03:43 AM
Hi, I was trying to make a macro that copies a certain string from a bunch of text file(logA.txt,logB.txt) and summarize it into a single text file(Summary.txt).
the LogA.txt contains texts like below:
-------- Item Count ---------
Name Count
ItemA 22
ItemB 11
ItemC 2
------------------------------------
the LogB.txt contains texts like below:
-------- Item Count ---------
Name Count
ItemA 23
ItemB 15
ItemC 12
------------------------------------
Lets say I wanted to extract the whole rows of ItemA ( Example: "ItemA 22") from a bunch of text file and paste in into Summary.txt like this:
LogA. ItemA 22
LogB. ItemA 23
Is it possible to do this?
the LogA.txt contains texts like below:
-------- Item Count ---------
Name Count
ItemA 22
ItemB 11
ItemC 2
------------------------------------
the LogB.txt contains texts like below:
-------- Item Count ---------
Name Count
ItemA 23
ItemB 15
ItemC 12
------------------------------------
Lets say I wanted to extract the whole rows of ItemA ( Example: "ItemA 22") from a bunch of text file and paste in into Summary.txt like this:
LogA. ItemA 22
LogB. ItemA 23
Is it possible to do this?