3 Replies Latest reply on Oct 16, 2018 12:31 PM by Jeff Bugajski

    Regex Help

    Jeff Bugajski

      Hi All,

       

      I'm new to regex function but I think it is what I need.  I have a series of part numbers all formatted like this...5553R25N90, 3387W43P72, 1583H34B29.  I want to use REGEX_EXTRACT isolate the inner three digit string of the first letter and following two numbers (R25, W43, H34 in my example above).  I'm sure this is a simple calculation but for the life of me I can't seem to figure it out.  Any help would be appreciated.

       

      Thanks,

      Jeff