This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
you could try regular expressions, too. part of the difficulty of helping you is that your data layout isn't clear.
What starts a record? it is unclear if what you posted is one string that you just formatted on two lines here, if it comes in as as single string with a newline character in it, or if you have two separate strings. Further, are you only doing this once, or is there a file with dozens or hundreds of strings you need to parse?
if you can give us some more details, people can guide you better.
Finally, what happened when you used substring? why didn't it work? What did it give you, and what were you expecting?