Help with Regex Replace please

[JohnMac (John)]

Hi clever people

I need to manipulate a string. Several times during the string, I have the following text: <time datetime="2019-11-06" />
What I need to do it strip out everything except the date. I started with two Regex.Replace - one for "<time datetime=\" and one for \" />. However, that causes problems, as \" /> appears elsewhere in the string. I only want to remove it where there is a date wrapped in . If anyone is able to help I’d be grateful.

Examples:
<p><time datetime=\"2019-11-06\" /> </p></td><td><p /> should result in <p>2019-11-06<p />
<td><p><time datetime=\"2020-06-02\" /><strong> should result in <td><p>2020-06-02<strong>
<col style=\"width: 172.0px;\" /> would not be changed.

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(text,"<time\s*datetime=\""(\d{4}-\d{2}-\d{2})\""\s*/>\s*","$1")

Regards,

[JohnMac (John)]

That was perfect. And elegant! Thank you for your help.