afb120 file format

One Star

afb120 file format

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.
One Star

Re: afb120 file format

Hi,

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


Best regards

Jeremie
One Star

Re: afb120 file format

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
Highlighted
One Star

Re: afb120 file format

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download