Page 1 of 1
Question about search for IPC_class_symbol
Posted: Fri Mar 11, 2016 12:23 am
by liuxia0510
I want to download the database based on the IPC classification of green patents, listed by OECD green patents report, for example select xx from xx where pc_class_symbol like ' B60L7/10'. how should I type the space ?
many thanks
Re: Question about search for IPC_class_symbol
Posted: Fri Mar 11, 2016 8:11 am
by mkracker
IPC as well as CPC symbols in PATSTAT are formatted according to WIPO standard ST.8. In ST.8 the main group always has 4 characters, consisting of a right aligned number and leading blanks to fill up the 4 positions.
So when searching for IPC symbol B60L7/10 you must add 3 spaces, because the main group consists of a single digit '7'. So a condition would look like this:
when searching for exactly this symbol. To use a wild card requires the LIKE operator. To search for all subgroups of 'B60L 7/', you would therefore write:
When you are not sure about the meaning, allowed values or format of an attribute, it's always a good idea to consult the Data Catalog, downloadable from EPO's PATSTAT page
http://www.epo.org/searching-for-patent ... tstat.html in tab "Download".
I hope that helps.
Re: Question about search for IPC_class_symbol
Posted: Fri Mar 11, 2016 2:48 pm
by liuxia0510
very useful, thanks a lot!