How to get year format number from a string?

[Ying_Zhen_Lee (Ying Zhen)]

Hi,

I have a string from a Word Document

I want to compare the year from the word document and the year from our computer.
I have already get the year from the computer using System.DateTime.Now.ToString(“yyyy”)

The problem now is how do I get the year from the string, shown in the picture above?
The string has 2 number, 2017 and 2.
How do I know which number is the year?

Thank you

[nimin (nimzz)]

Hi @Ying_Zhen_Lee,

First you can extract the year from string and compare it with System.DateTime.Now.ToString(“yyyy”).

Please assign string_var=System.Text.RegularExpressions.Regex.Match(your_string,"(\d{4})(?=\sTime)").ToString.Trim

Warm regards,
Nimin

[Sheshrocks (Shesh)]

use CINT(convert.ToDateTime([your date]).ToString(“yyyy”)) to compare with your numeric year

[Ying_Zhen_Lee (Ying Zhen)]

Hi @nimin,

Thanks for your reply!

It works However may I ask (?=\sTime) is it for DateTime format ?

Thank you

[Ying_Zhen_Lee (Ying Zhen)]

Hi @Sheshrocks,

Thanks for your reply and help!

[nimin (nimzz)]

Hi @Ying_Zhen_Lee,

@Ying_Zhen_Lee

(?=\sTime) is it for DateTime format ?

This is a look ahead regular expression. For the string, “Feb 2017 Time allowed: 2 hrs” only “\d{4}” is enough to capture the year. But if there is a possibility of more than one year in your string, for eg: “Feb 2017 Time allowed: 2 hrs. Now it’s 2019” , (?=\sTime) will looks for presence of 4 digits(\d{4}) before the word “Time”. That’s it.

Regards,
Nimin

[Ying_Zhen_Lee (Ying Zhen)]

Hi @nimin,

Thanks for the explanation, now I get it!

Thank you