topic How can I extract something from this string text? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876617#M306086 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the following data:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90327_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>How can I extract the code between the symbols ^ ^ above?</P><P></P><P>I want those values to exist in a separate field <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 22 Jun 2015 19:48:11 GMT jblomqvist 2015-06-22T19:48:11Z How can I extract something from this string text? https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876617#M306086 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have the following data:</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/90327_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>How can I extract the code between the symbols ^ ^ above?</P><P></P><P>I want those values to exist in a separate field <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thank you!</P></BODY></HTML> Mon, 22 Jun 2015 19:48:11 GMT https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876617#M306086 jblomqvist 2015-06-22T19:48:11Z Re: How can I extract something from this string text? https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876618#M306087 <HTML><HEAD></HEAD><BODY><P>Either</P><P>subfield (FieldName, '^', 2)</P><P>or</P><P>TextBetween(FieldName, 'CLIENT001^', '^20')</P><P></P><P></P><P>Edit:</P><P>or</P><P>mid(FieldName,11,7)</P><P>or ...</P></BODY></HTML> Mon, 22 Jun 2015 19:50:38 GMT https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876618#M306087 Anonymous 2015-06-22T19:50:38Z Re: How can I extract something from this string text? https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876619#M306088 <HTML><HEAD></HEAD><BODY><P><SPAN class="Code"><BR /></SPAN></P><P><SPAN class="Code">load</SPAN></P><P><SPAN class="Code">yourfield,<BR /></SPAN></P><P><SPAN class="Code">subfield(yourfield, '^' ,1)</SPAN> as firstfield,</P><P><SPAN class="Code" style="font-size: 13.3333330154419px;">subfield(yourfield, '^' ,2)</SPAN><SPAN style="font-size: 13.3333330154419px;"> as secondfield,</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">.........</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">from</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">.......<BR /></SPAN></P></BODY></HTML> Mon, 22 Jun 2015 19:52:59 GMT https://community.qlik.com/t5/QlikView/How-can-I-extract-something-from-this-string-text/m-p/876619#M306088 maxgro 2015-06-22T19:52:59Z