One Star

[resolved] Reading data from different positions in a flat file

Hi Guys,
It's me again.
Im trying to read data from different positions in a flat file. i.e. below is an example of the details file.
MWK00243505600002435231023JPY00102300FININTINTEREST
MWK00243506130002435111011ZAR00101100FININTINTEREST
MWK00243506130002435121012ZAR00101200FININTINTEREST
field 1 = position 0 to 3 (length 3)
field 2 = postion 4 - 15 (length 11) etc...
I am reading the file using tFileInputPositional but i'm not sure where to specify the starting point of the fields.
Thanking you in advance... Smiley Happy
Best Regards,
Panik
1 ACCEPTED SOLUTION

Accepted Solutions
Community Manager

Re: [resolved] Reading data from different positions in a flat file

Hi
Go to repository-->metadata and create a 'File positional' metadata follows the wizard.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
3 REPLIES
Community Manager

Re: [resolved] Reading data from different positions in a flat file

Hi
Go to repository-->metadata and create a 'File positional' metadata follows the wizard.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] Reading data from different positions in a flat file

Hi Shong,
Thanks for the suggested solution...
I tried it and it works perfectly, took some time though but it works..
Thanks yet again. Smiley Happy
Community Manager

Re: [resolved] Reading data from different positions in a flat file

Hi Panik
Thanks for your feedback and hope you return often to our forum!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business