DDT.CSVDriver is trimming leading and trailing spaces.

[pvidal]

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.

[AlexeyKolosov]

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.

[pvidal]

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.