topic Re: How to trim the data? in QlikView https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553447#M206784 <HTML><HEAD></HEAD><BODY><P>say if a column(DmdUnit) has n no of data , how can i use the above conversion?</P></BODY></HTML> Tue, 09 Jul 2013 04:47:16 GMT Anonymous 2013-07-09T04:47:16Z How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553444#M206781 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have a column with data <SPAN style="font-size: 15px; font-family: Calibri, sans-serif;">like <STRONG>"00125460014600-CD", </STRONG>i want to trim and the output should be in 12 digits<STRONG> "<STRONG style="font-family: Calibri, sans-serif; font-size: 15px;">125460014600".</STRONG></STRONG></SPAN></P><P><STRONG style="font-family: Calibri, sans-serif; font-size: 15px;">Means trim first 2 digits and last 3</STRONG><STRONG style="font-family: Calibri, sans-serif; font-size: 15px;"> digits. Please help me out.</STRONG></P><P></P><P></P><P><SPAN style="font-size: 15px; font-family: Calibri, sans-serif;"><STRONG><STRONG style="font-family: Calibri, sans-serif; font-size: 15px;"><BR /></STRONG></STRONG></SPAN></P></BODY></HTML> Tue, 09 Jul 2013 04:34:48 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553444#M206781 Anonymous 2013-07-09T04:34:48Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553445#M206782 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>Mid('00125460014600-CD',3, len('00125460014600-CD')-5)</P><P></P><P></P></BODY></HTML> Tue, 09 Jul 2013 04:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553445#M206782 tresB 2013-07-09T04:40:33Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553446#M206783 <HTML><HEAD></HEAD><BODY><P>hi!!</P><P></P><P>try this!!</P><P></P><P>-------------------------------------------</P><P>mid('00125460014600',3,12)</P><P>-------------------------------------------</P></BODY></HTML> Tue, 09 Jul 2013 04:41:06 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553446#M206783 kogasawara 2013-07-09T04:41:06Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553447#M206784 <HTML><HEAD></HEAD><BODY><P>say if a column(DmdUnit) has n no of data , how can i use the above conversion?</P></BODY></HTML> Tue, 09 Jul 2013 04:47:16 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553447#M206784 Anonymous 2013-07-09T04:47:16Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553448#M206785 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">say if a column(DmdUnit) has n no of data , how can i use the above conversion?</SPAN></P></BODY></HTML> Tue, 09 Jul 2013 04:48:52 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553448#M206785 Anonymous 2013-07-09T04:48:52Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553449#M206786 <HTML><HEAD></HEAD><BODY><P>Then,</P><P></P><P>Mid(DmdUnit,3, len(DmdUnit)-5)</P><P></P><P>Assuming that the data in the field would be of similar format.</P></BODY></HTML> Tue, 09 Jul 2013 04:55:43 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553449#M206786 tresB 2013-07-09T04:55:43Z Re: How to trim the data? https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553450#M206787 <HTML><HEAD></HEAD><BODY><P>hi thank you for your replay!!!</P><P></P><P></P><P>how about this??</P><P></P><P>=left(right(DmdUnit,len(DmdUnit)-2),len(right(DmdUnit,len(DmdUnit)-2))-3)</P></BODY></HTML> Tue, 09 Jul 2013 04:59:21 GMT https://community.qlik.com/t5/QlikView/How-to-trim-the-data/m-p/553450#M206787 kogasawara 2013-07-09T04:59:21Z