[Aavso-photometry] csv files with excel - problem solved

Yenal Ogmen yenalogmen at yahoo.com
Fri Apr 4 16:55:11 EDT 2008


I solved the problem. The problem was regional
settings. Thank you Eric for the solution. And thank
you Jim for the informative reply.

Clear Skies.

--- "Eric.Broens at skynet.be" <Eric.Broens at skynet.be>
wrote:

> Hi,
> 
> the reason is that the Windows list separator is set
> differently on Yenal's
> laptop and PC.
> The list separator can be set via the control panel.
> In XP this can be done
> as follows:
> 
> - open the "Regional Options" in the control panel
> - select  "customize" button in the "Regional
> Options" tab
> - enter the character in the "List separator" field
> which is used to
> separate the fields in the "CSV" file.
> 
> An other possibility to split the data:
> - open the file in excel
> - select all entries
> - in the "Data" menu select "Text to Columns"
> - select "Delimited" and click next
> - select the correct delimter or enter the delimeter
> used to separate the
> fields in the "CSV" file
> 
> Best Regards,
> Eric
> 
>
--------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://link.mail2web.com/mail2web
> 
> 
> 


Yenal Öðmen
  Green Island Observatory Homepage
www.geocities.com/yenalogmen 
Geçitkale 
North Cyprus



      ____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.  
http://tc.deals.yahoo.com/tc/blockbuster/text5.com


More information about the Aavso-photometry mailing list