initcap exceptions
268940Mar 19 2007 — edited Mar 19 2007We load data from a source system that is all uppercase. We convert the data over using initcap but do not want this to apply to all data. For example, we have a character string of 'HO AOM UNIT'. The initcap on the field produces 'Ho Aom Unit' where we would like to see 'HO AOM Unit'. I was thinking of using the replace or translate functions to handle the exceptions but not sure how to apply to multiple character strings within one character string in one pass.
Any suggestions.