Discussion Board for collaboration on QlikView Scripting.
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....
For example, colA contains data as : "ABCDEF/11"
Will the char "/" loaded from the xlsx - how looks the field-values (without transforming) after loading.