Get the data of field which is an object (contains another fields)

[SurajD]

Hi Guys,

I am using Qlik sense with ODBC connector after which I am able to load the data and generate the reports properly.
Issue : I am not sure how can I get the specific value to dimension or measure from the field which contains another fields.
for example : 
I have fields(DB columns) like name,surname and cars
So car can have another attributes(crateDB object) like carname,carID,cartype etc
I am getting below data for field "car" (if i drag field car in sheet)- >
{"carname":"Audi","cartype ":"SUV","carID":123456,} 
{"carname":"Volvo","cartype ":"SUV","carID":789432,}  and so on ....

could you please give me details how can i get only carID ? I tried by doing edit expression for the field car but did not find exact function/expression as i am new to the Qlik .

Really thanks in advance,

Regards,

Suraj Dighodkar

[Saravanan_Desingh]

One solution is.

tab1:
LOAD *, TextBetween(F1,'"carID":',',') As CarID;
LOAD * INLINE [
    F1
    '{"carname":"Audi","cartype ":"SUV","carID":123456,} '
    '{"carname":"Volvo","cartype ":"SUV","carID":789432,} '
];

[Saravanan_Desingh]

Output.

[SurajD]

Hi @Saravanan_Desingh 

After using 

TextBetween(F1,'"carID":',',')

 I am able to get the data of fields inside field correctly.  The car data is just example but we are having some other huge data, and I am able to get those data also, Thanks for suggesting the solution it works for me. 

Thank you.

Regards,

Suraj Dighodkar