Ask a Question

DDT CSV : missing commas from a decimal value.

Nabil
Senior Member

DDT CSV : missing commas from a decimal value.

Hi all,

 

For my DDT with testcomplete, I use CSV Format Parameters page to specify the format parameters of my CSV file that will be used as a data storage. I use custom parameters instead of system settings and i select only semicolon option for the delimiter.


When i loaded my CSV file to Testcomplete, as part of data driven test, the comma in decimal value disappears in the field. For example 1,8 becomes 18.

How do I retain the format of the field to not remove the commas from my CSV file? This CSV file is made thanks to Excel but unfortunately i can't use Excel with testcomplete because it is not installed.

 

Thanks for your help.

 

Best regards,

 

Nabil

1 REPLY 1
Marsha_R
Community Hero

https://support.smartbear.com/viewarticle/71361/

https://msdn.microsoft.com/en-us/library/ms709353.aspx

 

From these articles it looks like you should be able to use a schema.ini file for the layout of your .csv file.  Set the DecimalSymbol field to use comma as the separator.


Marsha_R
[Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
cancel
Showing results for 
Search instead for 
Did you mean: