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

Category:
Bug report
Priority:
Immediate
Status:
New
Project: Severity:
Block
Resolution:
Unable to Reproduce
Component: Reproducibility:
Always
Assigned to:
0

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
1
Joined: Sep 14 2007 - 7:05am
Last seen: 14 years 2 months ago

1 Comment:

#1

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
randomness