creating QIF file under Dos using AWK

[Derek Atkins]

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.

-derek

> 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
       warlord at MIT.EDU                        PGP key available