[#1451] - Delimited files does not count repeating delimiters

Posted by anonim on September 14, 2007 - 5:49pm
Category:
Bug report
 Priority:
Immediate
 Status:
New
Project:
Jaspersoft® ETL
 Severity:
Block
 Resolution:
Unable to Reproduce
Component: Reproducibility:
Always
 Assigned to:
drupal7_anonymous
Subscribe

I have exported some transactions from our accounting systems into tab separated file. As far as I can see if I have an empty column in the file, JasperETL does not count this column. For Example the line
2000<tab><tab>3000
is transformed into 2 columns, not into 3. This is a big problem for us.

anonim's picture
anonim
1
Joined: Sep 14 2007 - 7:05am
Last seen: 15 years 6 months ago

1 Comment:

#1Posted by robinzone on May 6, 2009 - 8:27am

Hi,

I've tried to reproduce your situation. I created file with the follow content:

1<tab>field1<tab>value1<\n>
2<tab>field2<tab>value2<\n>
3<tab><tab>value3

Added tFileInputDelimited and tLogRow and connected them. Also I've added a generic schema with 3 fields - id, field, value - and set it to tFileInputDelimited. In tFileInputDelimited I've changed "Field Separator" to "\t".

When I run it, this what i've got.

Starting job job_import_tab at 13:25 06/05/2009.
1|field1|value1
2|field2|value2
3||value3
Job job_import_tab ended at 13:25 06/05/2009. [exit code=0]

So, seems like it's work for me. I used JasperETL (2.3.2.r12707)

Regards

Feedback