PDA

View Full Version : Enclosure problem in input text file (sample join)



kettle_anonymous
02-01-2006, 07:46 AM
Attachment: SATtxtExtCPT_prim.csv (http://forums.pentaho.org/archived_att/kettle/SATtxtExtCPT_prim.csv) Hi and thanks for your great job!
The file I join don't work well in the Text File Input.
The separator is , and the enclosure is " for the string values.
When I call previex rows, the rows TYPFAC is looking like: 2", in should be 2!
And then, the rest of the data are a little bit corrupted (see col :CODACNFAC): N",",",",",",
Is it a bug ?

kettle_anonymous
02-01-2006, 07:56 AM
Hi,


we just tested a text file and found there is a bug when the field has only one character between the enclosures like "2".
Cheers - Jens

MattCasters
02-01-2006, 11:49 AM
Hi,

I made a fix for this, please check tracker:
Bug - [# 1502] Enclosure problem in input text file ("a" parsed incorrectly)

Get the latest kettle.jar for a quick solution.

Kind regards,

Matt

kettle_anonymous
02-02-2006, 05:14 AM
It's working.
Thanks a lot!