Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Davebkk

macrumors newbie
Original poster
Sep 15, 2008
4
0
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

macrumors newbie
Apr 29, 2010
20
0
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

macrumors newbie
Apr 10, 2006
11
3
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!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.