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...
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Question about Numbers (how to create a table from an ascii file?)
- Thread starter macbook123
- Start date
- Sort by reaction score
GGJstudios
macrumors Westmere
You could open the file with Pages and replace all | characters with tabs. Then you could easily import it into Numbers.