Extract date and time in html tags

Question

Please suggest to me, how to parse this field to get date and time only without using filter tool. 2017-11-03 12:41:00, 2017-11-03 10:10:00, 2017-11-03 12:13:00,

jdunkerley79 · Accepted Answer

Regex is probably easiest.

Two options:

- Formula

IIF(
	REGEX_Match([HTML], '.*datetime="(\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2})".*'),
	REGEX_Replace([HTML], '.*datetime="(\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2})".*', "$1"),
	NULL())

- Regex tool in parse mode

Sample attached

rouzu · Accepted Answer

I think using Parse with RegEx tool  is more easier, thanks for the suggestion..