Import Dates with data loop and CSV
Hey there,
I'm trying to figure out how to Import Dates from a CSV file into Testcomplete. I got a huge Problem when the Date has a starting "0" because I think Testcomplete is importing the Date as a Number.
I'm from Germany and I must use the following Date Format in the tested program. (DD.MM.YYYY)
For example:
CSV-File Imported
01.01.2020 1012020
12.01.2020 12012020
’01.01.2020’ ’01.01.2020’
I need:
01.01.2020 01.01.2020
or 01012020
I already tried the Schema.ini file but it's not working for me.
I hope you can help me.
Greetings
I made a small Workaround now and my Problem is done with it.
function Excel_Loop()
{
//Runs the "EXCEL" tested application.
TestedApps.EXCEL.Run(1, true);
Project.Variables.csv2207.Reset();
for(; !Project.Variables.csv2207.IsEOF();)
{
csvimporttest = Project.Variables.csv2207.Value("F5");
test123 = String(Project.Variables.csv2207.Value("F5"));
laengecsv = test123.length;
if (laengecsv < 8 {
csvimporttest = "kleiner 8" + " 0" + Project.Variables.csv2207.Value("F5") + " " + laengecsv
}
else {
csvimporttest = "größer 7" + " " + Project.Variables.csv2207.Value("F5") + " " + laengecsv
}
//csvimporttest = Project.Variables.csv2207.Value("F5") + " " + laengecsv
//csvimporttest = "Test123" + Project.Variables.csv2207.Value("F5")
Aliases.EXCEL.wndXLMAIN.XLDESK.Mappe1.Keys(csvimporttest);
Aliases.EXCEL.wndXLMAIN.XLDESK.EXCEL6.Keys("[Enter]");
Project.Variables.csv2207.Next();
}
}
I imported the data as before but then i watched at the length of the importet value and added a leading 0 when the length is 7.
Thanks for your Replys
