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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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