Best Way to Do This

the_Grinch

Ok, I have a text file that isn't formatted in a particular way and I want to get it into an Excel spreadsheet to verify that things are the same. Basically, the file has the name of the program, the path of the file, and the hash for said file. Due to load balancing the information is duplicated and thus I have double the number of paths and hashes. For example:

"application name"
"path": <path>
"hash": <hash>

What I would like to do is write a script (thinking Powershell or Python would do) to run through the file line by line looking for anything that is "<program name>", "path", and "hash" then place it into a csv file. If possible I'd like to have two columns, one for the program name and one for the path/hash. For example:

<program name> <path>
<hash>

Repeating until it gets to the end of the file. Any pointers on this? Thanks in advance!

the_Grinch

I think I figured it out, but still open to any suggestions yay Powershell!

MSP-IT

Indentation was making the code unreadable. Sorry.