https://community.qlik.com/t5/QlikView/Index-Function/m-p/1613029#M596812 <P>JSON value has several parts that I need to grab just one, AnswerText (AT).</P><P>AnswerPart:,AnswerColumn:,AnswerText:,AnswerExportValue:,AnswerComment:,AnswerOther</P><P>AT contains a value that I have grabbed easily for another function, but for this in particular, I have done a subfield, replace, mid, and index but am not finding the right part I need.&nbsp;</P><P>replace(mid(AT,index(AT,':',3)+1,index(AT,',',3)-index(AT,':',3)-1),'"','')</P><P>AT can have three values: "Online", "In Person", and "Friend, Family, someone else"</P><P>With the above function, I am only grabbing the first value before the comma which removes the ", Family, someone else" of that AT value.</P><P>Can anyone help with being able to grab that whole part: "Friend, Family, someone else"?</P><P>Help me Obi-Wan Kenobi, you're my only hope</P> Sat, 16 Nov 2024 20:15:28 GMT SonOfJeffGoldblum 2024-11-16T20:15:28Z https://community.qlik.com/t5/QlikView/Index-Function/m-p/1613029#M596812 <P>JSON value has several parts that I need to grab just one, AnswerText (AT).</P><P>AnswerPart:,AnswerColumn:,AnswerText:,AnswerExportValue:,AnswerComment:,AnswerOther</P><P>AT contains a value that I have grabbed easily for another function, but for this in particular, I have done a subfield, replace, mid, and index but am not finding the right part I need.&nbsp;</P><P>replace(mid(AT,index(AT,':',3)+1,index(AT,',',3)-index(AT,':',3)-1),'"','')</P><P>AT can have three values: "Online", "In Person", and "Friend, Family, someone else"</P><P>With the above function, I am only grabbing the first value before the comma which removes the ", Family, someone else" of that AT value.</P><P>Can anyone help with being able to grab that whole part: "Friend, Family, someone else"?</P><P>Help me Obi-Wan Kenobi, you're my only hope</P> Sat, 16 Nov 2024 20:15:28 GMT https://community.qlik.com/t5/QlikView/Index-Function/m-p/1613029#M596812 SonOfJeffGoldblum 2024-11-16T20:15:28Z https://community.qlik.com/t5/QlikView/Index-Function/m-p/1613500#M596813 <P>How about</P><P><STRONG>If(Index(AT, 'AnswerText (AT)'), AT) as&nbsp;AT</STRONG></P> Sat, 17 Aug 2019 14:09:11 GMT https://community.qlik.com/t5/QlikView/Index-Function/m-p/1613500#M596813 Anil_Babu_Samineni 2019-08-17T14:09:11Z