Extract date from multiple urls and write into excel

Extract date from multiple urls and write into excel but date is dynamics in every urls,can i read by uipath. Because date format is different means may be 20-DEC-2020,Dec-20,20-12-20202 or many different formats.Please help me in this scenario

Hi @himanshur

Is the date embeded in the url or you want to get the date inside the website pages.

cheers:D

Happy learning :smiley:

2 Likes

i want to get the date inside the website pages.

1 Like

Hi @himanshur

If you have multiple url then loop every url using foreach or forearchrow and use GetTextActivity to get the value of date

cheers :smiley:

Happy learning :smiley:

2 Likes

get text activity only get specific data but if no data present in url then work my bot

1 Like

Hi @himanshur
ofcourse you can check first if that image exist or you can set the properties to continue on error if not found anything.

cheers :smiley:

Happy learning :smiley:

2 Likes

Thanks for your prompt responses.

But let me explain you my requirement by sharing an URL - https://www.vccircle.com/2i-capital-part-exits-pipavav-shipyard/

In this weblink/article, I have several dates in different formats (such as September’06, October 2007, October 9, 2009, etc.).

All I need is the ability to extract different dates that are there in the article/URL.

Hmmm i see it is a hard one because you have different fomat of dates.Maybe what you can do is to explore the regex funtions and from that you can scrape the article and convert it to text file then issue the regex for the multiple format of dates.

cheers :smiley:

Happy learning :smiley:

2 Likes

Please give me one example on url with code