Data Extract and Separation From QVD

[Ursa_Rex]

Morning all, I have a QVD file that contains the following field filled with data; 

My question is how do I extract this data and separate them into their own fields in the data load editor?

[LRuCelver · Accepted solution]

This might help: Parsing JSON in QlikSense? - Qlik Community - 76446

[Anil_Babu_Samineni]

@Ursa_Rex I strongly recommend to use tools to convert into correct format. Meantime, Please share the data at least one row in text format (Not in image) and tell us expected result from that. 

In case if you have different formats then it is really difficult to manage like this. From above screenshot, If i read both rows seems to be fine and extracted in same format.