Forum Discussion
Martin_Blass
8 years agoNew Contributor
Good morning everybody,
I suffer from a simillar problem. I have columns of HEX values which are separated by coma and a space (e.g. "53, 0F"). The columns themselves are separated by semicolon (CSV file).
It all works fine until I reach cells with values such as "00, 01" in which case TestComplete interprets this as "0". I have tried using different text "separators" and trying to "force" text format by using apostrophe at the begining of the cell...
At best I can get the values out in this format: '00, 01' (including the apostrophes)
- tristaanogre8 years agoEsteemed Contributor
AS noted earlier on in the thread, the best solution is to use some sort of schema.ini for a CSV file to indicate the column format so that the database driver does not auto-convert it.