I have a long list of references. Some of them are internet sources that have a URL, some are books, others are journal articles, etc.
I have used =IF(ISNUMBER(SEARCH("http",A2,1)),"internet",IF(ISNUMBER(SEARCH("edited",A2,1)),"book","journal article")) to classify the references, and it works to identify internet sources and books well. As you can see, I have decided to call anything else "journal articles." That is not ideal, because the rest are not all journal articles (some could be conference proceedings, or Govt. reports, etc.) So I would like to be able to identify journal articles specifically. The only thing common among them is that they will have a ":x-x" reference where each x is a number. These numbers could be single digit numbers each or multiple digits. Furthermore, the two x's need not be the same number of digits (e.g., :99-115). I would like to find such references and label them as "journal articles." How do I do that?
Thanks.
Bookmarks