topic Data Trim in QlikView https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244991#M1183317 <HTML><HEAD></HEAD><BODY><P> Hey Thanks.it worked.</P></BODY></HTML> Tue, 22 Nov 2011 15:46:22 GMT 2011-11-22T15:46:22Z Data Trim https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244989#M1183312 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone please let me know how this can be achieved?</P><P><SPAN style="text-decoration: line-through;"> </SPAN></P><P><SPAN style="text-decoration: underline;">Raw data </SPAN></P><P>12345*abcd</P><P>xyz123*ssss</P><P></P><P><SPAN style="text-decoration: underline;">The result should display </SPAN></P><P>12345</P><P>xyz123</P><P></P><P>Thanks,Pooja</P></BODY></HTML> Mon, 21 Nov 2011 21:34:29 GMT https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244989#M1183312 2011-11-21T21:34:29Z Data Trim https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244990#M1183314 <HTML><HEAD></HEAD><BODY><P>Maybe </P><P></P><P>Load</P><P>...</P><P>subfield( [Raw data],'*',1) as Result</P><P>from...</P></BODY></HTML> Mon, 21 Nov 2011 21:50:33 GMT https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244990#M1183314 swuehl 2011-11-21T21:50:33Z Data Trim https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244991#M1183317 <HTML><HEAD></HEAD><BODY><P> Hey Thanks.it worked.</P></BODY></HTML> Tue, 22 Nov 2011 15:46:22 GMT https://community.qlik.com/t5/QlikView/Data-Trim/m-p/244991#M1183317 2011-11-22T15:46:22Z