Question about Numbers (how to create a table from an ascii file?)

Discussion in 'Mac Apps and Mac App Store' started by macbook123, Oct 13, 2009.

  1. macbook123 macrumors 68000

    Joined:
    Feb 11, 2006
    #1
    Hi All, i'm wondering if you could help me with this. I have a list in ascii/text format, where columns are separated by "|"'s. I'd like to read this into Numbers but by default it doesn't know what to do with those "|"'s of course. I've heard (though am unable to verify) that Excel has this ability to recognize separator symbols and put it in separate columns. Is there a way to do this with Numbers or any other Apple program? Thanks in advance for any suggestions...
     
  2. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #2
    You could open the file with Pages and replace all | characters with tabs. Then you could easily import it into Numbers.
     

Share This Page