cancel
Showing results for 
Search instead for 
Did you mean: 

Data loop file with leading zeros are dropping

Highlighted
New Contributor

Data loop file with leading zeros are dropping

I have a .csv file for a data loop with some leading zeros.  The numbers are formatted as text but still Test Complete is dropping the leading zero.  I tried formatting it in Excel and in the file directly but each time TestComplete drops the leading zero.  How can I fix this?

1 REPLY 1
Highlighted
Community Hero

In your CSV file, just to be sure, do you have your numbers wrapped in quotes?  Like

 

Column1,Column2,Column3
"001","My stuff","this stuff"
"002","Other Stuff", "Their stuff"

Explicitly wrapping in quotes might help.

 

 

If that doesn't fix it, could you post the code you're executing? There may be an implicit conversion going on that is converting what you're reading in as a number instead of as a string.

 

 

 


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
New Here?
Join us and watch the welcome video:
Announcements
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Get properties of a web page element

See replies!

Compare images using the Region Checkpoint

See replies!

Compare HTML table with Excel file and correct data in Excel file

Participate!

How to execute remote test and obtain results via Test Runner REST API

Participate!
Top Kudoed Authors