topic Formula to extract last word in bracket() otherwise in QlikView https://community.qlik.com/t5/QlikView/Formula-to-extract-last-word-in-bracket-otherwise/m-p/184117#M49137 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The following should work (in the script)</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Len(TextBetween(GroupName, '(', ')')), TextBetween(GroupName, '(', ')'), GroupName) AS NewField</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Mon, 28 Mar 2011 11:04:12 GMT Miguel_Angel_Baeyens 2011-03-28T11:04:12Z Formula to extract last word in bracket() otherwise https://community.qlik.com/t5/QlikView/Formula-to-extract-last-word-in-bracket-otherwise/m-p/184116#M49136 <HTML><HEAD></HEAD><BODY><P>Hi, does anyone know what expression i would use to achieve the following outcomes:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3947_sourceID:3947" /></P><P>Basically i want the expression to look at 'GroupName' and check if there is a name enclosed in brackets (), if so then return the name inside the brackets. Otherwise just give the name.</P><P>Regards???</P></BODY></HTML> Mon, 28 Mar 2011 10:08:45 GMT https://community.qlik.com/t5/QlikView/Formula-to-extract-last-word-in-bracket-otherwise/m-p/184116#M49136 2011-03-28T10:08:45Z Formula to extract last word in bracket() otherwise https://community.qlik.com/t5/QlikView/Formula-to-extract-last-word-in-bracket-otherwise/m-p/184117#M49137 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The following should work (in the script)</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Len(TextBetween(GroupName, '(', ')')), TextBetween(GroupName, '(', ')'), GroupName) AS NewField</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Mon, 28 Mar 2011 11:04:12 GMT https://community.qlik.com/t5/QlikView/Formula-to-extract-last-word-in-bracket-otherwise/m-p/184117#M49137 Miguel_Angel_Baeyens 2011-03-28T11:04:12Z