« Previous Next »

• 08-28-2009, 6:03 PM

  Victoria Popic Joined on 08-28-2009, 5:47 PM Posts 1

  CSV: Indicate Column Data Type Reply Contact Hello,  Is there a way to tell the LogParser what the column types of a given input CSV file are?  The problem is the following: when values are missing in more than 10 rows (dtLines default), the column is assumed to be of type STRING (although it is an INTEGER column), which causes integer comparisons and other operations (e.g. averages) to fail with type mismatch errors. I would prefer not to increase the -dtLines parameter. Is there a way to fix this?  Thank you for your help.