Hello fellow RegExers,
Does anyone know of a useful regular expression that can prepend a default value to the beginning of an alpha-numeric string only IF NOT BLANK?
Example - If there is an actual value present in column X, then prepend "2016" to that value. If there isn't a value (blank) there, then do nothing but leave blank.
Many thanks for any advice! AB