You are not logged in.
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.
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 )
@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 .