Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I read an Excel in this format. The first field have text strings on some rows and all numbers in others.
12515305616Q85360 1 10.04.08 2015-02-11 10:53:1912514257614185300 1 08.04.08 2015-02-11 09:27:09
The fields that contain a letter is read but not the fields that are all numbers.
If I use Num() the number fields show up but not the letter fields. Text() makes no difference.
Tried to add a '¤' in front of the string and read the source resident. Same result.
Probably some easy fix, right?
The text() function should work. But try using the evaluate() function. If that doesn't give you the results you want could you post an excel file with some example data?