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

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

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

All 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