Talend community forum / [resolved] row length and number of words in a row

kavita12345 · 2012-02-06 13:45:27

Tags: [neglect, positional file, reject]

Hi all,

I'm using tFileInputPositional to process a fixed length file and connecting it to tMap for transformation but I want to neglect/reject the rows which are having less than 10 fields in them or rows having length less than 100 before sending them to tMap. Can anyone please tell me how to do that.

Thanks in advance.

JohnGarrettMartin · 2012-02-06 22:31:49

use the tMap output filter to enter the conditions on which you want to reject the row.

kavita12345 · 2012-02-07 06:18:42

Actually i want to reject the rows having less than 10 words. Is there any method to split the row and then count the number of words returned after the split. (as we do in java line.split("\\s+").length )

kavita12345 · 2012-02-09 06:07:50

@JohnGarrettMartin thanks for the reply.
Talend stores row as a structure not string so it cannot be split further and also i dont think there is any function to split.

I'm using some other conditions on fields instead of having conditions on entire row and its working fine .

kavita12345 · 2012-02-09 10:49:22

tjavarow has line field in its schema and length , split any java String function can be used on it.

Announcement

Unanswered posts

#1 2012-02-06 13:45:27

[resolved] row length and number of words in a row

#2 2012-02-06 22:31:49

Re: [resolved] row length and number of words in a row

#3 2012-02-07 06:18:42

Re: [resolved] row length and number of words in a row

#4 2012-02-09 06:07:50

Re: [resolved] row length and number of words in a row

#5 2012-02-09 10:49:22

Re: [resolved] row length and number of words in a row

Board footer