Smart Column Splitting in Numbers

Discussion in 'Mac Apps and Mac App Store' started by fivetoadsloth, Sep 24, 2010.

  1. fivetoadsloth macrumors 65816

    fivetoadsloth

    Joined:
    Aug 15, 2006
    #1
    I have a .txt file that is quite long and I need to get some data off of it. The file is made up of a few thousand lines each with a format similar to:

    1 2.4 5.4 abcde abc.def

    The 1, the 2.4, the 5.4, etc each signify a different value and I need to somehow get them into separate columns into excel. The number of digits in everything except the first value (which is always one digit) varies, and all the values are separated by spaces.

    What is going to be the easiest way for me to get these values into numbers in separate columns? Realistically, doing this manually isn't an option.

    Thanks a lot, sorry if my question doesn't make that much sense.
     
  2. talmy macrumors 601

    talmy

    Joined:
    Oct 26, 2009
    Location:
    Oregon
    #2
    from the command line:

    Code:
    tr ' ' ',' <yourfile.txt >yourfile.csv
    then open yourfile.csv in Numbers.
     
  3. fivetoadsloth thread starter macrumors 65816

    fivetoadsloth

    Joined:
    Aug 15, 2006
    #3
    Thanks a lot, worked really well.
     

Share This Page