topic Re: Findoneof function and wildcards in QlikView https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382948#M142924 <HTML><HEAD></HEAD><BODY><P>this expression should do what you want:</P><P></P><P><STRONG>subfield(FieldName,'-',SubStringCount(</STRONG><STRONG>FieldName</STRONG><STRONG>,'-'))</STRONG></P></BODY></HTML> Fri, 31 Aug 2012 11:26:02 GMT 2012-08-31T11:26:02Z Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382945#M142921 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a field which has a naming convention of <EM>Name - Year - Type</EM></P><P></P><P>I want to just get the type from this so I use the expression:</P><P></P><P>=Right([FieldName],len([FieldName])-FindOneOf([FieldName], '-',2)-1)</P><P></P><P>The problem is I have found some names contain '-' which means it pulls part of the name as well.</P><P></P><P>How can I use the findoneof function with wilcards to find 'YYYY -'</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Jon</P></BODY></HTML> Fri, 31 Aug 2012 11:07:58 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382945#M142921 2012-08-31T11:07:58Z Re: Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382946#M142922 <HTML><HEAD></HEAD><BODY><P>does Type contain '-' to?</P></BODY></HTML> Fri, 31 Aug 2012 11:20:57 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382946#M142922 2012-08-31T11:20:57Z Re: Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382947#M142923 <HTML><HEAD></HEAD><BODY><P>No.</P></BODY></HTML> Fri, 31 Aug 2012 11:22:21 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382947#M142923 2012-08-31T11:22:21Z Re: Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382948#M142924 <HTML><HEAD></HEAD><BODY><P>this expression should do what you want:</P><P></P><P><STRONG>subfield(FieldName,'-',SubStringCount(</STRONG><STRONG>FieldName</STRONG><STRONG>,'-'))</STRONG></P></BODY></HTML> Fri, 31 Aug 2012 11:26:02 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382948#M142924 2012-08-31T11:26:02Z Re: Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382949#M142925 <HTML><HEAD></HEAD><BODY><P>sory i mean :</P><P></P><P>subfield(FieldName,'-',SubStringCount(FieldName,'-')<STRONG>+1</STRONG>)</P></BODY></HTML> Fri, 31 Aug 2012 11:27:13 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382949#M142925 2012-08-31T11:27:13Z Re: Findoneof function and wildcards https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382950#M142926 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you.</P></BODY></HTML> Fri, 31 Aug 2012 11:30:14 GMT https://community.qlik.com/t5/QlikView/Findoneof-function-and-wildcards/m-p/382950#M142926 2012-08-31T11:30:14Z