PSIcapture Database Lookup: CSV is not formatting or is truncating

Problem:

When configuring a lookup to point to a CSV file, you may encounter formatting issues. 

Solution:

By default, if the columns are not specified what type they are, the Microsoft Text File Driver will try to automatically interpret it.   It can guess incorrectly, resulting in improperly formatting results from the lookup.  You will need to edit the Schema.ini file appropriately.  In the sample CSV attached, you can see where the field columns have been set as 'text'.   Complete description of modifying this is available at Microsoft's website:

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