I don't own BBEdit (yet) but think it could solve a problem I have. PROBLEM:
My credit card company has recently switched the semantics of the QFX file it produces to describe transactions. (For those not familiar with QFX, it's SGML based descriptions of financial activity). Anyway, when it worked properly charges to the card were described thusly: TRNTYPE=DEBIT TRNAMT=<negative currency> and payments to the credit card company and merchant refunds were coded as: TRNTYPE=CREDIT TRNAMT=<positive currency> A recent change to the generated GFX file semantics prevents me from importing it into my personal finance software: all charges come through as payments and all payments come through as charges. The root cause is this new encoding in the QFX for charges: TRNTYPE=CREDIT TRNAMT=<positive currency> and for payments: TRNTYPE=DEBIT TRNAMT=<negative currency> As you can see, it's just the opposite from what it used to be!!! The credit card company insists this is correct (confirming that both Quicken and MS Money say they're OK with the change). But it broke Banktivity, and from spending over 6 hours on the phone with both companies, I expect my only chance to solve this problem is with text manipulation. Thus my interest in BBEdit. There seems to be some sort of automation capability in BBEdit where I could run a series of transforms on the QFX file as delivered by the credit card company before importing into Banktivity. Is this true, and can someone describe the BBEdit commands to transform the QFX file properly? Here's my take on the automation flow: - open a specified file - change all occurrences of CREDIT to XXX - Change all occurrences of DEBIT to CREDIT - Change all occurrences of XXX to DEBIT - <I'm not sure how to transform the TRNAMT values in sign only (basically, multiplying by -1)> - Close transformed file Any help provided would be greatly appreciated. BBEdit is clearly overkill for my problem, but for 50-odd bucks it seems worthwhile to me to kill this aggravation. My environment: MacOS High Sierra (10.13.6) running on a MacBook Pro early 2011 (to be upgraded this summer to Catalina on a MacBook Pro 16"). Thanks again. Mark -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/bc0dc03d-3b93-4bb4-bf9f-da0a5f436237%40googlegroups.com.
