1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

large tab-delimited text file

Discussion in 'Business Applications' started by gazebo7, Sep 23, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. gazebo7

    gazebo7 Thread Starter

    Joined:
    Dec 8, 1999
    Messages:
    7
    I have a very large tab-delimited text file that I want to bring into a program that will separate it into columns. Excel would usually be used for this but it can't handle files that span multiple sheets.
    Any ideas?

    Thanks,
    Jeff
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
  3. gazebo7

    gazebo7 Thread Starter

    Joined:
    Dec 8, 1999
    Messages:
    7
    That's not quite what I was looking for. The files has too many columns...maybe ~700 columns. By span multiple sheets, I meant worksheets in Excel speak.

    Jeff
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Jeff,

    Sorry, that was a bum steer. However, this worked for me as far as I could test -

    File -- Open (the file).

    In the Import Wizard, Data Type = Fixed Width. Next.

    Set a column break right after column 250. Next.

    Specify not to import the "2nd" column. Finish.

    Then in XL itself, use Data -- Text to Columns, but with Delimited.

    Repeat the whole thing twice for cols 251 - 500 & 501 - 7xx.

    HTH,
    Andy
     
  5. gazebo7

    gazebo7 Thread Starter

    Joined:
    Dec 8, 1999
    Messages:
    7
    That sounded like it would work but when I looked at the number of character columns, it goes over 4560 columns...ugh! The number of columns I was talking about was not character columns but over 700 tab-delimited columns.
     
  6. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    How many rows?

    What do you intend to do with the data after you get it into columns?
     
  7. gazebo7

    gazebo7 Thread Starter

    Joined:
    Dec 8, 1999
    Messages:
    7
    I'll need to do calculations, sorting and lookups.

    Jeff
     
  8. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    How many rows?
     
  9. gazebo7

    gazebo7 Thread Starter

    Joined:
    Dec 8, 1999
    Messages:
    7
    about 5000+ rows
     
  10. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Ouch!!

    You need to pull it into Access, def'ly.

    If you can't figure it out, can you send the file? (zip of course)

    [email protected]

    Oh...and I SWEAR confidentiality.
     
  11. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    I'm not sure where
    >> How many rows?
    is going, nor
    >> You need to pull it into Access, def'ly.
    , Access has less columns.

    To quote a true Excel genius, "the last 3 versions of Quattro Pro provide over 18,000 columns ... there are work-arounds, but they're as efficient as transporting thousands of tons of coal in sportscars".

    I'd love to be enlightened -- by anybody.

    Rgds,
    Andy
     
  12. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Well...so far....looks like 517 columns...

    Workin' on it!
     
  13. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - large delimited text
  1. scollins2019
    Replies:
    3
    Views:
    189
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/166873

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice