11 Replies Latest reply on Feb 12, 2013 11:32 AM by DaleLong

    Performing a find on text fields that contain the asterisk*

    DaleLong

      Our facility is involved in the field of immunology, and we need to keep track of the names of many Major Histocompatibility Complex (MHC) alleles. The official nomenclature for these look something like these examples:

       

      HLA-A*02:01

      HLA-B*57:03

      Patr-A*01:01

      Mamu-A*01

      DRB1*04:01

       

      Traditionally these items have been saved in our database like this:

       

      HLA-A-0201

      HLA-B-5703

      Patr-A-0101

      Mamu-A-01

      DRB1-0401

       

      However, my boss would like these to be updated to current standards. The problem is, putting the asterisk in the name totally borks the find functionality. I appreciate that the character is a find wild card and that this is likely related to the problem; what I don't appreciate is that the find wildcard somehow equals 'find every character EXCEPT the asterisk character, and totally find nothing in that case'. I don't know why this would be a good idea, but whatever is going on it's a behavior that I want to find a way around if at all possible.

       

      Is there a convincing way to work around this? Perhaps a script trigger to engineer the typed-in find on that particular field, or some other method of configuring the find on a field of which I'm unaware?

       

      Any insight would be most appreciated!