7 Replies Latest reply on Jun 13, 2016 12:07 AM by Vijay Kumar

    Need Help in IF Condition using STARTSWITH

    Vijay Kumar

      Hi Friends,

       

      I am putting location based on the IP range..

       

      IF STARTSWITH (IP ADDRESS,"10.10") THEN DENVER

       

      The above formula works fantastic but my situation is like below.

       

      IP Address

      10.100 - Denver

      10.100.1 - China

      10.100.2 - Chicago

       

      I dont know how can I do a condition on the above class for defining the location.