I'm working with a JIRA pipeline and the fields from JIRA return a funky format that looks like this:
value:"{u'self': u'https://xxxxxxxxx.atlassian.net/rest/api/2/customFieldOption/23142', u'id': u'23142', u'value': u'NS4426-SAC-00001-MA-CHE'}"
What's the best way to manipulate this data so that I can extract just the part at the end: NS4426-SAC-00001-MA-CHE?
Has anyone else run into this issue?
------------------------------
Jeff Peterson
------------------------------
Question
Pipelines and JIRA
+11+11Solved by using the 'Apply Regex' pipeline using this expression:
([A-Z,0-9]{1,3}-[0-9]{1,5}-[A-Z]{1,2}-[A-Z]{1,3})
which results in this: SAC-00001-MA-CHE (exactly what I was needing)
Hope this helps someone else.
------------------------------
Jeff Peterson
------------------------------
([A-Z,0-9]{1,3}-[0-9]{1,5}-[A-Z]{1,2}-[A-Z]{1,3})
which results in this: SAC-00001-MA-CHE (exactly what I was needing)
Hope this helps someone else.
------------------------------
Jeff Peterson
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.