Forum Discussion

giovanni_favara's avatar
giovanni_favara
Contributor
7 years ago

import values with dots

Hello,

I want to import a csv file. In this file there is a colum with dates. The date format have dots to separe the information in the date (e.g. "05.05.2018"). This date format will be used in Germany.

 

During the import from csv file into a "Data-Driven Loop" I can see that the double quoted string "05.05.2018" will be transformed into a number 5052018.

 

Why TestComplet do this? For me is that a bug.

 

I tried to escape the dots with backsledge, but doesn't work well. Have somebody a workaround?

 

Best regards

 

CSV import
data-driven loop
  • AlexKaras's avatar
    AlexKaras
    7 years ago

    Hi Giovanni,

     

    Can you post here the problematic code and its output?

    I tried a simplest keyword test with your sample cvs file and got expected result in the log:

     

     

  • giovanni_favara's avatar
    giovanni_favara
    7 years ago

    Hello Alex,

    thx for your support. I have found a solution.

     

    I had made a mistake with the schema ini file. I forget to unceck the option "Use these custom parameters instead of the system settings:".

     

    With schema file now the import works well.

     

    I think that with you the import behaves differently, because my Windows configuration is different regarding country settings.

     

    Regards

    Giovanni