Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

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

- Marcus