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

    Feb 11, 2006
    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


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

Share This Page