6 Replies Latest reply: Aug 7, 2015 6:15 AM by Shane Spencer RSS

    Seperating 2 types of data from a field

    Shane Spencer

      I've got some data that includes a field called [Client Name]. This field will have either

       

      a) A users PC Name

      b) A Server Name

      c) An IP Address

       

      From the Server Name or the PC Name I will want to keep only the data to the left of the first '.' but if it's an IP Address I want to keep the full IP. Is there a way to Identify what is an IP Address and what is not? That way I can do an If command to parse what ever data is not an IP. Going forward I may split the data in to 2 fields based on whether it's an IP or not but cannot be sure at this point.

       

      i.e.

       

      127.9.76.112

      127.9.75.212

      127.9.76.210

      ssu1l212-admin.uk.hibm.hsbc

      ssu1l212-admin.uk.hibm.hsbc

      ssu1l212-admin.uk.hibm.hsbc

      ssu1l212-admin.uk.hibm.hsbc

      a356g7ldbpntzdu.in.hsbc

      a356g7ldbpntzdu.in.hsbc

      a356g7ldbpntzdu.in.hsbc

      e82617lzwd5d4u2.ho.banking.uk.hsbc

      gbl10910.systems.uk.hsbc

      a356c7l9h29642n.in.hsbc

      ctiexp.systems.uk.hsbc

      a35697dzycjn79b.in.hsbc

      e82617lzwd5d4u2.ho.banking.uk.hsbc

      GBW06547.HBEU.ADROOT.HSBC

      11.129.250.17

      a35677lzz895ta2.in.hsbc

      a356w7lj6a5skgx.in.hsbc

      a35697dzycjn79b.in.hsbc