Hello all.
I am trying to extract a date (US format) using Jira automation from a string inside of a comment.
A couple of examples of comments I need to be able to parse out the date from are below.
1.) WO Reassignment - WO #WO01708082 has been reassigned to xyz with a due date of 3/4/2023.
2.) Pending WO Auto-Dispatched (Parts) - All pre-ordered parts for this work order have been delivered by the carrier, and the work order is being dispatched. New ETA: 3/4/2023 8:00:00 PM
I have gotten this far in my automation below, but I am stuck on how to pull the variable out of the string to use later in the automation.
Any ideas? Any help is greatly appreciated.
Probably worth mentioning that my "Tech ETA" field is not an open string. It is "Date/Time Picker"
It looks like these two work as per my testing, but I need to have something that can grab dates in either format (mm/dd/yyyy & m/d/yyyy)
(\d{1}(\/|-)\d{1}(\/|-)\d{2,4}) - pulls dates with 1 in m/d (ex. 3/4/2023)
(\d{2}(\/|-)\d{2}(\/|-)\d{2,4}) - pulls dates with 2 numbers in m/d (ex. 03/04/2023)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.