Importing pipe-delimited into iWork Numbers

[Davebkk]

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?

 

[ohanian]

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?

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.

 

[morwen]

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.

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!