Additional fields from a software downloaded in this way

Hello everyone

In a management system, the user can add additional fields that are fields added to the tables by the user where they can upload some product, supplier or customer characteristic that the system does not contemplate and that is of utmost importance such as a category, weight, product measurements.

By downloading the STA11 table in this case, Power Bi merged all the additional fields into one and I need to get as many separate columns as there are additional fields.

Here's what the field looks like now:

I wanted to know if anyone can help me since I can't find a way to separate them. Sometimes, the field is empty and I have no way to divide it because the lengths or characters separating them are not always the same or the same.

Thank you very much in advance

Gears