creating QIF file under Dos using AWK

[Tommy Trussell]

On Thu, Mar 26, 2015 at 10:25 AM, Derek Atkins <warlord at mit.edu> wrote:

> Hi,
>
> piggyb <piggybattery at gmail.com> writes:
>
> > When I import using the number field, the QIF import assistant sees two
> > transactions as one.
> > I like to automatically import it in to two different expense
> >
> > !Type:Bank
> > !Account
> > NAccountName
> > ^
> > !Type:Bank
> > D31-12-2014
> > T-30,12
> > MHome reparatie
> > _*N*101_
> > PH.J. Simpson
> > _*A*45 Mercury Close, Southampton_
> > ^
> > !Type:Bank    <-----------------  Remove This Line
> > D31-12-2014
> > T-30,12
> > Ma night at moo's
> > _*N*102_
> > PH.J. Simpson
> > _*A*Alresford Road, Winchester_
> > ^
>
> Try removing the second !Type:Bank.  It's not needed and it tells the
> importer to reset itself, which isn't what you want.  At least I think
> what you want is that you have two distinct transactions made on
> December 31st at H.J. Simpson, both for $30.12, but one for home
> repairs and one for a night at moo's.
>
> If you remove that second !Type:Bank then you'll tell the importer that
> you have two transactions for your Bank account.
>
>
I have been following this thread to try to understand QIF import better
and one thing that confuses me about these QIF files is the underscores and
asterisks preceding the A and N fields. @piggybattery, I presume you are
using those extra characters to get the importer to do something additional?

I found a site with some example QIF lines in it and it looks a lot simpler:

http://linuxfinances.info/info/financeformats.html