Maybe IF STARTSWITH (IP ADDRESS,"10.10") and NOT STARTSWITH (IP ADDRESS, "10.100." THEN DENVER
Hi John please see my IP addresses below.
10.100.xx.xx - Denver
10.100.1.xx - China
10.100.2 .xx- Chicago
I have the above scenario which has 10.100.xxx IPs come under Denver but 10.100.1.xx and 10.100.2.xx alone ranges come under 2 different cities
Hi Vijay, a simple solution is to place the Denver test last:
IF STARTSWITH([IP], "10.100.1.") THEN "CHINA" ELSEIF STARTSWITH([IP], "10.100.2.") THEN "CHICAGO" ELSEIF STARTSWITH([IP], "10.100.") THEN "DENVER" END
Hi John this is not a single situation because like Denver I have scenarios
for multiple locations out of 100 cities in my DB.
can you share the IP address and country name sample data for 100-150 rows. I think rather than startswith we should give a try to regular expressions. I can give it a shot if you can provide me mentioned data.
Got any solution? It's not that I am looking for a formula only with that
starts with and if.. pls suggest me a best solution
On 08-Jun-2016 11:46 am, "Ashish Chaudhari" <firstname.lastname@example.org>