QFX import problem and work around, possible bug or new feature?

[Ed Reeder]

Here is an awk script to solve one QFX import problem.  Hopefully this
is to the GnuCash mailing list, so that people can see it.  Evidently it
was not visible where I posted it.  (Thanks Derek for the heads up)
 
Hope this of use to someone.  I wrote a gawk script (awkqfx) that strips
out the <CATEGORY> and <MEMO>null lines.  This is for DOS, Windows 10.
I changed the PATH variable to find both gawk and my CMD file.

------------------------------------------------------------------------
--------------------------------------
@ECHO OFF REM DOS CMD file that removes <CATEGORY> and <MEMO>null lines
from QFX files REM REM It's been twenty years since I wrote an awk
program, wish I remembered how to put in a null REM action so that I
didn't have the {x += 1} statements :-) REM REM Example use: awkqfx <
ORIGFILE.QFX > EDITEDFILE.QFX

gawk "{if ($1 ~ /.CATEGORY./) {x += 1} else if ($1 ~ /.MEMO.null/) {x +=
1} else print $0}"
 
 
On Mon, Sep 12, 2016, at 08:41 AM, Derek Atkins [via GnuCash] wrote:
> Hi,
>
>  gbguy <[hidden email]> writes:
>
>  > Corrected awk script (now tested with Chase's new QFX download)
>
>  Your script did not make it to the gnucash-user">gnucash-user list.
>  This is because you appear to be using Nabble, but Nabble doesn't
>  properly format and send your attachments to everyone.
>
>  Try actually EMAILING the script, if you want people to be able to
>  see it.
>
>  Thanks,
>
>  > View this message in context:
>  > http://gnucash.1415818.n4.nabble.com/QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686502">QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686502.html[1]
>  > Sent from the GnuCash - User mailing list archive at Nabble.com.
>
>  > Please remember to CC this list on all your replies. You can do
>  > this by using Reply-To-List or Reply-All.
>
>  -derek
>
>  --
>         Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>         Member, MIT Student Information Processing Board  (SIPB) URL:
>         http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH [hidden
>         email]                        PGP key available
>  _______________________________________________
>  gnucash-user">gnucash-user mailing list [hidden email]
>  https://lists.gnucash.org/mailman/listinfo/gnucash-user">gnucash-user
>  -----
>  Please remember to CC this list on all your replies. You can do this
>  by using Reply-To-List or Reply-All.
>
>
> If you reply to this email, your message will be added to the
> discussion below:
> http://gnucash.1415818.n4.nabble.com/QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686536">QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686536.html[2]
> To unsubscribe from QFX import problem and work around, possible bug
> or new feature?, click here[3]. NAML[4]

Links:

  1. http://gnucash.1415818.n4.nabble.com/QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686502.html
  2. http://gnucash.1415818.n4.nabble.com/QFX-import-problem-and-work-around-possible-bug-or-new-feature-tp4686405p4686536.html
  3. http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4686405&code=ZXJlZWRlckBtYWlsdXAubmV0fDQ2ODY0MDV8LTIwNDY2NjQzODU=
  4. http://gnucash.1415818.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml