https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647576#M447617 <P>I think what you really need is Index() function</P><LI-CODE lang="markup">Index(RefIDWL, ' - ', 1)</LI-CODE> Fri, 15 Nov 2019 16:04:38 GMT sunny_talwar 2019-11-15T16:04:38Z https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647557#M447614 <P>Hi,</P><P>To split some data in a string, i'm using "FindOneOf(RefIDWL,' - ',1)".</P><P>Everything works wel except that the function does not only find ' - ' but also '-'.</P><P>Is there a solution?</P><P>Greetings&nbsp;</P><P>Dirk.</P> Sat, 16 Nov 2024 19:39:49 GMT https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647557#M447614 dirk1955 2024-11-16T19:39:49Z https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647566#M447616 try this:<BR />FindOneOf(replace( RefIDWL , ' ' , '@' ) ,'@-@',1) Fri, 15 Nov 2019 15:40:27 GMT https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647566#M447616 Marcos_rv 2019-11-15T15:40:27Z https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647576#M447617 <P>I think what you really need is Index() function</P><LI-CODE lang="markup">Index(RefIDWL, ' - ', 1)</LI-CODE> Fri, 15 Nov 2019 16:04:38 GMT https://community.qlik.com/t5/QlikView/Searching-for-in-a-string/m-p/1647576#M447617 sunny_talwar 2019-11-15T16:04:38Z