remove noise from text strings using TRANSLATE

remove noise from text strings using TRANSLATE.sql

--
-- Lets say I have this character data, how do I extract the numeric?
--
-- Q: Library  . . . . . . :   SYSIBM          Number of objects  . :   65
-- A: Use the TRANSLATE built-in function to convert all the noise characters to blanks

values bigint(
    translate(
      'Library  . . . . . . :   SYSIBM          Number of objects  . :   65', 
      ' ',
      'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz.:'));