Counting date time occurances in a text field

[DKMI]

I am hoping someone may be able to help with the following challenges.

Challenge 1:

I have a text field like this:

2021-10-14 19:31:44 - HR_EC_Connector (Employee Central Connector) (Additional comments)
Manager Approval
Decision: approved
Approver: 10111s

2021-10-14 18:51:46 - HR_EC_Connector (Employee Central Connector) (Additional comments)
User HR_EC_Connector (Employee Central Connector) has initiated a Promotion of Employee requests approval

The bottom section is a comment added to a ticket on the date shown, The top section is the ticket being updated with a response.

I am looking to count the number of messages in this field ie.. count the number of times the format YYYY-MM-DD HH:MM:SS is used (none of the other text is available in all records)

Challenge 2:

How might I calculate the average response time for all messages within this field?

[atcodedog05]

Hi @DKMI 

You can use a formula like this

REGEX_CountMatches([Field1], 
"\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}")

Workflow:

Hope this helps : )

[binuacs · Accepted solution]

@DKMI  answering your second question

[atcodedog05]

Totally missed out on the 2nd requirement 😅. Great catch @binuacs 🙂

[DKMI]

Outstanding thank you!