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

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



      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