How does the split solution you posted handle the following portion of the OP's input?

obviously it doesn't -- just like the OPs actual code

use Text::CSV or Text::xSV