Smart Column Splitting in Numbers

[fivetoadsloth]

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.

 

[talmy]

from the command line:

tr ' ' ',' <yourfile.txt >yourfile.csv

then open yourfile.csv in Numbers.

 

[fivetoadsloth]

from the command line:

tr ' ' ',' <yourfile.txt >yourfile.csv

then open yourfile.csv in Numbers.

Thanks a lot, worked really well.