Looks like that data is CSV (with a M$ sep_char). You could/should switch to a real CSV reader when the data is actually more complicated than your example snippet. The de-facto modules to parse CSV are Text::CSV_XS and Text::CSV. If the data is more complicated, you could also turn to using DBD::CSV and hit the data with SQL statements.