📝 Overview
If you need to extract the time (minutes: seconds) from a timestamp (in date/time format), you can do this with a regular expression. This article explains how to configure this process.
👉 For more details on how to write regular expressions, please refer to this article: How to Write Regular Expressions.
🛠️ Setup Steps
Choose the Action
Select Data Extraction > Extract Data with Regular Expression.
Configure Extraction
In the "Target to Extract" field, enter the timestamp (such as "Flowbot startup date/time" or "Date/time format output").
Enter Regular Expression
In the "Specify the text pattern to extract using a regular expression" field, enter the following value:
((0?|1)[0-9]|2[0-3]):[0-5][0-9]?
Test & Save
Run the test to ensure the extraction works correctly and that the desired time (minutes: seconds) is retrieved. After confirming the results, enter a name for the output and save.
☝️ Remarks
If you need to extract the date instead of the time, follow a similar approach, but adjust the regular expression to capture the date format.
📚 Related Guides
Related Keywords
Related Keywords
Regular expressions, timestamp, minutes, seconds, date/time format, data extraction, Flowbot