Is it possible to find whether the city is inside the India or international by reading the city name in uipath

Help Studio
1

Hi,
There is an excel file with Name and City I want to know the city is international or not if the city is international write that city name in another sheet with the person name as well…

excel sheet be like this
image

Thanks in Advance!

2

Hi @tejaswi_nerella
https://simplemaps.com/data/in-cities
above is a website from where you can download an excel file that contains almost all places in India. So you can perform the task by comparing sheets

1 Like
3

Hi @tejaswi_nerella

I think you can achieve this with the help of google search and little UI Automation.

Thanks and Regards
Karun

4

Hi @Mohsin_Inamdar I have an excel file but my question is read the city name if the city is international write that city name in another sheet

5

If your city name is not available in that Simplemap’s sheet then you can consider that the city is international.

6

City names are like this in the excel file
image

Read “New York” if “New York,” is outside India write New york in another sheet like that read each city name and recognize if it is inside India or not. if "Bangalore is inside India keep it the same sheet.

7

Identify International Cities.zip (56.0 KB)

Hope this will help you

1 Like