Forum Discussion

eduardoeduardo's avatar
eduardoeduardo
Qrew Trainee
10 years ago

Need an OFX parser to import Bank Transactions to quick base

Looking for an OFX parser.   Want to import banking transactions, wanting to use dans technique to parse OFX file transform to json, transform to CSV and import.   Fo...
APIs and custom code
Data import and export
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
10 years ago
That code would fail if attempting to parse the MEMO data which has spaces in its value. The statement I used is simple

doc.match(/<TRNTYPE>(.*?)</)[1].trim();

Match and capture all text after "<TRNTYPE>" up to the next "<" delimiter (ie non-greedy match)- trim the result of extra whitespace.