Re: Problem while importing csv-file

[Alan Mead]

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."