topic Re: Trimming Data in QlikView https://community.qlik.com/t5/QlikView/Trimming-Data/m-p/466015#M697393 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Have you tried Subfield ?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Subfield(<SPAN style="font-size: 11px; color: #800000;">code</SPAN>,'_',1) as <SPAN style="font-size: 11px; color: #800000;">Property_Code1</SPAN></P></BODY></HTML> Mon, 25 Feb 2013 00:11:41 GMT phaneendra_kunc 2013-02-25T00:11:41Z Trimming Data https://community.qlik.com/t5/QlikView/Trimming-Data/m-p/466014#M697392 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">I have a column of data that has Property Codes &amp; Property Codes_Area Codes</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">3ALB272</SPAN></P><P><SPAN style="font-size: 8pt;">3ALBERO7</SPAN></P><P><SPAN style="font-size: 8pt;">3ALBER7A</SPAN></P><P><SPAN style="font-size: 8pt;">3CAR16/2A</SPAN></P><P><SPAN style="font-size: 8pt;">3BRAD5_BR2</SPAN></P><P><SPAN style="font-size: 8pt;">3MANN2A_BR3</SPAN></P><P><SPAN style="font-size: 8pt;">3MOZ3</SPAN></P><P><SPAN style="font-size: 8pt;">3CP3-18</SPAN></P><P><SPAN style="font-size: 8pt;">3MIT117_BR12</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">I need create a column that has just the property code, that is delete the _ and data after it.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">The script below works for all that have an _ but doesn't bring across those that don't</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Left (<SPAN style="color: #800000;">code</SPAN>,<SPAN style="color: #0000ff;">Index</SPAN>(<SPAN style="color: #800000;">code</SPAN>,'_')-1),<SPAN style="color: #800000;">code</SPAN> <SPAN style="color: #0000ff;">as</SPAN> <SPAN style="color: #800000;">Property_Code1</SPAN>, </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">How can I add to this, or is there another way, so that the column of info above ends up like below</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">3ALB272</SPAN></P><P><SPAN style="font-size: 8pt;">3ALBERO7</SPAN></P><P><SPAN style="font-size: 8pt;">3ALBER7A</SPAN></P><P><SPAN style="font-size: 8pt;">3CAR16/2A</SPAN></P><P><SPAN style="font-size: 8pt;">3BRAD5</SPAN></P><P><SPAN style="font-size: 8pt;">3MANN2A</SPAN></P><P><SPAN style="font-size: 8pt;">3MOZ3</SPAN></P><P><SPAN style="font-size: 8pt;">3CP3-18</SPAN></P><P><SPAN style="font-size: 8pt;">3MIT117</SPAN></P></BODY></HTML> Sun, 24 Feb 2013 23:57:30 GMT https://community.qlik.com/t5/QlikView/Trimming-Data/m-p/466014#M697392 2013-02-24T23:57:30Z Re: Trimming Data https://community.qlik.com/t5/QlikView/Trimming-Data/m-p/466015#M697393 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Have you tried Subfield ?</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Subfield(<SPAN style="font-size: 11px; color: #800000;">code</SPAN>,'_',1) as <SPAN style="font-size: 11px; color: #800000;">Property_Code1</SPAN></P></BODY></HTML> Mon, 25 Feb 2013 00:11:41 GMT https://community.qlik.com/t5/QlikView/Trimming-Data/m-p/466015#M697393 phaneendra_kunc 2013-02-25T00:11:41Z