Importing pipe-delimited into iWork Numbers

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

  1. Davebkk macrumors newbie

    Joined:
    Sep 15, 2008
    #1
    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

    Joined:
    Apr 29, 2010
    #2
    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

    Joined:
    Apr 10, 2006
    #3
    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