topic indexing in QlikView https://community.qlik.com/t5/QlikView/indexing/m-p/128025#M759596 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>hope that you can help with this,</P><P>I have a field looks like this :</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Input</STRONG></SPAN>:</P><P>1|225536</P><P>11|31256323</P><P>13|54335</P><P>2|55363</P><P></P><P>I need the output field in the script all numbers before " | " in this case the output will be</P><P>1</P><P>11</P><P>13</P><P>2</P><P></P><P>Thank you </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mario-sarkis 2020-11-25T16:16:04Z indexing https://community.qlik.com/t5/QlikView/indexing/m-p/128025#M759596 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>hope that you can help with this,</P><P>I have a field looks like this :</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Input</STRONG></SPAN>:</P><P>1|225536</P><P>11|31256323</P><P>13|54335</P><P>2|55363</P><P></P><P>I need the output field in the script all numbers before " | " in this case the output will be</P><P>1</P><P>11</P><P>13</P><P>2</P><P></P><P>Thank you </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/indexing/m-p/128025#M759596 mario-sarkis 2020-11-25T16:16:04Z Re: indexing https://community.qlik.com/t5/QlikView/indexing/m-p/128026#M759597 <HTML><HEAD></HEAD><BODY><P>subfield(Input,'|',1)</P></BODY></HTML> Fri, 10 Aug 2018 12:17:48 GMT https://community.qlik.com/t5/QlikView/indexing/m-p/128026#M759597 bramkn 2018-08-10T12:17:48Z Re: indexing https://community.qlik.com/t5/QlikView/indexing/m-p/128027#M759598 <HTML><HEAD></HEAD><BODY><P>use subfield, <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">subfield</SPAN><SPAN style="font-size: 8pt;">(Input,'|') </SPAN></P></BODY></HTML> Fri, 10 Aug 2018 12:18:56 GMT https://community.qlik.com/t5/QlikView/indexing/m-p/128027#M759598 stabben23 2018-08-10T12:18:56Z