Swaping Payee and Memo field in QIF File

Discussion in 'Quicken' started by Charles, Jan 6, 2004.

  1. Charles

    Charles Guest

    Hello,

    The bank that I have my checking account at lets me download
    transactions in QIF File format. However, the text in the Memo field
    would be better in the Payee field.

    Is there something in Quicken 04 or another tool else where that would
    let me swap the text in the memo field to the payee field?

    Thanks,
    Charles
     
    Charles, Jan 6, 2004
    #1
    1. Advertisements

  2. QIF files are plain text. If you open the file up with your favorite text
    editor you can edit the change yourself. If you search this quicken
    newsgroup (using groups.google.com) there are posts detailing the QIF
    format.

    Jeff

    "Charles" <> wrote in message
    news:...
    > Hello,
    >
    > The bank that I have my checking account at lets me download
    > transactions in QIF File format. However, the text in the Memo field
    > would be better in the Payee field.
    >
    > Is there something in Quicken 04 or another tool else where that would
    > let me swap the text in the memo field to the payee field?
    >
    > Thanks,
    > Charles
     
    Jeffrey Harris, Jan 7, 2004
    #2
    1. Advertisements

  3. Charles

    Charles Guest

    Thank you for your reply and time!

    However, it did not help much. I know that it is a text file and that
    I can edit the file myself. Do you know how many transactions I could
    have in a week? Why would I want to spend the time to edit the file
    myself? It's a checking account which means I use checks, debt cards,
    and EFTs on that account. I do not use cash, much anymore.

    Again, the question. Is there a tool or anything out there that I
    could use to swap two fields (or more) in a QIF File?

    Thanks again,
    Charles

    "Jeffrey Harris" <(dot)com> wrote in message news:<>...
    > QIF files are plain text. If you open the file up with your favorite text
    > editor you can edit the change yourself. If you search this quicken
    > newsgroup (using groups.google.com) there are posts detailing the QIF
    > format.
    >
    > Jeff
    >
    > "Charles" <> wrote in message
    > news:...
    > > Hello,
    > >
    > > The bank that I have my checking account at lets me download
    > > transactions in QIF File format. However, the text in the Memo field
    > > would be better in the Payee field.
    > >
    > > Is there something in Quicken 04 or another tool else where that would
    > > let me swap the text in the memo field to the payee field?
    > >
    > > Thanks,
    > > Charles
     
    Charles, Jan 7, 2004
    #3
  4. Charles

    John Cordes Guest

    Charles <> wrote:
    > Thank you for your reply and time!
    >
    > However, it did not help much. I know that it is a text file and that
    > I can edit the file myself. Do you know how many transactions I could
    > have in a week? Why would I want to spend the time to edit the file
    > myself? It's a checking account which means I use checks, debt cards,
    > and EFTs on that account. I do not use cash, much anymore.
    >
    > Again, the question. Is there a tool or anything out there that I
    > could use to swap two fields (or more) in a QIF File?
    >
    > Thanks again,
    > Charles
    >
    > "Jeffrey Harris" <(dot)com> wrote in message news:<>...
    >> QIF files are plain text. If you open the file up with your favorite text
    >> editor you can edit the change yourself. If you search this quicken
    >> newsgroup (using groups.google.com) there are posts detailing the QIF
    >> format.
    >>
    >> Jeff
    >>
    >> "Charles" <> wrote in message
    >> news:...
    >> > Hello,
    >> >
    >> > The bank that I have my checking account at lets me download
    >> > transactions in QIF File format. However, the text in the Memo field
    >> > would be better in the Payee field.
    >> >
    >> > Is there something in Quicken 04 or another tool else where that would
    >> > let me swap the text in the memo field to the payee field?
    >> >
    >> > Thanks,
    >> > Charles


    (reverting to bottom posting)

    I don't suppose you have a *nix box available to you? I think
    such a swap would be rather trivial with Unix / Linux tools (just
    interchanging the leading M and P at the beginning of a pair of lines
    in each transaction group in the QIF file). On a windows machine you
    could also use cygwin to do this. (I'm speculating to some extent,
    since I haven't actually implemented either of these suggestions
    myself.)

    Yet another solution would be to import the QIF into Excel using
    xl2qif as discussed here recently, swap columns, and export a new QIF.

    I'm guessing these suggestions aren't quite what you're looking for
    (not very automated, are they?), but it's all I can come up with off
    the top of my head.

    --
    John Cordes
     
    John Cordes, Jan 7, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    2
    Views:
    416
  2. Top Secret
    Replies:
    1
    Views:
    244
    John Pollard
    Aug 22, 2004
  3. Jeff

    Payee & Memo Reversed on Downloaded QIF

    Jeff, Nov 11, 2003, in forum: Microsoft Money
    Replies:
    3
    Views:
    614
    Cal Learner-- MVP
    Nov 11, 2003
  4. pete

    Payee Matching using Memo Field?

    pete, Jul 8, 2004, in forum: Microsoft Money
    Replies:
    1
    Views:
    1,125
    Cal Learner-- MVP
    Jul 8, 2004
  5. Delia

    Exported payee info appearing in memo field?

    Delia, Aug 2, 2004, in forum: Microsoft Money
    Replies:
    2
    Views:
    212
    Delia - Thanks!
    Aug 3, 2004
Loading...

Share This Page