Extracting Specific Correlating Lines of Code.

Hi all. I am brand new to this forum, and Excel programming in general, so please excuse any repeat questions!

I am trying to pull cycle time information out of a .txt file (sample attached)

How can I write a code to pull the information from lines with the text 'PARTNAME' and 'TOTALTIMEAVERAGE'

This information needs to stay related to each other. For Example, PARTNAME=AFM3690 has a TOTALTIMEAVERAGE=9027

Ideally I would like to put this info into 2 columns like this..

Part Name	Cycle Time (ms)
AFM3690	9027

Thank you for any help you can offer, I am drowning in code jargon!


61-815-8.5 BARS.txt

Please Login or Register  to view this content.

That is amazing thank you!

You are welcome.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED

If I wanted to do this to multiple files, is it just a matter of changing the the fn. application String to pull multiple files? Also I am trying to convert these times from milliseconds to seconds, and it will not let me do that with a formula. How could I code that to convert the information before it hits the spreadsheet?

Do you mean

Please Login or Register  to view this content.