topic Re: find space in cell value in QlikView https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519359#M193968 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>try <EM>subfield(id, ' ', 1)</EM></P><P></P><P>-BAA</P></BODY></HTML> Thu, 22 Aug 2013 13:58:57 GMT Brice-SACCUCCI 2013-08-22T13:58:57Z find space in cell value https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519358#M193967 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>i have column with values as below:</P><P>asvd as.wert</P><P>zxcv .wert</P><P></P><P>objective is to create new column by identifying the space and take all the left values for example</P><P></P><P>id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; calc</P><P>asvd as.wert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; asvd</P><P>zxcv .wert&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; zxcv</P><P></P><P>please advise the expression</P><P></P><P>thanks</P><P><BR /> </P></BODY></HTML> Thu, 22 Aug 2013 13:53:46 GMT https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519358#M193967 2013-08-22T13:53:46Z Re: find space in cell value https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519359#M193968 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>try <EM>subfield(id, ' ', 1)</EM></P><P></P><P>-BAA</P></BODY></HTML> Thu, 22 Aug 2013 13:58:57 GMT https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519359#M193968 Brice-SACCUCCI 2013-08-22T13:58:57Z Re: find space in cell value https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519360#M193969 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>try like this</P><P></P><P>=SubField('zxcv .wert ',' ')</P><P></P><P>Load subfield(FieldName,' ') as FieldName from tablename;</P><P></P><P>Hope that helps</P></BODY></HTML> Thu, 22 Aug 2013 13:59:36 GMT https://community.qlik.com/t5/QlikView/find-space-in-cell-value/m-p/519360#M193969 MayilVahanan 2013-08-22T13:59:36Z