LibreOffice reads the file fine? I don't understand the error message
but if there's an issue with line 10, I'd try reading the first nine
lines. If that works, I'd examine line 10 carefully. I think the error
is that PSPP sees invalid data at some point.
Out of curiosity, does this file have a BOM (byte order marker)? Because
I think that's how a program would autodetect the character encoding,
but if the program reading the file doesn't know about a BOM, it causes
trouble. But usually by making the first label wrong, so probably not an
issue here.
-Alan
On 10/28/2023 2:08 PM, Andreas Hammer wrote:
Hello,
i have a problem to import a csv-file (comma-delimited) with about 130
variables and 2.900 cases.
Systeminformation
╭────────────────────────┬──────────────────────────────────╮
│Version │GNU pspp 2.0.0-pre1g53a4da │
│Hostsystem │x86_64-w64-mingw32 │
│Build System │x86_64-pc-linux-gnu │
│Lokale Sprachverzeichnis│C:\Program Files\PSPP/share/locale│
│Compilerversion │10-win32 20210110 │
╰────────────────────────┴──────────────────────────────────╯
I run win11.
I see the file content (screenshot 1) and the next step shows nothing
(screenshot 2).
I have taken into account the character set (I set manualy UTF 8
because automatic does not work at this file).
I have tried different variants (csv, ods)
GET DATA
/TYPE=TXT
/FILE="C:\....\iab-occpanel_v1.0_2012-2018.csv"
/ENCODING="UTF-8"
/ARRANGEMENT=DELIMITED
/DELCASE=LINE
/DELIMITERS=","
/QUALIFIER='"'
/VARIABLES=
10.1: Fehler: GET DATA: Syntaxfehler: Erwarte Bezeichner. (probably:
expect QUALIFIER)
10 |
| ^
Any idea to solve my problem?
Thank you.
Best Greetings
Andreas Hammer
--
Andreas Hammer M. A.
Beratung & Evaluation
Eppinger Str. 62
D-76684 Östringen
Telefon +49 72 59 - 92 57 29
Mobil +49 170 - 2 82 68 14
Signal +49 170 - 2 82 68 14
WhatsAPP +49 151 - 59 82 01 95
Telegram +49 151 - 59 82 01 95
http://www.andreas-hammer.eu/
Twitter:www.twitter.com/AndreasHammer
Xing:https://www.xing.com/profile/Andreas_Hammer28
Linked.In:www.linkedin.com/in/andreas-hammer
Mastodon: @Hammer_A@mastodon.social
Bankverbindung: IBAN DE87 6635 0036 0017 6394 54
Steuer-Nr. 30361/32021 - Gerichtsstand Bruchsal
>> Evaluationen - Fortbildungen - Vorträge - Konzeptionen - online-Befragungen
<<
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.
science + technology = better workers
https://talalg.com
Betteridge's Law of Headlines: Any headline that ends in a question mark
can be answered by the word "no."
