Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

"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

1 Reply

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

Will the char "/" loaded from the xlsx - how looks the field-values (without transforming) after loading.

- Marcus

Community Browser