How to parse text to find specific text format

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.

You could do something like this:

=IF(ISNUMBER(SEARCH("http",A2,1)),"internet",IF(ISNUMBER(SEARCH("edited",A2,1)),"book",IF(ISNUMBER(SEARCH(":*-",A2)),"journal entries","other")))

so you are looking for the colon followed by any number of characters followed by the dash to identify journal entries.

Hope this helps.

Pete

Here is a sample list of references in response to the post from FR, but I see that it has been withdrawn. If FR or anyone else wants to check it out, it should give you real examples of the type of strings that I want parse and classify. Successful parsing of the strings in the attached sample file should classify them as follows:

Rows 2-6: Internet
Rows 7-11: Journal article
Rows 12-13: Book
Rows 14-15: Other

Thanks.

Here is probably a simpler example where I am focusing on just the part of the string used to classify it as a journal article or not. In the following, I have four strings. Only the second one should be classified as a journal article. All the others should be "other":

23-65
24: 34-36
sdf:12-166
kl:op-ett

I used three different formulas:
1. =IF(ISNUMBER(SEARCH(":"&{1,2,3,4,5,6,7,8,9,0}&"-"&{1,2,3,4,5,6,7,8,9,0},A1,1)),"journal article","other") - this classifies all four as "other"
2. =IF(ISNUMBER(SEARCH(":{1,2,3,4,5,6,7,8,9,0}-{1,2,3,4,5,6,7,8,9,0}",A1,1)),"journal article","other") - this too classifies all four as "other."
3. =IF(ISNUMBER(SEARCH(":*-*",A1,1)),"journal article","other") - this classifies the first one correctly as "other", the second one correctly as "journal article", but it then classifies the third and fourth also as journal articles (incorrectly).

I understand why Formula #3 works the way it does (* is a wild card and does not distinguish between text, symbols and numbers. I thought the first and/or second formula would specifically look for numbers. But they don't seem to.

Any help would be appreciated. Thanks.