I am standardizing unit names, however many of them contain a non-standard indicator at the end of the unit name (it denotes geographically separated but part of the same unit). I need to remove this final string so these units can later be combined into one unit. Typically I would substring this, but the indicator 1) does not occur on every unit name, 2) is not in a standard position in the string, and 3) the final sting itself isn't consistent in the use of digit vs character starting in position 3 (see below). Examples of the unit names: SURGICAL OPS OLA900 SURGICAL OPS OLHC00 EDU AND TRNG OL0IZH EDU AND TRNG OL0PZR LEGAL OLCS00 LEGAL OLA200 The final sting always starts with " OL". Searches have brought me to PRXCHANGE, but as I've read in forums and found out myself, the syntax is particularly confusing. What is your best practice recommendation in this situation?
... View more