pulling specific text from a notepad document

The simplest method would be (shown in air code, you'll have to work out the steps):

1) Import the text file into a new sheet
2) Find SPECIFIC text that marks the beginning of the needed text
3) Find SPECIFIC text that marks the end of the needed text
4) Copy the found range of text to a permanent sheet
5) Close the temporary sheet
6) Repeat with all files in a folder.

Don't ask "how do I do this?" without providing complete details. Upload your desired "results" workbook and several sample text files. make sure you give enough info someone can actually offer more help.

Here is a rough version of the code I'm working with. I've included the specific tags that surround the data I'm after (the <table> and <td> tags are not part of the specific tags, i just used them in the example code). These tags hold true throughout all of my data. There are multiple products in each text file.

The result sheet I'm after is just an excel spreadsheet with 4 columns, one including the product name, the price, the time sold, and the date sold. Also I need this to run on all the text documents in the folder. The text documents are named 1.txt,2.txt,3.txt, etc. For this lets say they are all saved in a folder C:\webpages

Please Login or Register  to view this content.

Make sure there are no other text files in that folder, give this a try with two or three files in there. It worked for me for finding the two items in 3 copies of the file, so it should work for any number of items if the layout stays consistent.

Please Login or Register  to view this content.