topic Re: Extract first word without comma in QlikView https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691062#M250116 <HTML><HEAD></HEAD><BODY><P>Thanks lot tresesco, it works ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jun 2014 07:39:28 GMT 2014-06-17T07:39:28Z Extract first word without comma https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691060#M250114 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need your help to know how I can extract the first word from a field, without take the comma.</P><P>I already use this :</P><PRE __default_attr="html" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14029900492187360" jivemacro_uid="_14029900492187360" modifiedtitle="true"> <P>subfield( [Family Description],' ',1) as [Family]</P> </PRE><P></P><P>But, depending on the case, it takes me a comma that I don't want..</P><P></P><P>Thank you for your help !<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jun 2014 07:29:29 GMT https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691060#M250114 2014-06-17T07:29:29Z Re: Extract first word without comma https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691061#M250115 <HTML><HEAD></HEAD><BODY><P>Try:</P><P><STRONG>PurgeChar</STRONG>(subfield( [Family Description],' ',1),<STRONG> ','</STRONG>)&nbsp; as [Family]</P></BODY></HTML> Tue, 17 Jun 2014 07:32:22 GMT https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691061#M250115 tresB 2014-06-17T07:32:22Z Re: Extract first word without comma https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691062#M250116 <HTML><HEAD></HEAD><BODY><P>Thanks lot tresesco, it works ! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jun 2014 07:39:28 GMT https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691062#M250116 2014-06-17T07:39:28Z Re: Extract first word without comma https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691063#M250117 <HTML><HEAD></HEAD><BODY><P>Muller scored a hat-trick, couple of hours later, I could help MULLER !&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Tue, 17 Jun 2014 07:44:44 GMT https://community.qlik.com/t5/QlikView/Extract-first-word-without-comma/m-p/691063#M250117 tresB 2014-06-17T07:44:44Z