Separating DateTimes with regex.

[senem127]

I want to separate 01.01.21 and 31.01.21 from the data with Regex. How can do it? Thanks.

-Отчет по производителю

Дата с 01.01.21 по 31.01.21

Производители: 57,465,472,477

[Emil_Kos]

Hi @senem127,

I have created a workflow for you:

This is the formula that I have used:

\d\d\.\d\d\.\d\d

[BenMoss]

You could use the RegEx tool in tokenize mode (because we want to repeat the same pattern, I believe this statement should work...

\d\d\.\d\d\.\d\d

Escaping the full stop delimiters because we want a literal full-stop and not any character (which just a dot would give).

There are certainly other ways of doing this though!

Ben

[messi007]

@senem127,

You can use Reg Replace as well.

Please see below:

Attached the workflow,

Hope that helps!

Regards