Date:         Wed, 10 Nov 2004 15:59:57 +0100
Reply-To:     Spousta Jan <JSpousta@CSAS.cz>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Spousta Jan <JSpousta@CSAS.cz>
Subject:      Re: Save to a semicolon delimited text file
Comments: To: "Becker-Borowitz, Markus" <Markus.Becker-Borowitz@INFORES.COM>
Content-Type: text/plain; charset="iso-8859-1"

I think that it can be done with WRITE, but of course you must then write down all the ";"'s between wariables. Or make a macro for it.

I personally would use rather Markus' possibility 2, which is not so cumbersome if you use programming language like Perl or Ruby (both are free and good) for the replacement.

HTH

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of Becker-Borowitz, Markus
Sent: Wednesday, November 10, 2004 2:16 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: AW: Save to a semicolon delimited text file


Hello Lars,

From Version 9 to 12 you don't have the possibility to create a csv file directly (I don't know if it is possible with SPSS 13).

But you have some alternatives:
1. Create a xls file, open it with excel and save it as a csv.
2. Create a tab delimited file and replace the the tab thru a ;
3. create a new string variable and concat the variables into it you need: (but you are limited to 255 characters)
     newvar=concat(ltrim(rtrim(a1)),';',ltrim(rtrim(a2)),';',ltrim(rtrim(a3)),';')

All these alternatives are not really good. If there are any other ideas existing, please let me know.

Markus




Markus Becker-Borowitz
Tools/Delivery - Special Formats

  _____

IRI Home
Information Resources GfK GmbH, Nordwestring 101, D - 90319 Nürnberg
Tel.: +49 (0)911 88182-228    Fax: +49 (0)911 88182-461    Email: markus.becker-borowitz@infores.com    Web: www.infores.com

Der Inhalt dieser Email ist vertraulich. Falls Sie nicht der angegebene Empfänger sind oder falls diese Email irrtümlich an Sie adressiert wurde, verständigen Sie bitte den Absender sofort und löschen Sie die Email sodann.

The contents of this message and all attachments have been sent in confidence for the attention of the addressee only. If you are not the intended recipient you are kindly requested to preserve this confidentiality and to advise the sender immediately of the error in transmission.



-----Ursprüngliche Nachricht-----
Von: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] Im Auftrag von L Johansson
Gesendet: Mittwoch, 10. November 2004 13:19
An: SPSSX-L@LISTSERV.UGA.EDU
Betreff: Save to a semicolon delimited text file


How do I save a sav file to a  semicolon delimited text file?

Ciao,
Lars