Hi there! I am new to vba and I need to create an application that can extract a text string from a text file. The text string lies between 2 other text strings that repetitively occur in the text file. I am attaching the file below:

so from this text, i need to extract the first name and last name, industry and location in different columns. You might be able to see that there are differnt first names between the text (   "firstName":"  ) and (  ","connectionCount ). Similarly different last names between ( "lastName":"  ) and (  ","linkAuto ). Then there are different industries after ( ","fmt_headline":" )      and different locations right after industry. Even if the macro copies down duplicates its fine because it will be one extra step to remove dupes. I am attaching the file and you can find what I'm looking for by searching for these strings in the text. 

I am macro illiterate and in advance I want to deeply appreciate whoever will get this working for me. you guys help out novice people like us and its a great deal! Thank you so so much!! Hats off to your brains!