[vsni.co.uk] Contact us
Author Message
Post new topic

  GenStat  ~  SYLK file type

Jeff Wood
Posted: Sun Feb 17, 2019 4:23 am Reply with quote
Joined: 19 Apr 2010 Posts: 144
Dear Genstatters


I have just read a .SAV file (from SPSS) and then written it out as a .GSH file and a .CSV file.


When I try to read the .CSV file with Excel I get a message saying the file is a SYLK file and cannot be read. apparently this is because the first entry in the data is ID. If I change it to XID there is no problem. This seems like a very bizarre feature. What is the logic behind it?


Best wishes


Jeff


Jeff Wood, Ph.D. A.Stat.
Fenner School of Environment and Society
Frank Fenner Building 141
Australian National University
CANBERRA ACT 0200
Australia

Phone +61 2 6125 4741
Fax +61 2 6125 0757

ANU CRICOS PROVIDER NO. 00120C

Post generated using Mail2Forum (http://www.mail2forum.com)
View user's profile Send private message
david@vsn.co.nz
Posted: Wed Feb 20, 2019 1:39 am Reply with quote
Joined: 30 Jul 2009 Posts: 283
Dear Jeff,

A SYLK (Symbolic Link) file an old ANSI file format used to exchange spreadsheet data with other applications.
The first two characters of a SYLK file are ID which is why Excel thinks your CSV file is a SYLK file.
Sadly, it is a very old format without a good unique file identifier.
Your error is noted here: [url=https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)]https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK)[/url]

Regards, David.
______________________________________________
Dr David Baird Statistical Consultant and GenStat Developer
VSN (NZ) Limited (David@VSN.CO.NZ (David@VSN.CO.NZ))
8 Mariposa Crescent, Aidanfield, Christchurch 8025, New Zealand
Ph +64 3 3350588 Cell +64 21 1160803


From: GENSTAT-Request <GENSTAT@jiscmail.ac.uk> On Behalf Of Jeff Wood
Sent: 17 February 2019 5:23 PM
To: GENSTAT@JISCMAIL.AC.UK
Subject: SYLK file type



Dear Genstatters



I have just read a .SAV file (from SPSS) and then written it out as a .GSH file and a .CSV file.



When I try to read the .CSV file with Excel I get a message saying the file is a SYLK file and cannot be read. apparently this is because the first entry in the data is ID. If I change it to XID there is no problem. This seems like a very bizarre feature. What is the logic behind it?



Best wishes

Jeff



Jeff Wood, Ph.D. A.Stat.
Fenner School of Environment and Society
Frank Fenner Building 141
Australian National University
CANBERRA ACT 0200
Australia

Phone +61 2 6125 4741
Fax +61 2 6125 0757

ANU CRICOS PROVIDER NO. 00120C

Post generated using Mail2Forum (http://www.mail2forum.com)
View user's profile Send private message

Display posts from previous:  

All times are GMT
Page 1 of 1
Post new topic

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum