Smart Column Splitting in Numbers

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

  1. fivetoadsloth macrumors 65816


    Aug 15, 2006
    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


    Oct 26, 2009
    from the command line:

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


    Aug 15, 2006
    Thanks a lot, worked really well.

Share This Page