[muglo] Re: CSV File
- From: Terry Genereaux <terrygenereaux@xxxxxxxxxx>
- To: muglo@xxxxxxxxxxxxx
- Date: Mon, 24 Jan 2011 21:16:10 -0500
Works great is there a way to make that a command into a automator script..
Thank You
Terry Genereaux
terrygenereaux@xxxxxxxxxx
MacBook Pro 2.2 Ghz ~ 4g Ram ~ 500g HD ~ SL 10.6.6 / Windows 7 Boot Camp
On 2011-01-24, at 8:31 PM, Dave Knight wrote:
>
> 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
---
Manage your account options at //www.freelists.org/list/muglo
Other related posts:
