What do the currency numbers look like? I mean is there a dollar sign? Is the minus sign at front or back?
What you want to do is simple, but not familiar SGML. So if you can dummy some trans, would make it clearer to me... Wags ;) WagsWorld Hebrews 4:15 Ph(primary) : 408-914-1341 Ph(secondary): 408-761-7391 On Feb 29, 2020, 09:58 -0800, Mark Love <[email protected]>, wrote: > 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. -- 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/a4e274b0-acd6-4b42-a421-3c415e9899b9%40Spark.
