Creating Other Identifiers

[ https://arctosdb.wordpress.com/documentation/catalog/#parse_otherid is current ]

Under individual specimen records, Other Identifiers are a three-part field:

  • Prefix (text)
  • Number (integer)
  • Suffix (text)
All search features rely on a (stored) concatenation of these fields, called Display_Value.

The specimen bulkloader has only one field for (each of several) Other Identifiers. At load, the values provided in this field are parsed into individual fields according to the following rules.

  • Integers are loaded as Number
  • Strings consisting on a single alpha character followed by a number (V12345) are split into Prefix and Number (V and 12345, respectively)
  • Strings consisting of a number and a single alpha character (12345a) are split, as above, into Number and Suffix
  • Strings containing one or two "separator characters" (| - . ;) are split at those characters.
  • The results of the above are checked to ensure that Number is an integer
  • Finally, the re-concatenated value is checked against the original. If they don't match, the original becomes Prefix.
Examples:
InputPrefixNumberSuffixDisplayExplanation
v12345v12345NULLv12345One character plus number
v-12345v-12345v-12345v-12345Split at a separator character
v-12345-1v-12345-1v-12345-1Split at separator characters
1[12345]11[12345]1NULLNULL
1123451Brackets are treated as characters.
1-abc-21-abc-2NULLNULL1-abc-2Number is not numeric
v-00001v-00001NULL
NULLv-00001Above rules would lead to dropped leading zeroes in Number

(Much of this procedure is included in Arctos Definitions and Standards as a broader description of Other Identifiers.)