topic Re: Subfield function in QlikView

topic Re: Subfield function in QlikView https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298269#M822688 <HTML><HEAD></HEAD><BODY><P>Here you go...</P><P></P><P><STRONG>A:</STRONG></P><P><STRONG>LOAD <SPAN style="color: #ff0000;">SubField(SubField(EMAILID&'/', '/', 1)&',', ',', 1) as NewEMAILID,</SPAN></STRONG></P><P><STRONG>EMAILID;</STRONG></P><P><STRONG>Load * Inline</STRONG></P><P><STRONG>[</STRONG></P><P><STRONG>EMAILID</STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:sd8698370@gmail.com">sd8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2454@yahoo.co.in">org2454@yahoo.co.in</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:a_shivekar@yahoo.co.in">a_shivekar@yahoo.co.in</A><SPAN>,datta.shivekar@ethoswatches</SPAN></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:haraakirankaur415@gmail.com">haraakirankaur415@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:SUKHWANT.SINGH@INDIA.COM">SUKHWANT.SINGH@INDIA.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:malikbj2055@yahoo.com">malikbj2055@yahoo.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@gmail.com">malikbj2055@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:nandkishorsable@hotmail.com">nandkishorsable@hotmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:rekhansable@gmail.com">rekhansable@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:NUNU.ANGEL@GMAIL.COM">NUNU.ANGEL@GMAIL.COM</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:ANU14096@GMAIL.COM">ANU14096@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:emmanuel2427@gmail.com">emmanuel2427@gmail.com</A><A class="jive-link-email-small" href="mailto:/emmanuelbijapurkar@gmail.co">/emmanuelbijapurkar@gmail.co</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:mysticalimpressions@gmail.com">mysticalimpressions@gmail.com</A><SPAN>/sabornee.karmakar@gm</SPAN></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com">/sumanroy@hotmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:09jayesh@gmail.com">09jayesh@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:13NEGI@GMAIL.COM">13NEGI@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:16MAYANKJAIN@GMAIL.COM">16MAYANKJAIN@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:0109PATILVIJAY@GMAIL.COM">0109PATILVIJAY@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:A.Khapli@gmail.com">A.Khapli@gmail.com</A></STRONG></P><P><STRONG>] (delimiter is |);</STRONG></P></BODY></HTML> Wed, 26 Jul 2017 17:20:14 GMT sunny_talwar 2017-07-26T17:20:14Z Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298268#M822687 <HTML><HEAD></HEAD><BODY><P>Hi   Experts ,</P><P>I have EMAIL ID field but it contain two email id's in one row so i want to pick only first email id which is preceding of  '/' and ','.So how can i use sub field function for both.I have attached my sample qvw.(How can i use subfield function multiple times for single column)</P><P></P><P>Example                    </P><P>EMAIL ID                                                                                             Expected OUTPUT</P><P><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com" target="_blank">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com" target="_blank">/sumanroy@hotmail.com</A><SPAN>                (</SPAN><SPAN style="font-size: 13.3333px;"><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com" target="_blank">smartrituenterprise@gmail.com</A><SPAN>)</SPAN></SPAN></P><P><A class="jive-link-email-small" href="mailto:sam8698370@gmail.com" target="_blank">sam8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2004@yahoo.co.in" target="_blank">org2004@yahoo.co.in</A><SPAN>                              (</SPAN><SPAN style="font-size: 13.3333px;"><A class="jive-link-email-small" href="mailto:sam8698370@gmail.com" target="_blank">sam8698370@gmail.com</A><SPAN>)</SPAN></SPAN></P><P></P><P>Thanks in advance</P><P>Reg<SPAN style="font-size: 10pt;">ards,</SPAN></P><P>RUP</P><P><A href="https://community.qlik.com/qlik-users/171708" target="_blank">stalwar1</A>‌<A href="https://community.qlik.com/qlik-users/34510" target="_blank">kaushik.solanki</A>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298268#M822687 rupaliqlik 2020-11-25T16:16:04Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298269#M822688 <HTML><HEAD></HEAD><BODY><P>Here you go...</P><P></P><P><STRONG>A:</STRONG></P><P><STRONG>LOAD <SPAN style="color: #ff0000;">SubField(SubField(EMAILID&'/', '/', 1)&',', ',', 1) as NewEMAILID,</SPAN></STRONG></P><P><STRONG>EMAILID;</STRONG></P><P><STRONG>Load * Inline</STRONG></P><P><STRONG>[</STRONG></P><P><STRONG>EMAILID</STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:sd8698370@gmail.com">sd8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2454@yahoo.co.in">org2454@yahoo.co.in</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:a_shivekar@yahoo.co.in">a_shivekar@yahoo.co.in</A><SPAN>,datta.shivekar@ethoswatches</SPAN></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:haraakirankaur415@gmail.com">haraakirankaur415@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:SUKHWANT.SINGH@INDIA.COM">SUKHWANT.SINGH@INDIA.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:malikbj2055@yahoo.com">malikbj2055@yahoo.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@gmail.com">malikbj2055@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:nandkishorsable@hotmail.com">nandkishorsable@hotmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:rekhansable@gmail.com">rekhansable@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:NUNU.ANGEL@GMAIL.COM">NUNU.ANGEL@GMAIL.COM</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:ANU14096@GMAIL.COM">ANU14096@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:emmanuel2427@gmail.com">emmanuel2427@gmail.com</A><A class="jive-link-email-small" href="mailto:/emmanuelbijapurkar@gmail.co">/emmanuelbijapurkar@gmail.co</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:mysticalimpressions@gmail.com">mysticalimpressions@gmail.com</A><SPAN>/sabornee.karmakar@gm</SPAN></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com">/sumanroy@hotmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:09jayesh@gmail.com">09jayesh@gmail.com</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:13NEGI@GMAIL.COM">13NEGI@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:16MAYANKJAIN@GMAIL.COM">16MAYANKJAIN@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:0109PATILVIJAY@GMAIL.COM">0109PATILVIJAY@GMAIL.COM</A></STRONG></P><P><STRONG><A class="jive-link-email-small" href="mailto:A.Khapli@gmail.com">A.Khapli@gmail.com</A></STRONG></P><P><STRONG>] (delimiter is |);</STRONG></P></BODY></HTML> Wed, 26 Jul 2017 17:20:14 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298269#M822688 sunny_talwar 2017-07-26T17:20:14Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298270#M822689 <HTML><HEAD></HEAD><BODY><P>A:</P><P>Load * Inline</P><P>[</P><P>EMAILID</P><P><A class="jive-link-email-small" href="mailto:sd8698370@gmail.com">sd8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2454@yahoo.co.in">org2454@yahoo.co.in</A></P><P><A class="jive-link-email-small" href="mailto:a_shivekar@yahoo.co.in">a_shivekar@yahoo.co.in</A><SPAN>,datta.shivekar@ethoswatches</SPAN></P><P><A class="jive-link-email-small" href="mailto:haraakirankaur415@gmail.com">haraakirankaur415@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:SUKHWANT.SINGH@INDIA.COM">SUKHWANT.SINGH@INDIA.COM</A></P><P><A class="jive-link-email-small" href="mailto:malikbj2055@yahoo.com">malikbj2055@yahoo.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@gmail.com">malikbj2055@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:nandkishorsable@hotmail.com">nandkishorsable@hotmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:rekhansable@gmail.com">rekhansable@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:NUNU.ANGEL@GMAIL.COM">NUNU.ANGEL@GMAIL.COM</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:ANU14096@GMAIL.COM">ANU14096@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:emmanuel2427@gmail.com">emmanuel2427@gmail.com</A><A class="jive-link-email-small" href="mailto:/emmanuelbijapurkar@gmail.co">/emmanuelbijapurkar@gmail.co</A></P><P><A class="jive-link-email-small" href="mailto:mysticalimpressions@gmail.com">mysticalimpressions@gmail.com</A><SPAN>/sabornee.karmakar@gm</SPAN></P><P><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com">/sumanroy@hotmail.com</A></P><P><A class="jive-link-email-small" href="mailto:09jayesh@gmail.com">09jayesh@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:13NEGI@GMAIL.COM">13NEGI@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:16MAYANKJAIN@GMAIL.COM">16MAYANKJAIN@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:0109PATILVIJAY@GMAIL.COM">0109PATILVIJAY@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:A.Khapli@gmail.com">A.Khapli@gmail.com</A></P><P>];</P><P>NoConcatenate</P><P>B:</P><P>Load</P><P>subfield(replace(EMAILID,',','/'),'/',1) as EmailID</P><P>Resident A;</P><P>DROP Table A;</P></BODY></HTML> Wed, 26 Jul 2017 17:41:17 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298270#M822689 Anonymous 2017-07-26T17:41:17Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298271#M822690 <HTML><HEAD></HEAD><BODY><P>=if(index(EMAILID,'/') > 0,SubField(EMAILID,'/',1),SubField(EMAILID,',',1))</P></BODY></HTML> Wed, 26 Jul 2017 18:36:21 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298271#M822690 ziadm 2017-07-26T18:36:21Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298272#M822691 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>another solution for multiple possible email delimiters might be:</P><P></P><P><IMG __jive_id="171679" alt="QlikCommunity_Thread_269085_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171679_QlikCommunity_Thread_269085_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1501191252663673" jivemacro_uid="_1501191252663673"> <P>A:</P> <P>Load *,</P> <P>    Left(EMAILID,FindOneOf(EMAILID&',','/, ;')-1) as FIRSTEMAILID</P> <P>INLINE [</P> <P>    EMAILID</P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:sd8698370@gmail.com">sd8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2454@yahoo.co.in">org2454@yahoo.co.in</A><SPAN>"</SPAN></P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:a_shivekar@yahoo.co.in">a_shivekar@yahoo.co.in</A><SPAN>,datta.shivekar@ethoswatches"</SPAN></P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:haraakirankaur415@gmail.com">haraakirankaur415@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:SUKHWANT.SINGH@INDIA.COM">SUKHWANT.SINGH@INDIA.COM</A><SPAN>"</SPAN></P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@yahoo.com">malikbj2055@yahoo.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@gmail.com">malikbj2055@gmail.com</A><SPAN>"</SPAN></P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:nandkishorsable@hotmail.com">nandkishorsable@hotmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:rekhansable@gmail.com">rekhansable@gmail.com</A><SPAN>"</SPAN></P> <P><SPAN>    "</SPAN><A class="jive-link-email-small" href="mailto:NUNU.ANGEL@GMAIL.COM">NUNU.ANGEL@GMAIL.COM</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:ANU14096@GMAIL.COM">ANU14096@GMAIL.COM</A><SPAN>"</SPAN></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:emmanuel2427@gmail.com">emmanuel2427@gmail.com</A><A class="jive-link-email-small" href="mailto:/emmanuelbijapurkar@gmail.co">/emmanuelbijapurkar@gmail.co</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:mysticalimpressions@gmail.com">mysticalimpressions@gmail.com</A><SPAN>/sabornee.karmakar@gm</SPAN></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com">/sumanroy@hotmail.com</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:09jayesh@gmail.com">09jayesh@gmail.com</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:13NEGI@GMAIL.COM">13NEGI@GMAIL.COM</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:16MAYANKJAIN@GMAIL.COM">16MAYANKJAIN@GMAIL.COM</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:0109PATILVIJAY@GMAIL.COM">0109PATILVIJAY@GMAIL.COM</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:A.Khapli@gmail.com">A.Khapli@gmail.com</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:10johndoe@gmail.com">10johndoe@gmail.com</A><SPAN> </SPAN><A class="jive-link-email-small" href="mailto:11janedoe@gmail.com">11janedoe@gmail.com</A></P> <P><SPAN>    </SPAN><A class="jive-link-email-small" href="mailto:12johnsmith@gmail.com">12johnsmith@gmail.com</A><SPAN>;</SPAN><A class="jive-link-email-small" href="mailto:13janesmith@gmail.com">13janesmith@gmail.com</A></P> <P>];</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 27 Jul 2017 21:36:07 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298272#M822691 MarcoWedel 2017-07-27T21:36:07Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298273#M822692 <HTML><HEAD></HEAD><BODY><P>please close your open threads if your questions are answered:</P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 02 Aug 2017 19:22:52 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298273#M822692 MarcoWedel 2017-08-02T19:22:52Z Re: Subfield function https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298274#M822693 <HTML><HEAD></HEAD><BODY><P>Another Solution may be</P><P></P><P>A:</P><P>Load </P><P>Subfield(Replace(EMAILID,'/',','),',',1) as NewEMAILID,</P><P>EMAILID;</P><P>Load * Inline</P><P>[</P><P>EMAILID</P><P><A class="jive-link-email-small" href="mailto:sd8698370@gmail.com">sd8698370@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:org2454@yahoo.co.in">org2454@yahoo.co.in</A></P><P><A class="jive-link-email-small" href="mailto:a_shivekar@yahoo.co.in">a_shivekar@yahoo.co.in</A><SPAN>,datta.shivekar@ethoswatches</SPAN></P><P><A class="jive-link-email-small" href="mailto:haraakirankaur415@gmail.com">haraakirankaur415@gmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:SUKHWANT.SINGH@INDIA.COM">SUKHWANT.SINGH@INDIA.COM</A></P><P><A class="jive-link-email-small" href="mailto:malikbj2055@yahoo.com">malikbj2055@yahoo.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:malikbj2055@gmail.com">malikbj2055@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:nandkishorsable@hotmail.com">nandkishorsable@hotmail.com</A><SPAN>,</SPAN><A class="jive-link-email-small" href="mailto:rekhansable@gmail.com">rekhansable@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:NUNU.ANGEL@GMAIL.COM">NUNU.ANGEL@GMAIL.COM</A><SPAN>, </SPAN><A class="jive-link-email-small" href="mailto:ANU14096@GMAIL.COM">ANU14096@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:emmanuel2427@gmail.com">emmanuel2427@gmail.com</A><A class="jive-link-email-small" href="mailto:/emmanuelbijapurkar@gmail.co">/emmanuelbijapurkar@gmail.co</A></P><P><A class="jive-link-email-small" href="mailto:mysticalimpressions@gmail.com">mysticalimpressions@gmail.com</A><SPAN>/sabornee.karmakar@gm</SPAN></P><P><A class="jive-link-email-small" href="mailto:smartrituenterprise@gmail.com">smartrituenterprise@gmail.com</A><A class="jive-link-email-small" href="mailto:/sumanroy@hotmail.com">/sumanroy@hotmail.com</A></P><P><A class="jive-link-email-small" href="mailto:09jayesh@gmail.com">09jayesh@gmail.com</A></P><P><A class="jive-link-email-small" href="mailto:13NEGI@GMAIL.COM">13NEGI@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:16MAYANKJAIN@GMAIL.COM">16MAYANKJAIN@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:0109PATILVIJAY@GMAIL.COM">0109PATILVIJAY@GMAIL.COM</A></P><P><A class="jive-link-email-small" href="mailto:A.Khapli@gmail.com">A.Khapli@gmail.com</A></P><P>];</P></BODY></HTML> Thu, 03 Aug 2017 11:20:35 GMT https://community.qlik.com/t5/QlikView/Subfield-function/m-p/1298274#M822693 sasiparupudi1 2017-08-03T11:20:35Z