How to read ofx file in Knime?

Hi.
I have a file .ofx extension.
How is the best way to read this file?
Knime have a node to read this extension?
There some kind of .txt mapping.
Thanks.

Hi @LucasNovaesDragojevic

I googled a little, but did not find a library reading them.
Is it possible to convert this into native text files? Or maybe excel? We have readers for both.

Best wishes, Iris

2 Likes

There are several Python packages to read OFX files (there might be some projects in R also). I was not able to instantly create a working example that you could reproduce.

Maybe you take a look at these and create a working sample in a Jupyter notebook then we could see if we could integrate it in a KNIME workflow.

4 Likes

Hi guys.
I don’t know programing in python.
So i does used the java snippet to extract the data with i need.
But i will try use the library in python in future when i need all information of ofx.
Thanks.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.