Pipe Delimited

[Stimpson, Matt]

Good afternoon,

 

Can any tell me if and how you can save a SPSS file as a pipe delimited file?

 

Thanks,
Matt

 

 

 

 

[David Marso]

See SAVE TRANSLATE ...
 / TYPE=CSV ... / TEXTOPTIONS DELIMITER=("|") ......../FIELDNAMES ..
HTH, David
---
SAVE TRANSLATE
[{/OUTFILE=file }]
{/CONNECT=ODBC connect string}
[{/UNENCRYPTED}]
{/ENCRYPTED }
[/TYPE={CSV }]
{DB2 }
{DB3 }
{DB4 }
{ODBC }
{PC }
{SAS }
{STATA}
{SYM }
{SLK }
{TAB }
{WKS }
{WK1 }
{WK3 }
{XLS }
[/VERSION={1}]
{2}
{3}
{4}
{5}
{6}
{7}
{9}
{8}
{12}
{X}
[/ENCODING={'Locale'}]
{'System'}
{'value' }
[/FIELDNAMES]
[/CELLS={VALUES}]
{LABELS}
[/TEXTOPTIONS [DELIMITER='char'] [QUALIFIER='char']
[DECIMAL={DOT }]
{COMMA}
[FORMAT={PLAIN }]]
Stimpson, Matt wrote
>
> Good afternoon,
>
> Can any tell me if and how you can save a SPSS file as a pipe delimited
> file?
>
> Thanks,
> Matt
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Pipe-Delimited-tp5581082p5581191.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

See SAVE TRANSLATE ...
 / TYPE=CSV ... / TEXTOPTIONS DELIMITER="|" ......../FIELDNAMES ..
HTH, David
---
SAVE TRANSLATE
[{/OUTFILE=file }]
{/CONNECT=ODBC connect string}
[{/UNENCRYPTED}]
{/ENCRYPTED }
[/TYPE={CSV }]
{DB2 }
{DB3 }
{DB4 }
{ODBC }
{PC }
{SAS }
{STATA}
{SYM }
{SLK }
{TAB }
{WKS }
{WK1 }
{WK3 }
{XLS }
[/VERSION={1}]
{2}
{3}
{4}
{5}
{6}
{7}
{9}
{8}
{12}
{X}
[/ENCODING={'Locale'}]
{'System'}
{'value' }
[/FIELDNAMES]
[/CELLS={VALUES}]
{LABELS}
[/TEXTOPTIONS [DELIMITER='char'] [QUALIFIER='char']
[DECIMAL={DOT }]
{COMMA}
[FORMAT={PLAIN }]]

Stimpson, Matt wrote

Good afternoon,

Can any tell me if and how you can save a SPSS file as a pipe delimited file?

Thanks,
Matt

[Stimpson, Matt]

Works wonderfully!

Thank you,
Matt

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Marso
Sent: Tuesday, March 20, 2012 4:53 PM
To: [hidden email]
Subject: Re: Pipe Delimited

See SAVE TRANSLATE ...
 / TYPE=CSV ... / TEXTOPTIONS DELIMITER="|" ......../FIELDNAMES ..
HTH, David
---
SAVE TRANSLATE
[{/OUTFILE=file }]
{/CONNECT=ODBC connect string}
[{/UNENCRYPTED}]
{/ENCRYPTED }
[/TYPE={CSV }]
{DB2 }
{DB3 }
{DB4 }
{ODBC }
{PC }
{SAS }
{STATA}
{SYM }
{SLK }
{TAB }
{WKS }
{WK1 }
{WK3 }
{XLS }
[/VERSION={1}]
{2}
{3}
{4}
{5}
{6}
{7}
{9}
{8}
{12}
{X}
[/ENCODING={'Locale'}]
{'System'}
{'value' }
[/FIELDNAMES]
[/CELLS={VALUES}]
{LABELS}
[/TEXTOPTIONS [DELIMITER='char'] [QUALIFIER='char'] [DECIMAL={DOT }] {COMMA} [FORMAT={PLAIN }]] Stimpson, Matt wrote
>
> Good afternoon,
>
> Can any tell me if and how you can save a SPSS file as a pipe
> delimited file?
>
> Thanks,
> Matt
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Pipe-Delimited-tp5581082p5581192.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Rick Oliver-3]

Is this what you want?

data list free /x y z.
begin data
1 2 3
end data.
save translate /type=csv /outfile='c:\temp\pipe.csv' /textoptions delimiter="|".



Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: [phone] | T/L: 206-4922



From:        "Stimpson, Matt" <[hidden email]>
To:        [hidden email]
Date:        03/20/2012 02:52 PM
Subject:        Pipe Delimited
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Good afternoon,
 
Can any tell me if and how you can save a SPSS file as a pipe delimited file?
 
Thanks,
Matt