#70 Parsing error using TAB as delimiter

open
nobody
None
5
2011-05-26
2011-05-26
Wayne Gregori
No

I\'m using opencsv-2.3 in a Coldfusion environment and we are having a problem with various csv files where Opencsv misinterprets a a TAB and imports thousands of characters into a field ignoring the end of line marks too. The parameters that we are feeding Opencsv are
<cfscript>
fileReader = createobject(\"java\",\"java.io.FileReader\");
fileReader.init(TheFilename);
csvReader = createObject(\"java\",\"au.com.bytecode.opencsv.CSVReader\");
csvReader.init(fileReader, \"#chr(9)#\");
</cfscript>

I\'ve included the text file as an example.

Thanks,
Wayne

Discussion

  • Wayne Gregori
    Wayne Gregori
    2011-05-26

    CSV file that does not import correctly

     
    Attachments