Multiple rows should be converted as single record in Fixed width file

[nar]

Hi Team,

I have a Fixed Width file with data as shown below. First 10 rows in file should be considered as a single record. i have to change first 10 rows as a single record and then i have to read the data in length. the below data has 20 rows and this should be

converted to 2 records. Can anyone help me to achieve this.

01000000101004803279999999999999910001000000000000000000000000053117000000000001

02000000151389115000005314912060106010601840840  0121321180379 1321180379 00  

030000001015267061  0009922600099226    First Tech FCU      1010100024 

040000001Mobile Deposit     First Tech DDDAUSA84000000000000002780000000000 

0500000010408400000000000000    000000000000    000000000000       

060000001                        000000000140000000001  

0700000016011F0N13327CCCCA2PRCB2235  840       200601 0000000019094200 

0800000010000000000000000000000000183640000000000000231101321180379 VERSLI    

090000001530090=                                 

100000001                                AH   

01000000201004803279999999999999390000000000000000000000000000053117000000000001

02000000251389115000005314912060106010601840840  0121321180379 1321180379 00  

030000002015267061  0009922600099226    First Tech FCU      1010100024 

040000002Mobile Deposit     First Tech DDDAUSA84000000000000002780000000000 

0500000020408400000000000000    000000000000    000000000000       

060000002                        000000000140000000001  

0700000026011F0N13327CACCC2PRCB2235  840       200601 0000000019094200 

0800000020000000000000010000000000183640000000000000231101321180379 SLI     

090000002530090=                                 

100000002  

[Anonymous]

Hello,

Please have a look at this component: TalendHelpCenter: tFileInputPositional

which can read a positional file row by row to split them up into fields based on a given pattern and then sends the fields as defined in the schema to the next component.

Best regards

Sabrina

[nar]

Thanks for your response xdshi.

What you mentioned i know how to handle that. but in my case i have to concatinate 10 rows as a single record. please find below for more undrestandi.

Source File Data.

01

02

03

04

05

06

07

09

10

11

12

13

14

15

16

17

18

19

20

output should be like this.

01020304050607080910

11121314151617181920