topic &quot;FindOneOf&quot; : difference with Excel Files .XLS and .XLSX ??? in QlikView https://community.qlik.com/t5/QlikView/quot-FindOneOf-quot-difference-with-Excel-Files-XLS-and-XLSX/m-p/509335#M692198 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an funny problem....</P><P></P><TABLE><TBODY><TR><TD> </TD><TD><P>if( FindOneOf( colA ,'/')&gt;0, SubField( colA ,'/',2), 'Others') as Type_Val</P><P></P><P>With a XLS file, no problem.</P><P>With the same file saved as XLSX format, the function "FindOneOf" not works, the caracter " / " has never found.... </P></TD></TR><TR><TD></TD><TD>However, the cell format is the same (no specific) in this two versions, </TD></TR><TR><TD></TD><TD><P></P><P>For example, colA contains data as :&nbsp;&nbsp; "ABCDEF/11"&nbsp;&nbsp;&nbsp;&nbsp; </P></TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE><P>an idea?</P><P></P><P>many thanks</P></BODY></HTML> Wed, 11 Sep 2013 11:04:03 GMT 2013-09-11T11:04:03Z "FindOneOf" : difference with Excel Files .XLS and .XLSX ??? https://community.qlik.com/t5/QlikView/quot-FindOneOf-quot-difference-with-Excel-Files-XLS-and-XLSX/m-p/509335#M692198 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an funny problem....</P><P></P><TABLE><TBODY><TR><TD> </TD><TD><P>if( FindOneOf( colA ,'/')&gt;0, SubField( colA ,'/',2), 'Others') as Type_Val</P><P></P><P>With a XLS file, no problem.</P><P>With the same file saved as XLSX format, the function "FindOneOf" not works, the caracter " / " has never found.... </P></TD></TR><TR><TD></TD><TD>However, the cell format is the same (no specific) in this two versions, </TD></TR><TR><TD></TD><TD><P></P><P>For example, colA contains data as :&nbsp;&nbsp; "ABCDEF/11"&nbsp;&nbsp;&nbsp;&nbsp; </P></TD></TR><TR><TD></TD><TD></TD></TR></TBODY></TABLE><P>an idea?</P><P></P><P>many thanks</P></BODY></HTML> Wed, 11 Sep 2013 11:04:03 GMT https://community.qlik.com/t5/QlikView/quot-FindOneOf-quot-difference-with-Excel-Files-XLS-and-XLSX/m-p/509335#M692198 2013-09-11T11:04:03Z Re: "FindOneOf" : difference with Excel Files .XLS and .XLSX ??? https://community.qlik.com/t5/QlikView/quot-FindOneOf-quot-difference-with-Excel-Files-XLS-and-XLSX/m-p/509336#M692199 <HTML><HEAD></HEAD><BODY><P>Will the char "/" loaded from the xlsx - how looks the field-values (without transforming) after loading.</P><P></P><P>- Marcus</P></BODY></HTML> Wed, 11 Sep 2013 11:21:16 GMT https://community.qlik.com/t5/QlikView/quot-FindOneOf-quot-difference-with-Excel-Files-XLS-and-XLSX/m-p/509336#M692199 marcus_sommer 2013-09-11T11:21:16Z