Importing CSV files

[Richard Thomas]

Hi,

Thanks for that, the N for the number record is working for me.

Would you be able to help me with the C record please?

What should the entire C line look like?

Thanks,

Richard.

On 17 July 2012 15:00, Derek Atkins <warlord at mit.edu> wrote:

> Hi,
>
> Richard Thomas <richdthomas at gmail.com> writes:
>
> > Hi Derek,
> >
> > Thanks for getting back to me.
> >
> > Here's a sample of the QIF file that my bank provides, I've deleted all
> but
> > the top transaction:
> >
> > !Type:Bank
> > D13/07/2012
> > PSTARBUCKS CARD REL CD ****
> > T-10.00
> > ^
> >
> > So, would I need to change the "T-10.00" to "C-10.00" and then add an
> "N" line
> > for my "num" field?
>
> No, and Yes.  Yes, add an N line to specify the Num field.  But you also
> need to add a C line to specify the Cleared Flag.  Do NOT change the T
> (total) line.
>
> > Thanks,
> >
> > Richard.
>
> -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
>