topic Re: afb120 file format in Talend Studio

afb120 file format

Anonymous — Sat, 16 Nov 2024 14:04:38 GMT

Hello,
Does anyone has a clue on how to stard from an afb120 file format and output a csv file format with making the replacements needed.
Here you can find the afb120 format specs.
http://wiki.fenix.iscte.pt/index.php/AFB120_format
Thanks a lot any help I can get from you guys.

Re: afb120 file format

Anonymous — Wed, 11 Feb 2009 15:36:20 GMT

Hi,

Your files are positionnal files : position and length of data.

Best regards

Jeremie

Re: afb120 file format

Anonymous — Wed, 11 Feb 2009 16:33:37 GMT

Hello thanks for the quick reply ,
but besides the fact that they are positional , they also need transformation and that is where I'm stuck because
for exemple an amout can come as 1234.2N
and the N caracter is in fact a 5 and debit position. These are for bank statements,
any idea?
thanks

Re: afb120 file format

Anonymous — Wed, 11 Feb 2009 19:30:12 GMT

Hi,
starting two threads for the same question wouldn't make it faster to get an answer...
Please follow up 5454.
Bye
Volker