Forum Discussion

pvidal's avatar
pvidal
Contributor
15 years ago

DDT.CSVDriver is trimming leading and trailing spaces.

Hello,



When the DDT.CSVDriver reads a CVS file it trims leading and trailing spaces ("  aaa " becomes "aaa"). By RFC 4180, section 2, item 4: "Spaces are considered part of a field and should not be ignored".



Is there any way to configure the DDT.CSVDriver so that it does not trims leading and trailing spaces?  I really hate to create my own parser :-(.



Thank you,

Patricio.

2 Replies

  • Hi Patricio,


    TestComplete works with CSV files via Microsoft Jet Driver that trims leading and trailing spaces. We cannot change or get round this behavior on our side.


  • Hi Allen,



    Ok. It is weird that the Microsoft Jet Driver can not be configured. Excel reads csv files whitout trimming leading and trailing spaces. I can't use Excel from my test because it will not be installed on the machines running the tests.



    Regards,

    Patricio.