Re: reading csv - MySQL files (Point - Comma Problem)

Posted by Jon K Peck on Feb 13, 2012; 1:46pm
URL: http://spssx-discussion.165.s1.nabble.com/reading-csv-MySQL-files-Point-Comma-Problem-tp5478556p5479323.html

The default decimal character for F format comes from your locale setting.  That has nothing to do with the olang setting.  You can set your locale to a dot-decimal locale  via SET LOCAL=english, say, or use COMMA format instead of F.

Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        drfg2008 <[hidden email]>
To:        [hidden email]
Date:        02/13/2012 02:29 AM
Subject:        Re: [SPSSX-L] reading csv - MySQL files (Point - Comma Problem)
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

... I tried it with:

SET DIGITGROUPING=No Small=0.0001 Unicode=No OLang=English.

but this doesn't work.

The files come from a MySQL DB, were read by SPSS 20 and saved by SPSS 20 as
csv.

-----
Dr. Frank Gaeth
FU-Berlin

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/reading-csv-MySQL-files-Point-Comma-Problem-tp5478556p5478577.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