Extract date from html string

Help Studio
1

Hi All,

Please help in extracting date from the below string:

03-May-2017 05:43
2

@som17 If the date is always in the same format, then you can try this :
System.Text.RegularExpressions.Regex.Matches(“03-May-2017 05:43”,“\d\d-\w±\d{4}”)(0).ToString

1 Like
3

the dats can vary…but the format of string will be the same

4

@som17 Try using the above Expression for all inputs that you have and check if it works

5

for fileName i am extracting it like this…
when filename in the HTML string is :3may17.zip
holdline.Substring(holdline.indexof(“href=”)+6,holdline.indexof(“”“>”,holdline.indexof(“href=”)+6)-(holdline.indexof(“href=”)+6))

Can it be dynamic for date as well?
6

@som17 Can you explain what are you trying to extract from the html ? :sweat_smile:, If you can provide the html String in a Text and tell us what needs to be extracted?

7

td align=“right”>21-May-2019 12:03 </td

8

@supermanPunch

9

@Anthony_Humphries can u please support in this.

10

@som17 I guess you can use the same Expression, it does extract the date from it.

11

no…it doesn’t

12

@som17 What did it return error? Or Null ?

13

I assigned fileDate=holdline.Substring(holdline.indexof(“align=”)+2,holdline.indexof(“”“>”,holdline.indexof(“align=”)+2)-(holdline.indexof(“align=”)+2))
where holdLine is a string
but BOT is giving output as : ign="top
extracting top froom the string part:
td align=“right”>21-Aug-2019 15:09 td align=“right”>109K 
td valign=“top”>

14

@som17 Have you used the expression which I have provided? :sweat_smile:

15

i cant use that as it will hardcode the string…i have to keep it dynamic

16

@som17 You can make it dynamic :sweat_smile:

17

can you please share the kind of expression u r suggesting?

18

@som17 Considering you have the td tag in the holdline variable, you can try this :
System.Text.RegularExpressions.Regex.Matches(holdline,“\d\d-\w±\d{4}”)(0).ToString

19

it gave error:
Assign: Specified argument was out of the range of valid values.
Parameter name: i

i used it like fileDate= System.Text.RegularExpressions.Regex.Matches(holdline,“\d\d-\w±\d{4}”)(0).ToString

20

You can extract text using substring as below

strText.Substring(strText.IndexOf(“>”)+1,strText.IndexOf(“</”)-strText.IndexOf(“>”)-1).Trim

1 Like