https://community.qlik.com/t5/QlikView/Extract-a-part-from-String/m-p/1535911#M439149 <P>Try:</P><P>textbetween(mid(index(FiledName,'sulko')),'(',')') as TimeString</P><P>&nbsp;</P> Mon, 28 Jan 2019 12:54:09 GMT m_woolf 2019-01-28T12:54:09Z https://community.qlik.com/t5/QlikView/Extract-a-part-from-String/m-p/1535490#M439104 <P>I have few strings like</P><P>"sulko uspedo (00:20)+podendo (01:05)+Uskudento (05:01)"</P><P><SPAN>"podendo (07:25)+sulko uspedo&nbsp; droggen(05:50)+Uskudento (05:01)"</SPAN></P><P><SPAN>"podendo (04:85)+Uskudento (03:21)+sulko uspedo (02:15)"</SPAN></P><P>&nbsp;</P><P><SPAN>I need to extract time after key word&nbsp;sulko*</SPAN></P><P><SPAN>Result of above 3 sample should be 00:20, 05:50, 02:15 respectively; any idea on extracting time after a specific keyword would be highly appreciated. Thank you!</SPAN></P><P><SPAN>&nbsp;</SPAN></P> Sat, 16 Nov 2024 04:39:14 GMT https://community.qlik.com/t5/QlikView/Extract-a-part-from-String/m-p/1535490#M439104 brijesh1991 2024-11-16T04:39:14Z https://community.qlik.com/t5/QlikView/Extract-a-part-from-String/m-p/1535911#M439149 <P>Try:</P><P>textbetween(mid(index(FiledName,'sulko')),'(',')') as TimeString</P><P>&nbsp;</P> Mon, 28 Jan 2019 12:54:09 GMT https://community.qlik.com/t5/QlikView/Extract-a-part-from-String/m-p/1535911#M439149 m_woolf 2019-01-28T12:54:09Z