AnsweredAssumed Answered

Performing a find on text fields that contain the asterisk*

Question asked by DaleLong on Feb 4, 2013
Latest reply on Feb 12, 2013 by 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!

Outcomes