topic Re: Text Object - trim after comma in QlikView https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680572#M246771 <HTML><HEAD></HEAD><BODY><P>Perfect. Thanks!</P></BODY></HTML> Tue, 15 Jul 2014 19:07:35 GMT brucejensen 2014-07-15T19:07:35Z Text Object - trim after comma https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680570#M246769 <HTML><HEAD></HEAD><BODY><P>In a text object, is there a way to trim anything that comes after a comma? It's not a set number of spaces but varies based on the selection. My text object has current selections (=GetFieldSelections([Field Name]) but when I have two selections, it shows both separated by a comma. I just want to show the first one. Thanks in advance for your help.</P></BODY></HTML> Tue, 15 Jul 2014 18:56:57 GMT https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680570#M246769 brucejensen 2014-07-15T18:56:57Z Re: Text Object - trim after comma https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680571#M246770 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>=subfield(GetFieldSelections([FieldName]), ',', 1)</P><P></P><P>Hope this helps!</P></BODY></HTML> Tue, 15 Jul 2014 19:00:26 GMT https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680571#M246770 jerem1234 2014-07-15T19:00:26Z Re: Text Object - trim after comma https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680572#M246771 <HTML><HEAD></HEAD><BODY><P>Perfect. Thanks!</P></BODY></HTML> Tue, 15 Jul 2014 19:07:35 GMT https://community.qlik.com/t5/QlikView/Text-Object-trim-after-comma/m-p/680572#M246771 brucejensen 2014-07-15T19:07:35Z