Results 1 to 3 of 3

Thread: Tab vs CSV

  1. #1
    Guest

    Post

    I want to populate a MSfelxgrid or other with the tab delimited data file. The CVS file generated by excel works fine but the tab file direct from Quicken only gives the first column, not all 10 columns. How can I open the tab file, or can I use the ASCII output the Quicken also supplies?


  2. #2
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844

    Post

    I suppose you could:

    1. Open the text file
    2. Read in line by line
    3. Use the split function to parse the data
    4. You can then regroup the data by using the Join function, with a vbTab separator, then use the .AddLine method of the grid control (I think it's addline, or something similar) to get it into your grid

    HTH

    Tom

  3. #3
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    You could, in VB,

    1) open an excel object and import the tab-delimited file, then,
    2) save the file as a CSV.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width