Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Will the char "/" loaded from the xlsx - how looks the field-values (without transforming) after loading.
- Marcus