How to parse a string of tree categories?

Question

PHP

I took up setting up the export of data from the database. There are goods. They have categories. Categories have subcategories. I found one table in the database with one record with the following content: https://pastebin.com/S8Q9Q4FQ
How can I parse such a string? Is it possible to somehow translate this into an understandable array in order to work with it?

Answer 1

Similar to tab-separated-values. Just split the line by a break and a \t