Importing QIF files

[Mark Wigmore]

On 4 February 2015 at 14:29, Derek Atkins <warlord at mit.edu> wrote:

> I understand you're unwilling to do that, but honestly, it's not that
> hard to do something like:
>
> grep '^N$' file.qif
>

I get 2369 matches! The first in investments is this on line 21301:

!Type:Invst
D01/01/1970
T3612.25CX
N
POpening Balance
M
L[Start Balance]
^


> to look for lines that start with 'N' and have no other data (although
> this regex doesn't find lines with only whitespace).  Similarly, one
> could look for T lines that don't start with valid number formats:
>
> egrep '^T[^-0-9]' file.qif
>

101 matches, but they all have T followed by text, TBank, TInvst, etc. I'm
afraid I'm not familiar enough with these searches to look further.

Mark

Results:
    Line 486: TBank
    Line 491: TBank
    Line 496: TBank
    Line 501: TBank
    Line 506: TBank
    Line 511: TBank
    Line 516: TBank
    Line 521: TBank
    Line 526: TBank
    Line 531: TBank
    Line 536: TCCard
    Line 541: TCCard
    Line 546: TCCard
    Line 551: TInvst
    Line 556: TInvst
    Line 561: TInvst
    Line 566: TInvst
    Line 571: TInvst
    Line 576: TInvst
    Line 581: TInvst
    Line 586: TInvst
    Line 591: TInvst
    Line 596: TInvst
    Line 601: TInvst
    Line 607: TStock
    Line 612: TStock
    Line 617: TStock
    Line 622: TStock
    Line 627: TStock
    Line 632: TStock
    Line 637: TStock
    Line 642: TStock
    Line 647: TStock
    Line 652: TStock
    Line 657: TStock
    Line 662: TStock
    Line 667: TStock
    Line 672: TStock
    Line 677: TStock
    Line 682: TStock
    Line 687: TStock
    Line 692: TStock
    Line 697: TStock
    Line 702: TStock
    Line 707: TStock
    Line 712: TStock
    Line 717: TStock
    Line 722: TStock
    Line 727: TStock
    Line 732: TStock
    Line 737: TStock
    Line 742: TStock
    Line 747: TStock
    Line 752: TStock
    Line 757: TStock
    Line 762: TStock
    Line 767: TStock
    Line 772: TStock
    Line 777: TStock
    Line 782: TStock
    Line 787: TBOND
    Line 792: TStock
    Line 797: TStock
    Line 802: TStock
    Line 807: TStock
    Line 812: TStock
    Line 816: TStock
    Line 820: TStock
    Line 824: TStock
    Line 829: TStock
    Line 834: TStock
    Line 839: TStock
    Line 843: TStock
    Line 847: TStock
    Line 851: TStock
    Line 855: TStock
    Line 859: TStock
    Line 865: TBank
    Line 971: TBank
    Line 1007: TBank
    Line 9140: TBank
    Line 9168: TBank
    Line 9204: TBank
    Line 9267: TBank
    Line 9329: TBank
    Line 9571: TBank
    Line 9607: TBank
    Line 9879: TCCard
    Line 17376: TCCard
    Line 19690: TCCard
    Line 21254: TInvst
    Line 21299: TInvst
    Line 21532: TInvst
    Line 23190: TInvst
    Line 23253: TInvst
    Line 23608: TInvst
    Line 23652: TInvst
    Line 24587: TInvst
    Line 24670: TInvst
    Line 26037: TInvst
    Line 26402: TInvst