Importing pipe-delimited into iWork Numbers

Discussion in 'Mac Apps and Mac App Store' started by Davebkk, Jul 4, 2010.

  1. Davebkk macrumors newbie

    Sep 15, 2008
    I'm guessing the only way to import a pipe delimited file into Numbers is to first convert it to csv or tab delimited?

    Any hints / tips / scripts on doing this?
  2. ohanian macrumors newbie

    Apr 29, 2010
    Convert the pipe character into comma character
    Then import it into Number as a csv file

    1. open terminal

    2. sed -e 's/\|/,/g' filename1 > filename2

    3. import the newly created filename2 file into Numbers as a csv file

    Hey, what else can I say? I'm a unix person.
  3. morwen macrumors newbie

    Apr 10, 2006
    Almost 7 years later I thank you for this, I've forgotten so much of my unix command line stuff lol. Apparently AT&T can't create a correct Excel or .cvs file when they export your data usage info. Useless anyhow as they don't define the kb or the mb in the usage column on the dumped info like they do on the web page. The cvs page is pipe delimited not cvs, and the Excel .xls file they create opens all on one line. Whee!

Share This Page