Forum Discussion

Soulman's avatar
Soulman
New Contributor
10 years ago

Missing values while itterating through CSV/ Excel- file

Hi all, I have a problem while trying to itterate through CSV with "DDT.CSVDriver". CSV file: a;b;c;d;Enter;f input;casesInput.Keys;0;0;0;Input_HappyPath_02 input;searchBox.Keys;1115;1115;...
cunderw's avatar
cunderw
Community Hero

It has to do with mixing string and number values. There's been quite a few others with this same problem:

 

http://community.smartbear.com/t5/Desktop-Testing/TestComplete-returns-NULL-from-Excel-in-Property-Checkpoint-but/m-p/100950#M2946

 

http://community.smartbear.com/t5/Getting-Started-with/DDT-driver-have-a-very-strange-behaviour/m-p/51313/highlight/true#M4483

 

http://community.smartbear.com/t5/Getting-Started-with/Excel-column-returns-null-for-non-numeric-characters/m-p/54482/highlight/true#M7611

Soulman's avatar
Soulman
New Contributor
10 years ago

Thanks a lot for the links. It works now.

In csv- Files each value must be wrapped with "..." and in Excel each cell needs a ' as predecessor.

 

"Interesting" solution :smileywink: