[muglo] Re: CSV File
- From: Dave Knight <dave@xxxxxxx>
- To: muglo@xxxxxxxxxxxxx
- Date: Mon, 24 Jan 2011 20:31:56 -0500
Excel has an import tool which would let you pick your choice of column
delimiter, Numbers doesn't. It's commas or nothing.
There are many ways to replace the ; with , in your file, here's one using one
of the UNIX tools on your Mac
Save your CSV file on your Desktop
Start a terminal
/Applications/Utilities/Terminal.app
Run these commands in the terminal
cd Desktop
sed 's/;/,/g' SYNAVE.CSV > SYNAVE-2.CSV
That changes into the Desktop folder, then has the sed utility switch (s///)
all (/g) ';' to ',' in the file SYNAVE.CSV and save the result in SYNAVE-2.CSV
You should then be able to SYNAVE-2.CSV in Numbers and have good things happen.
dave
On 2011-01-24, at 8:09 PM, Terry Genereaux wrote:
> Hi
>
> I am tryng to import a CSV File into numbers and each column is seperated by
> a ; how do i tell numbers to make new columns ..
>
> I have attached the file.. if you use quick view that is how i want to see
> the file in numbers..
>
> <SYNAVE.CSV>
>
>
> Thank You
>
> Terry Genereaux
> terrygenereaux@xxxxxxxxxx
>
> MacBook Pro 2.2 Ghz ~ 4g Ram ~ 500g HD ~ SL 10.6.6 / Windows 7 Boot Camp
>
---
Manage your account options at //www.freelists.org/list/muglo
Other related posts:
