Bad character in tls201_part05.txt

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

mkracker
Posts: 120
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Bad character in tls201_part05.txt

Post by mkracker » Fri Nov 03, 2017 8:18 am

Dear subscriber of PATSTAT Biblio,

In case you have downloaded the files of the 2017 Autumn Edition before the noon of Nov 2nd, 2017:
File tls201_part05.txt contains a bad character (marked red in the middle line below) in one of its lines, which may cause issues when you import the data into your database.


44349801,"SU","3504275","A ",1982-10-25,1982,"SU19823504275","82 3504275","PI",0,N,N,Y,...
44349802,"SU","3504281","A ",1982-10-22,1982,"SU19823504281","8" 3504281","PI",0,N,N,Y,...
44349803,"SU","3504282","A ",1982-10-20,1982,"SU19823504282","82 3504282","PI",0,N,N,Y,...

We advise you to either
- replace the double quote marked red by the digit 2
or
- re-load the file data_PATSTAT_Biblio_2017_Autumn_01.zip from EPO's Raw Data Download platform, which now contains the corrected file tls201_part05.txt.

In case you have downloaded the files after the noon of Nov 2nd, 2017: You already have downloaded the corrected file.

Sorry for the inconvenience,
Martin
PATSTAT / EPO
-------------------------------------------
Martin Kracker / EPO


Post Reply