topic Re: Extract Text from Field in QlikView https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696561#M1085150 <HTML><HEAD></HEAD><BODY><P>This should work</P><P></P><P>=right(SKU,index(SKU,' - ',-1))</P><P></P><P>Eduardo</P></BODY></HTML> Tue, 17 Jun 2014 20:47:15 GMT eduardo_sommer 2014-06-17T20:47:15Z Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696557#M1085146 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I have a list of SKU numbers and descriptions like the following:</P><P></P><P>567 - MICROWAVE 6 1/2 C </P><P></P><P>How would I extract everything after the hyphen?</P><P></P><P>Thanks!</P><P></P><P>Isabel</P></BODY></HTML> Tue, 17 Jun 2014 20:33:54 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696557#M1085146 Anonymous 2014-06-17T20:33:54Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696558#M1085147 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>subfield(SKU, '-',2)</P><P></P><P>eduardo</P></BODY></HTML> Tue, 17 Jun 2014 20:37:03 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696558#M1085147 eduardo_sommer 2014-06-17T20:37:03Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696559#M1085148 <HTML><HEAD></HEAD><BODY><P>Use subfield funcion</P><P>Subfield(ltrim(Right(Replace(SKU),'-',' '),3))</P></BODY></HTML> Tue, 17 Jun 2014 20:39:01 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696559#M1085148 venkatg6759 2014-06-17T20:39:01Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696560#M1085149 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>Thanks!</P><P></P><P>What if I were to have something like</P><P></P><P>4576 - Flower Pot - Misc </P><P></P><P>and want everything after the first hyphen?</P><P></P><P>Isabel</P></BODY></HTML> Tue, 17 Jun 2014 20:39:45 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696560#M1085149 Anonymous 2014-06-17T20:39:45Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696561#M1085150 <HTML><HEAD></HEAD><BODY><P>This should work</P><P></P><P>=right(SKU,index(SKU,' - ',-1))</P><P></P><P>Eduardo</P></BODY></HTML> Tue, 17 Jun 2014 20:47:15 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696561#M1085150 eduardo_sommer 2014-06-17T20:47:15Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696562#M1085151 <HTML><HEAD></HEAD><BODY><P>Hmm..that doesn't work in every case. It usually only gives me everything after the last hyphen. </P></BODY></HTML> Tue, 17 Jun 2014 20:51:08 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696562#M1085151 Anonymous 2014-06-17T20:51:08Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696563#M1085152 <HTML><HEAD></HEAD><BODY><P>everything after first <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hyphen</SPAN></P><P>=right(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN>,&nbsp; len(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN> - index(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN>, '-', 1))</P><P></P><P>everything after last <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hyphen</SPAN></P><P>=right(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN>,&nbsp; len(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN> - index(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SKU</SPAN>, '-', -1))</P></BODY></HTML> Tue, 17 Jun 2014 22:07:53 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696563#M1085152 maxgro 2014-06-17T22:07:53Z Re: Extract Text from Field https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696564#M1085153 <HTML><HEAD></HEAD><BODY><P>Or a little shorter using mid() function:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=mid(</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SKU</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">,&nbsp; </SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">index(</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SKU</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">, '-', 1)+1)</SPAN></P></BODY></HTML> Tue, 17 Jun 2014 22:16:58 GMT https://community.qlik.com/t5/QlikView/Extract-Text-from-Field/m-p/696564#M1085153 swuehl 2014-06-17T22:16:58Z