Forum Discussion

sergeys's avatar
sergeys
Contributor
10 years ago

Why Dots are replaced by '#' when getting column names from csv file

Does anybody know, why "." is replaced by "#" when getting column names from CSV file?   I have WPF grid which is empty by default and it is possible to add columns with names as specified in Schem...
CSV
DDT
  • joseph_michaud's avatar
    joseph_michaud
    10 years ago

    Period is not a valid character in a column name.  It seems that a valid name should start with [a-zA-Z_@#] and remaining letters could also include [0-9]  (but I notice in practice that a digit can start a column name).  I would have thought that names enclosed in double quotes could contain any character but apparently not...

     

    Can't find any authoritative document to say what the driver is expecting for a field name.

joseph_michaud's avatar
joseph_michaud
Moderator
10 years ago

Period is not a valid character in a column name.  It seems that a valid name should start with [a-zA-Z_@#] and remaining letters could also include [0-9]  (but I notice in practice that a digit can start a column name).  I would have thought that names enclosed in double quotes could contain any character but apparently not...

 

Can't find any authoritative document to say what the driver is expecting for a field name.

  • sergeys's avatar
    sergeys
    Contributor
    10 years ago

    Thanks for response, it is really strange that we couldn't find any answer regarding it, but it is not really blocker anyway.

    • joseph_michaud's avatar
      joseph_michaud
      Moderator
      10 years ago

      I should point out that this is not a TestComplete restriction but rather of the various database drivers.  Web search on this shows it to be a more generic issue.  I couldn't find anything definitive relating to the Jet driver at the Microsoft site about this.