topic Re: Mid statement based on character in QlikView https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037796#M639478 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use subfield()</P><P></P><P>try like </P><P>subfield(fieldName,'#',2)</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P></BODY></HTML> Fri, 26 Feb 2016 11:54:21 GMT PrashantSangle 2016-02-26T11:54:21Z Mid statement based on character https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037794#M639476 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to remove some text from the beginning of a field by expression / script.&nbsp; The seperater is '#', but it is not always at the same mid point of the field.&nbsp; Could anyone help.&nbsp; Please see below&nbsp; ....</P><P></P><P></P><P>123;#Peter Jones</P><P>56789;# John Smith</P><P></P><P>I want to show .....</P><P></P><P>Peter Jones</P><P>John Smith</P><P></P><P></P><P>Any thoughts welcome</P><P></P><P></P><P>Thanks&nbsp;&nbsp; </P><P></P><P></P><P>Phil</P></BODY></HTML> Fri, 26 Feb 2016 11:50:45 GMT https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037794#M639476 Anonymous 2016-02-26T11:50:45Z Re: Mid statement based on character https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037795#M639477 <HTML><HEAD></HEAD><BODY><P>SubField(YourField, '#', 2) as Name</P></BODY></HTML> Fri, 26 Feb 2016 11:53:33 GMT https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037795#M639477 tresB 2016-02-26T11:53:33Z Re: Mid statement based on character https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037796#M639478 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use subfield()</P><P></P><P>try like </P><P>subfield(fieldName,'#',2)</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards</SPAN></P></BODY></HTML> Fri, 26 Feb 2016 11:54:21 GMT https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037796#M639478 PrashantSangle 2016-02-26T11:54:21Z Re: Mid statement based on character https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037797#M639479 <HTML><HEAD></HEAD><BODY><P>maybe subfield<EM><BR /></EM></P><P><EM><BR /></EM></P><P><EM>load </EM></P><P><EM>&nbsp; field,</EM></P><P><EM>&nbsp; trim(<STRONG>SubField</STRONG>(field, '#', 2)) as newfield </EM></P><P><EM>Inline [</EM></P><P><EM>field</EM></P><P><EM>123;#Peter Jones</EM></P><P><EM>56789;# John Smith</EM></P><P><EM>];</EM></P></BODY></HTML> Fri, 26 Feb 2016 11:55:41 GMT https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037797#M639479 maxgro 2016-02-26T11:55:41Z Re: Mid statement based on character https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037798#M639480 <HTML><HEAD></HEAD><BODY><P>Got it.</P><P></P><P>Thanks guys</P><P></P><P></P><P>Phil</P></BODY></HTML> Fri, 26 Feb 2016 11:58:54 GMT https://community.qlik.com/t5/QlikView/Mid-statement-based-on-character/m-p/1037798#M639480 Anonymous 2016-02-26T11:58:54Z