CSV database lookup is not formatted properly or results are truncated

Summary

If you are configuring a lookup to point to a CSV file, you may encounter formatting issues. By default, if the columns are not specified what type they are, the Microsoft Text File Driver will try to automatically interpret it. This process can guess incorrectly, resulting in improperly formatting results from the lookup. You will need to edit the Schema.ini file appropriately.

A Complete description of modifying this is available at Microsoft's website:

http://msdn.microsoft.com/en-us/library/ms709353%28v=vs.85%29.aspx


If you are still experiencing difficulties, please contact our Support team by: