CSV value dropping leading zeros

Hi GMcCartney0607,

I have seen this before or something similar.  Which version are you on?  I will have a look through my notes and reply. (Unless someone beats me to it) 😉

... Ok, my first hit is dealing with string conversion to integer at some point.  Could you show us a code snip?   I would expect that 0 in, "0John Doe" would not be removed.

P.S. I am thinking of the file read process here. Let me know?

... If you find my posts helpful drop me a like! 👍 Be sure to mark or post the solution to help others out and/or to credit the one who helped you. 😎

Ensure your parameters are set up correctly,

This will the correctly produce the following output,

...Try forcing everything to be a string.

This is a link explaining the process of reading data from a file.  This takes to the KWT section and has a few links to more details.

https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/retrieving-input.html#keyword-test-operations

Changing the Data Type of the Retrieved Value

TestComplete uses DDT Drivers to retrieve information from a storage. In most cases, the data is retrieved as a string. However, it can also be retrieved as an integer. Some methods perform different actions depending on whether you use integers or strings. For example, the ClickItem action performs a touch on an item using its index if you use an integer, but if you use a string, it searches for the corresponding item caption.

If you need to change the data type, use the VarToStr and VarToInt methods to make sure that you use a string or an integer value.

To use these methods in keyword tests, do the following:

1. Double-click the Value cell of the Keyword Test operation to open the Parameters Editor.
2. Click the ellipsis button.
3. Copy the contents of the Value field to the Clipboard.
4. Change the Mode option to Code Expression.
5. In the value column, type in either VarToStr() or VarToInt().
6. Paste the Clipboard contents inside the parentheses and click OK.

In scripts, use these methods to change the data type of the value you retrieve, for example, VarToStr(Driver.Value(5)).

GMcCartney0607​ You can try to avoid this by building a schema.ini file that sits in the same path as your csv file. Syntax of file is listed below:\

https://learn.microsoft.com/en-us/sql/odbc/microsoft/schema-ini-file-text-file-driver?view=sql-server-ver17

Specifics about the ini file are also found here as well:

https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/csv-storages.html