Hive – Normalize String to Alphanumeric character only using regular expression December 5, 2014 by datafireball select mpn, REGEXP_REPLACE(upper(mpn), ‘[^a-zA-Z0-9]+’, ”) as mpn_norm from … Share this: Share on X (Opens in new window) X Share on Facebook (Opens in new window) Facebook Like Loading... Related