topic Re: What is the difference between Index and FindOneOf in QlikView https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Index-and-FindOneOf/m-p/122105#M599700 <HTML><HEAD></HEAD><BODY><P>Index is looking for <EM>a</EM> <EM>substring</EM> (all characters in substring) </P><P>eg </P><P>Index('thequic<SPAN style="text-decoration: underline;">kb</SPAN>rownfox', '<SPAN style="text-decoration: underline;">kb</SPAN>')&nbsp;&nbsp;&nbsp;&nbsp; Returns 8</P><P></P><P>FindOneOf is looking for <EM>any</EM> <EM>character</EM> </P><P>eg </P><P>Index('t<SPAN style="text-decoration: underline;">h</SPAN>equickbrownfo<SPAN style="text-decoration: underline;">x</SPAN>', 'hx')&nbsp;&nbsp;&nbsp;&nbsp; Returns 2</P></BODY></HTML> Fri, 09 Nov 2018 03:02:18 GMT Lisa_P 2018-11-09T03:02:18Z What is the difference between Index and FindOneOf https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Index-and-FindOneOf/m-p/122104#M599699 <HTML><HEAD></HEAD><BODY><P>I see that both functions, Index and FindOneOf, pretty much do the same thing:</P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/Index.htm" style="font-size: 10pt;" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/Index.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/Index.htm</A></P><P></P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/FindOneOf.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/FindOneOf.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunctions/FindOneOf.htm</A></P></BODY></HTML> Thu, 08 Nov 2018 22:25:14 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Index-and-FindOneOf/m-p/122104#M599699 julioarriaga 2018-11-08T22:25:14Z Re: What is the difference between Index and FindOneOf https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Index-and-FindOneOf/m-p/122105#M599700 <HTML><HEAD></HEAD><BODY><P>Index is looking for <EM>a</EM> <EM>substring</EM> (all characters in substring) </P><P>eg </P><P>Index('thequic<SPAN style="text-decoration: underline;">kb</SPAN>rownfox', '<SPAN style="text-decoration: underline;">kb</SPAN>')&nbsp;&nbsp;&nbsp;&nbsp; Returns 8</P><P></P><P>FindOneOf is looking for <EM>any</EM> <EM>character</EM> </P><P>eg </P><P>Index('t<SPAN style="text-decoration: underline;">h</SPAN>equickbrownfo<SPAN style="text-decoration: underline;">x</SPAN>', 'hx')&nbsp;&nbsp;&nbsp;&nbsp; Returns 2</P></BODY></HTML> Fri, 09 Nov 2018 03:02:18 GMT https://community.qlik.com/t5/QlikView/What-is-the-difference-between-Index-and-FindOneOf/m-p/122105#M599700 Lisa_P 2018-11-09T03:02:18Z