3 Replies Latest reply on Apr 20, 2018 3:34 PM by Hari Ankem

    Extract first two sets of numbers from IP address

    James D

      Hello. Does anyone know a calc to achieve this? Regex, or mid/find/left, etc.

       

      Data is like this:

      111.111.111.111

      1.1.1.1

      11.111.111.111

       

      Calc needs to return:

      111.111.

      1.1.

      11.111.

       

      Need calc to extract first two sets of numbers delimited by period (.).