- Posts: 409
- Thank you received: 34
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
SPPS .dat file: Column Offset
- blocka
- Topic Author
- Offline
- Platinum Member
Less
More
3 years 4 days ago #215180
by blocka
SPPS .dat file: Column Offset was created by blocka
I'm running LS 3.25.22+210413
When I export my response data to SPPS (both version options), the columns are mismatched (data gets pushed out in some rows).
From what I can tell, it is occurring where I have Other type questions, and the participant included a comma in their text:
Where Other text has a commas, the SPSS data gets split between two columns:
This looks like a bug to me... Has anyone else encountered this?
When I export my response data to SPPS (both version options), the columns are mismatched (data gets pushed out in some rows).
From what I can tell, it is occurring where I have Other type questions, and the participant included a comma in their text:
Where Other text has a commas, the SPSS data gets split between two columns:
This looks like a bug to me... Has anyone else encountered this?
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
3 years 4 days ago #215183
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic SPPS .dat file: Column Offset
I recommend to report that as a bug.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- blocka
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 409
- Thank you received: 34
3 years 4 days ago #215184
by blocka
Replied by blocka on topic SPPS .dat file: Column Offset
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12916
- Thank you received: 3975
3 years 3 days ago #215191
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic SPPS .dat file: Column Offset
Hi, blocka,
Seeing your EXCEL file there are still the single quotes around the text.
Seems to me that the qualifier is wrong.
What is set as DELIMITER and QUALIFIER in the sps-file?
If we compare with the settings in "application/helpers/export_helper.php"
maybe we can see where there is the bug.
Joffm
Seeing your EXCEL file there are still the single quotes around the text.
Seems to me that the qualifier is wrong.
What is set as DELIMITER and QUALIFIER in the sps-file?
If we compare with the settings in "application/helpers/export_helper.php"
maybe we can see where there is the bug.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- blocka
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 409
- Thank you received: 34
3 years 3 days ago #215204
by blocka
Replied by blocka on topic SPPS .dat file: Column Offset
In my .SPS file, this is what I have for delimiters:
Code:
GET DATA /TYPE=TXT /FILE='survey_167811_SPSS_data_file.dat' /DELCASE=LINE /DELIMITERS="," /QUALIFIER="'" /ARRANGEMENT=DELIMITED /FIRSTCASE=1 /IMPORTCASE=ALL /VARIABLES=
The topic has been locked.