topic separate code. in QlikView https://community.qlik.com/t5/QlikView/separate-code/m-p/147317#M25752 <HTML><HEAD></HEAD><BODY><P>Many Thanks,</P><P>regards.</P><P>--</P><P>Slasj<IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Sun, 21 Jun 2009 01:11:52 GMT 2009-06-21T01:11:52Z separate code. https://community.qlik.com/t5/QlikView/separate-code/m-p/147315#M25750 <HTML><HEAD></HEAD><BODY><P><BR />Hello,<BR /><BR />In my field called item I found thesecodes:</P><P><BR />--------------------------------------------------------<BR />Item<BR />--------------------------------------------------------<BR />codeXX-125<BR /><BR />cd-A25<BR />mycodenew-1lp01<BR />--------------------------------------------------------<BR /><BR />The structure is build like below:<BR /><BR /> s-b<BR /><BR />part "a", dash and part "b"<BR /><BR />So, I would to separate the part a to part b in this way:<BR /><BR />code1:<BR />codeXX<BR />cd<BR />mycodenew<BR /><BR />code 2:<BR /><BR />125<BR />A25<BR />1lp01<BR /><BR />Please could to help me?<BR />Thanks<BR />Best Regards</P><P></P><P>--</P><P>Slash [:)]</P></BODY></HTML> Sat, 20 Jun 2009 22:54:41 GMT https://community.qlik.com/t5/QlikView/separate-code/m-p/147315#M25750 2009-06-20T22:54:41Z separate code. https://community.qlik.com/t5/QlikView/separate-code/m-p/147316#M25751 <HTML><HEAD></HEAD><BODY><P>Slash,<BR />Looks like you are looking for subfield:<BR />subfield(code,'-',1) as code1<BR />subfield(code,'-',2) as code2</P></BODY></HTML> Sun, 21 Jun 2009 01:02:19 GMT https://community.qlik.com/t5/QlikView/separate-code/m-p/147316#M25751 Anonymous 2009-06-21T01:02:19Z separate code. https://community.qlik.com/t5/QlikView/separate-code/m-p/147317#M25752 <HTML><HEAD></HEAD><BODY><P>Many Thanks,</P><P>regards.</P><P>--</P><P>Slasj<IMG alt="Smile" src="http://community.qlik.com/emoticons/emotion-1.gif" /></P></BODY></HTML> Sun, 21 Jun 2009 01:11:52 GMT https://community.qlik.com/t5/QlikView/separate-code/m-p/147317#M25752 2009-06-21T01:11:52Z