Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
Labels (2)
3 Replies
Anonymous
Not applicable
Author

Hi,

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


Best regards

Jeremie
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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