1 Reply Latest reply: Sep 11, 2013 7:21 AM by Marcus Sommer RSS

    "FindOneOf" :  difference with Excel Files   .XLS  and  .XLSX ???

      Hi,

       

      I have an funny problem....

       

      if( FindOneOf( colA ,'/')>0, SubField( colA ,'/',2), 'Others') as Type_Val

       

      With a XLS file, no problem.

      With the same file saved as XLSX format, the function "FindOneOf" not works, the caracter " / " has never found....

      However, the cell format is the same (no specific) in this two versions,

       

      For example, colA contains data as :   "ABCDEF/11"    

      an idea?

       

      many thanks