callmeczarr
New Member
- Joined
- Jun 7, 2021
- Messages
- 1
Have a .txt file that contains specific data that needs to be extracted and placed into corresponding columns in Excel.
My log file has the following structure:
. . .
=== NAME: xyz123 ===
d1: ABCD, d2: EFGH e1: TRUE (12345)
. . . .
== Specific text ==
Not every log part ends with the == Specific text == line.
I need the following:
If the search finds the == Specific text == line, then list all the following text to an excel:
=== NAME: xyz123 ===, ABCD, EFGH, 12345
All required data to be extracted come before the == Specific text == line, there is also loads of data that comes before and after these blocks that does not need extracting. Usually there are more then 1 lines with == Specific text == in the log file, and I need to list all of them into one spreadsheet.
Many thanks for your help in advance.
My log file has the following structure:
. . .
=== NAME: xyz123 ===
d1: ABCD, d2: EFGH e1: TRUE (12345)
. . . .
== Specific text ==
Not every log part ends with the == Specific text == line.
I need the following:
If the search finds the == Specific text == line, then list all the following text to an excel:
=== NAME: xyz123 ===, ABCD, EFGH, 12345
All required data to be extracted come before the == Specific text == line, there is also loads of data that comes before and after these blocks that does not need extracting. Usually there are more then 1 lines with == Specific text == in the log file, and I need to list all of them into one spreadsheet.
Many thanks for your help in advance.