https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1806945#M65653 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/114262">@Ankhi</a>&nbsp; you can use :</P><LI-CODE lang="python">mid(Field,FindOneOf(Field,'-')+1) as New_Field</LI-CODE><P>&nbsp;</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1620736741454.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54721iACF61733222C1534/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_0-1620736741454.png" alt="Taoufiq_Zarra_0-1620736741454.png" /></span></P><P>&nbsp;</P> Tue, 11 May 2021 12:39:08 GMT Taoufiq_Zarra 2021-05-11T12:39:08Z https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1806921#M65647 <P>Hi All,</P><P>I need a help to extract a portion of the text .</P><P>&nbsp;I have a field which has values like&nbsp;</P><P>1500 - Anglian Utility - Monitoring</P><P>I want to&nbsp; create another field pulling only&nbsp; 'Anglian Utility - Monitoring' i.e anything after the 1st special character '-'</P><P>in load script.</P><P>Can you please help?</P><P>Thanks in advance.</P><P>Ankhi</P> Tue, 11 May 2021 11:33:34 GMT https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1806921#M65647 Ankhi 2021-05-11T11:33:34Z https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1806945#M65653 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/114262">@Ankhi</a>&nbsp; you can use :</P><LI-CODE lang="python">mid(Field,FindOneOf(Field,'-')+1) as New_Field</LI-CODE><P>&nbsp;</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Taoufiq_Zarra_0-1620736741454.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/54721iACF61733222C1534/image-size/medium?v=v2&amp;px=400" role="button" title="Taoufiq_Zarra_0-1620736741454.png" alt="Taoufiq_Zarra_0-1620736741454.png" /></span></P><P>&nbsp;</P> Tue, 11 May 2021 12:39:08 GMT https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1806945#M65653 Taoufiq_Zarra 2021-05-11T12:39:08Z https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1807219#M65691 <P>Thanks a lot Taoufiq..It worked. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 12 May 2021 08:20:05 GMT https://community.qlik.com/t5/App-Development/Qlikview-Extract-Strings-after-Special-characters/m-p/1807219#M65691 Ankhi 2021-05-12T08:20:05Z