Extract Substring, then Ignore that Substring, while collecting data from Other substrings

The simple Data TextToColumns functionality seems to provide all you need.
Just copy the file into column A in a worksheet and specify the comma as a delimiter.