topic Trim Field function - Extract number from text in QlikView https://community.qlik.com/t5/QlikView/Trim-Field-function-Extract-number-from-text/m-p/522862#M693936 <HTML><HEAD></HEAD><BODY><P>hi i am recieving the field <STRONG>name </STRONG>as the following example:1234</P><P></P><P>what i would like to do is extract only the number from the field&nbsp; as 1234. </P><P></P><P>how do i use the trim function in Qlikview to give me the last four spaces from the right hand side only?</P><P></P><P>Best,</P><P>Bradley</P></BODY></HTML> Fri, 28 Jun 2013 23:13:32 GMT 2013-06-28T23:13:32Z Trim Field function - Extract number from text https://community.qlik.com/t5/QlikView/Trim-Field-function-Extract-number-from-text/m-p/522862#M693936 <HTML><HEAD></HEAD><BODY><P>hi i am recieving the field <STRONG>name </STRONG>as the following example:1234</P><P></P><P>what i would like to do is extract only the number from the field&nbsp; as 1234. </P><P></P><P>how do i use the trim function in Qlikview to give me the last four spaces from the right hand side only?</P><P></P><P>Best,</P><P>Bradley</P></BODY></HTML> Fri, 28 Jun 2013 23:13:32 GMT https://community.qlik.com/t5/QlikView/Trim-Field-function-Extract-number-from-text/m-p/522862#M693936 2013-06-28T23:13:32Z Re: Trim Field function - Extract number from text https://community.qlik.com/t5/QlikView/Trim-Field-function-Extract-number-from-text/m-p/522863#M693937 <HTML><HEAD></HEAD><BODY><P>right(name,len(right(name,4) )) as name</P></BODY></HTML> Fri, 28 Jun 2013 23:21:40 GMT https://community.qlik.com/t5/QlikView/Trim-Field-function-Extract-number-from-text/m-p/522863#M693937 2013-06-28T23:21:40Z