Reading a text file and extracting information

[LearningProgrammer]

**I apologize for the bad thread title. I accidentally submitted while writing it. Thread should read Reading a text file and extracting information

So I have a small project that I've concluded that the simplest way would be to use an Excel VBA macro but my knowledge on this is limited and I would appreciate some help on this. I have a text file that contains a lot of information but I specifically need only small portions of it, which must be placed in an Excel spreadsheet. To paint a better picture, think of multiple paragraphs containing information but the information I need is only contained in paragraphs that start with the letter "B" and followed by a number. So if the paragraph starts with "B39", this is a paragraph I need to pull information from. Thank fully, a portion of the information is properly labeled. So for example, if I need the "Manuf", that appears as "Manuf: XXX" within the text file.

So here's my idea for this. To create a macro that names each cell column appropriately, such as a cell column named "Manuf", then the macro opens the text file by reading the file path, then begins to crawl it until it hits a B+integer, there it begins looking for other data need data such as "weight", "color", etc. Once it hits the last needed data for that paragraph, it looks for B+integer again until it goes through the whole text file.

Is this possible and does anyone have any advice on the steps I can take?
Thanks

[jindon]

If you upload a small sample source Text file and the workbook with your desired result from the source text file, it would help us to understand what you are trying to do.

[FDibbins]

Hi, welcome to the forum

I changed your title for you (thanks for including what you meant it to be)...for future reference, to change a Title on your post, click EDIT POST then Go Advanced and change your title.

I think this would be easier to work on if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[LearningProgrammer]

Thanks FDibbins for fixing the thread title for me. I've uploaded a sample text and a sample book like you and jindon have asked. I've been doing some research on this but outside of getting the top cells renamed, I keep hitting a wall. Especially on the portion on telling the macro to keep executing until it reaches the end of the file to search for other products that start with B+8 digits. Any advice pointing me in the right direction would be greatly appreciated.