View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04288 | Bug reports | Import/Export | public | 2010-04-21 14:53 | 2010-05-05 10:28 |
| Reporter | Assigned To | mdekker | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.87+ | ||||
| Target Version | 1.90b | Fixed in Version | 1.90b | ||
| Summary | 04288: Quotes in SPSS export variable labels cause errors | ||||
| Description | The SPSS export for and import into version 18 escapes quotes in the question text as \" in the variable lables. Eg. This produces an error:
| ||||
| Steps To Reproduce | Run attached syntax file with attached data file. From scratch put quotes in a survey question and export to SPSS >16. | ||||
| Additional Information | I'm assuming consistent reproducability; don't know if SPSS Python plugins might have an effect. Suggestion: It might work to replace the \ escape with a pretend line concatenation: or equally "I find it difficult to say "+ Might it be possible to use "+' and '+" to 'escape' double quotes and '+" and "+' to escape single quotes? The SPSS Help advice is single or double quotes for enclosed double and single quotes respectively. Forum message: http://www.limesurvey.org/en/support/forums/2-design-issues/41178-quotes-in-spss-export-variable-labels#41182 | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 8518 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | N/A | ||||
| Database type & version | MySQL server 4.1.12, client API 5.0.51a | ||||
| Server OS (if known) | Win2k3 | ||||
| Webserver software & version (if known) | IIS 6 | ||||
| PHP Version | 5.2.6 | ||||
 |
Fixed in 8623 (for 1.88) by using double quotes around the string, and replacing a double quote inside the string with 2 double quotes --> VARIABLE LABELS V109 "I find it difficult to say \"no\" to my friends". Now outputs: VARIABLE LABELS V109 "I find it difficult to say ""no"" to my friends". Which should be interpreted correct by SPSS |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-04-21 14:53 |
|
New Issue | |
| 2010-04-21 14:53 |
|
File Added: SPSSquotestest.zip | |
| 2010-04-21 19:21 |
|
Status | new => assigned |
| 2010-04-21 19:21 |
|
Assigned To | => mdekker |
| 2010-04-23 13:54 | mdekker | Fixed in Version | => 1.90b |
| 2010-04-23 13:54 | mdekker | Target Version | => 1.90b |
| 2010-04-23 14:02 | mdekker | Note Added: 11641 | |
| 2010-04-23 14:02 | mdekker | Status | assigned => resolved |
| 2010-04-23 14:02 | mdekker | Resolution | open => fixed |
| 2010-05-05 10:28 | c_schmitz | Status | resolved => closed |
