|Sorry that I forgot a couple of important parts|
This is off a text file that I can't really alter.
The rules of extraction would be basically be.
Look for test, test2, test3, test4 extract data. If data for anything looked for isn't present enter 0 so that extracted would come out like