topic Re: Remove symbols in QlikView https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826992#M291171 <HTML><HEAD></HEAD><BODY><P>=purgechar(Names,'|')</P></BODY></HTML> Mon, 15 Dec 2014 13:00:47 GMT saumyashah90 2014-12-15T13:00:47Z Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826987#M291166 <HTML><HEAD></HEAD><BODY><P>I have table with multiple fields and from on field named Names i want to remove the symbol |</P><P></P><TABLE><TBODY><TR><TD>KEY,</TD><TD>Names</TD></TR><TR><TD>1,</TD><TD>Alan | Bros</TD></TR><TR><TD>2,</TD><TD>Peter | Kobal</TD></TR><TR><TD>3,</TD><TD>James | Kris</TD></TR><TR><TD>4,</TD><TD>Martin | Ross</TD></TR><TR><TD>5,</TD><TD>Kristien | Grenn</TD></TR></TBODY></TABLE><P></P><P></P><P>Jay </P></BODY></HTML> Mon, 15 Dec 2014 12:55:51 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826987#M291166 2014-12-15T12:55:51Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826988#M291167 <HTML><HEAD></HEAD><BODY><P>=purgechar ( 'Alan | Bros' , '|' )</P></BODY></HTML> Mon, 15 Dec 2014 12:57:25 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826988#M291167 Anonymous 2014-12-15T12:57:25Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826989#M291168 <HTML><HEAD></HEAD><BODY><P>Use</P><P>=Subfield(Names,'|',1)&amp; ' ' &amp;Subfield(Names,'|',2)</P></BODY></HTML> Mon, 15 Dec 2014 12:58:02 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826989#M291168 saumyashah90 2014-12-15T12:58:02Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826990#M291169 <HTML><HEAD></HEAD><BODY><P>Use the replace function.</P><P>An example: <SPAN class="Code">replace('abccde','cc','xyz')</SPAN> returns '<SPAN class="Italic">abxyzde</SPAN>'</P><P>In your case = Replace(Names,'|',' ')</P><P>Hope it helps!</P><P></P><P>Br,</P><P></P><P>T</P></BODY></HTML> Mon, 15 Dec 2014 12:58:46 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826990#M291169 2014-12-15T12:58:46Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826991#M291170 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try to load your table like this way</P><P></P><P>Source:</P><P>LOAD SubField(Names,'|') as New, KEY,&nbsp;&nbsp; Names;</P><P>LOAD * Inline</P><P>[</P><P>KEY,&nbsp;&nbsp;&nbsp; Names</P><P>1,&nbsp;&nbsp;&nbsp; Alan | Bros</P><P>2,&nbsp;&nbsp;&nbsp; Peter | Kobal</P><P>3,&nbsp;&nbsp;&nbsp; James | Kris</P><P>4,&nbsp;&nbsp;&nbsp; Martin | Ross</P><P>5,&nbsp;&nbsp;&nbsp; Kristien | Grenn</P><P>];</P><P></P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 15 Dec 2014 12:58:59 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826991#M291170 its_anandrjs 2014-12-15T12:58:59Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826992#M291171 <HTML><HEAD></HEAD><BODY><P>=purgechar(Names,'|')</P></BODY></HTML> Mon, 15 Dec 2014 13:00:47 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826992#M291171 saumyashah90 2014-12-15T13:00:47Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826993#M291172 <HTML><HEAD></HEAD><BODY><P>You can use purgeChar().</P><P></P><P>ex: PurgeChar(Names,'|')</P></BODY></HTML> Mon, 15 Dec 2014 13:01:06 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826993#M291172 jpenuliar 2014-12-15T13:01:06Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826994#M291173 <HTML><HEAD></HEAD><BODY><P>Check this file</P></BODY></HTML> Mon, 15 Dec 2014 13:01:37 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826994#M291173 saumyashah90 2014-12-15T13:01:37Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826995#M291174 <HTML><HEAD></HEAD><BODY><P>And how can i create the two fields in the load script from the same.</P></BODY></HTML> Mon, 15 Dec 2014 13:03:39 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826995#M291174 2014-12-15T13:03:39Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826996#M291175 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Then try this ways</P><P></P><P>Source:</P><P>LOAD *,SubField(Names,'|',1) as FirstName,</P><P>SubField(Names,'|',2) as LastName;</P><P>LOAD SubField(Names,'|') as New,KEY,&nbsp;&nbsp;&nbsp; Names;</P><P>LOAD * Inline</P><P>[</P><P>KEY,&nbsp;&nbsp;&nbsp; Names</P><P>1,&nbsp;&nbsp;&nbsp; Alan | Bros</P><P>2,&nbsp;&nbsp;&nbsp; Peter | Kobal</P><P>3,&nbsp;&nbsp;&nbsp; James | Kris</P><P>4,&nbsp;&nbsp;&nbsp; Martin | Ross</P><P>5,&nbsp;&nbsp;&nbsp; Kristien | Grenn</P><P>];</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 15 Dec 2014 13:04:40 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826996#M291175 its_anandrjs 2014-12-15T13:04:40Z Re: Remove symbols https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826997#M291176 <HTML><HEAD></HEAD><BODY><P>tst</P></BODY></HTML> Mon, 06 Apr 2015 20:05:40 GMT https://community.qlik.com/t5/QlikView/Remove-symbols/m-p/826997#M291176 maxgro 2015-04-06T20:05:40Z