cancel
Showing results for 
Search instead for 
Did you mean: 

DDT.CSVDriver is trimming leading and trailing spaces.

Highlighted
Contributor

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 2
Highlighted

RE: DDT.CSVDriver is trimming leading and trailing spaces.

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.



Best regards,
Alexey

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
Contributor

RE: DDT.CSVDriver is trimming leading and trailing spaces.

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.

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors