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 :-(.
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. ⬇️⬇️⬇️
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.