USPTO Proxy

-
This application is a tool for accessing the database of patents and patent applications hosted by the U.S. Patent & Trademark Office (USPTO). This database is conventionally accessed through the web, which is sufficient (though clumsy) for human-readable access, but inadequate for automated applications that need well-formatted data.

This application provides a class library (DLL) called USPTOProxy that can be dropped into an application and used as a simple, effective proxy interface for the database. The application can fetch patents and patent applications, with the results returned as structured objects. The application also allows the user to query the database of patents and patent applications with a standard "advanced query" string (e.g., "ttl/neuron and an/merck"), and the user may specify whether the results should be returned as an array of references that match the query or as an array of patent/patent application objects. More

Comments

Post a Comment

Popular posts from this blog

WIPO Pearl - Recap

-
WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. It helps promote accurate and consistent use of terms across different languages, and makes it easier to search and share scientific and technical knowledge. You can conduct your searches by following two modes: Linguistic Search  :  WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. Search by term, with optional parameters. Select a Source Language for best results, and disable ad-blocking plug-ins. Concept Map Search  :  WIPO’s multilingual terminology portal gives access to scientific and technical terms derived from patent documents. Search by concept, or by subject field/subfield by clicking on the bubbles; click on a concept to open the terminology record. Select a second concept to view the concept path, and click on the "Export concept path" button to perform a combined keyword search
Read more

Zotero - Next Generation Research Tool

-
Image
Zotero is a free citation management tool to help you save and organize citations and automatically create formatted bibliographies. Zotero Key Features Automatically extract citation information from websites, library catalogs, databases, and more. Save PDF files, images, screenshots, and other files. Record your research notes. Automatically create formatted bibliographies in many different styles. Use Zotero with word processing programs like Microsoft Word. Sync the citations and files you save online. Access your saved information from anywhere. Share your saved information online with groups. Use Zotero -- an open source tool -- for free. To get Started                         Go to  http://www.zotero.org/  and click on the red  Download  button.
Read more

VBA Code - Remove invisible special characters from string

-
Sometimes in excel data, we encounter various unwanted characters, spaces etc which are not cleaned by common clean function in the excel. The following function easily clear those characters. Function sFnRemoveSC(sInput As String) As String Dim lLoop As Long, sSpecialChars As String sSpecialChars = "!@#$%^&*()_+={}|[]:;'<>?,.~`" For lLoop = 1 To Len(sSpecialChars) sInput = Replace$(sInput, Mid$(sSpecialChars, lLoop, 1), " ") Next sFnRemoveSC = sInput End Function If you by "Invisible" characters mean "not on the keyboard", then use the code number and add to the string using the character code  sSpecialChars = "!@#$%^&*()_+={}|[]:;'<>?,.~`" + Chr(9) + Chr(10) Function CleanTrim(ByVal S As String, Optional ConvertNonBreakingSpace As Boolean = True) As String Dim X As Long, CodesToClean As Variant CodesToClean = Array(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, _ 21, 22, 23,
Read more