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

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

Anonymous — Sat, 16 Nov 2024 12:59:41 GMT

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...
Best Regards,
Panik

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

Anonymous — Thu, 07 Apr 2011 01:48:35 GMT

Hi
Go to repository-->metadata and create a 'File positional' metadata follows the wizard.
Best regards
Shong

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

Anonymous — Tue, 26 Apr 2011 09:00:27 GMT

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

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

Anonymous — Tue, 26 Apr 2011 09:03:33 GMT

Hi Panik
Thanks for your feedback and hope you return often to our forum!
Best regards
Shong