https://community.qlik.com/t5/QlikView/How-to-trim-name-from-the-fields/m-p/1592554#M739162 <P>May be do this</P><LI-CODE lang="markup">Subfield([Branch Name], ' ', 1)</LI-CODE><P>or you can use Replace Function</P><LI-CODE lang="markup">Replace([Branch Name], ' Showroom', '')</LI-CODE> Mon, 17 Jun 2019 12:09:10 GMT sunny_talwar 2019-06-17T12:09:10Z https://community.qlik.com/t5/QlikView/How-to-trim-name-from-the-fields/m-p/1592512#M739161 <P>&nbsp;Hi,</P><P>How to trim the names from the filed names</P><P>i want to remove showroom from every fields name.</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-trim-name-from-the-fields/m-p/1592512#M739161 venkat1 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-to-trim-name-from-the-fields/m-p/1592554#M739162 <P>May be do this</P><LI-CODE lang="markup">Subfield([Branch Name], ' ', 1)</LI-CODE><P>or you can use Replace Function</P><LI-CODE lang="markup">Replace([Branch Name], ' Showroom', '')</LI-CODE> Mon, 17 Jun 2019 12:09:10 GMT https://community.qlik.com/t5/QlikView/How-to-trim-name-from-the-fields/m-p/1592554#M739162 sunny_talwar 2019-06-17T12:09:10Z