topic FIND IN A STRING in QlikView https://community.qlik.com/t5/QlikView/FIND-IN-A-STRING/m-p/141199#M602233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field that takes names but in some cases the values are</P><P></P><P>NAME1</P><P>NAME2</P><P>NAME1&amp;NAME2</P><P>NAME3</P><P>NAME1&amp;NAME2&amp;NAME3</P><P></P><P>I need to find from another list the names that are in the example and i have to separate this in differentes columns.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Oct 2018 15:58:48 GMT jumiprado 2018-10-08T15:58:48Z FIND IN A STRING https://community.qlik.com/t5/QlikView/FIND-IN-A-STRING/m-p/141199#M602233 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field that takes names but in some cases the values are</P><P></P><P>NAME1</P><P>NAME2</P><P>NAME1&amp;NAME2</P><P>NAME3</P><P>NAME1&amp;NAME2&amp;NAME3</P><P></P><P>I need to find from another list the names that are in the example and i have to separate this in differentes columns.</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 08 Oct 2018 15:58:48 GMT https://community.qlik.com/t5/QlikView/FIND-IN-A-STRING/m-p/141199#M602233 jumiprado 2018-10-08T15:58:48Z Re: FIND IN A STRING https://community.qlik.com/t5/QlikView/FIND-IN-A-STRING/m-p/141200#M602234 <HTML><HEAD></HEAD><BODY><P>Can you show an example values of your field. </P><P></P><P>You can use like Subfield(Yourfieldname, ',') comma here is a delimiter. </P></BODY></HTML> Mon, 08 Oct 2018 16:03:55 GMT https://community.qlik.com/t5/QlikView/FIND-IN-A-STRING/m-p/141200#M602234 vishsaggi 2018-10-08T16:03:55Z