topic Re: Subfield() help in QlikView https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65341#M767630 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN class="Code" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">subfield(ID, '_' ,1)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp; as New</SPAN></P></BODY></HTML> Fri, 22 Jun 2018 06:27:54 GMT Chanty4u 2018-06-22T06:27:54Z Subfield() help https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65339#M767628 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can any one please help me in below requirement.</P><P>In ID field I have the records like below.</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"><STRONG> Output ID</STRONG></SPAN></P><P>75963865&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-indent: 0px; text-align: left; color: #ff0000; font-size: 13.33px; font-style: normal; font-family: arial,helvetica,sans-serif; font-weight: 400;">75963865&nbsp; </SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">987596386&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-indent: 0px; text-align: left; color: #ff0000; font-size: 13.33px; font-style: normal; font-family: arial,helvetica,sans-serif; font-weight: 400;">987596386</SPAN></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">789456123_04586_Transfer_Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-indent: 0px; text-align: left; color: #ff0000; font-size: 13.33px; font-style: normal; font-family: arial,helvetica,sans-serif; font-weight: 400;">789456123</SPAN><BR /></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">789456123_0WR_Transfer_Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;"><BR /></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;"><BR /></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">From the above id I have to remove the data after&nbsp; '_ ' need to get the Output ID.</SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;"><BR /></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">Please help me on this.</SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;"><BR /></SPAN></P><P><SPAN style="color: #575757; font-family: arial,helvetica,sans-serif; font-size: 13.33px; font-style: normal; font-weight: 400; text-align: left; text-indent: 0px;">Thanks in advance<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65339#M767628 mahitham 2020-11-25T16:16:04Z Re: Subfield() help https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65340#M767629 <HTML><HEAD></HEAD><BODY><P>load*</P><P>,</P><P>keepchar(ID,'0123456789')&nbsp; as NewID;</P><P></P><P>load * inline[</P><P>ID</P><P>.....</P><P>.......</P><P>];</P></BODY></HTML> Fri, 22 Jun 2018 06:26:25 GMT https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65340#M767629 Chanty4u 2018-06-22T06:26:25Z Re: Subfield() help https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65341#M767630 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><SPAN class="Code" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">subfield(ID, '_' ,1)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp; as New</SPAN></P></BODY></HTML> Fri, 22 Jun 2018 06:27:54 GMT https://community.qlik.com/t5/QlikView/Subfield-help/m-p/65341#M767630 Chanty4u 2018-06-22T06:27:54Z