Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Designer - how to find a string and extract a value

Kpratt
5 - Atom

I have a string that has data for 8 categories.  In the example below, I want to extract the positionTitle field only

 

[{'positionId': '9065738', 'isPrimary': True, 'effectiveDate': '2022-07-15', 'startDate': '2014-08-12', 'employeeTypeId': 'EMP_TYPE_REG', 'employeeTypeName': 'Regular', 'positionTitle': 'Sr Business Systems Analyst', 'businessTitle': 'Sr Business Systems

 

The output I need is 

Sr Business Systems Analyst

 

Looking for advice on how to accomplish this.  Thank you.

2 REPLIES 2
DataNath
17 - Castor

Hey @Kpratt, how much variation can there be within each record, or are they always like the example you've provided? Something like this will work but if there's much scope for variation then we'll need more examples to provide a tailored solution:

 

DataNath_1-1666970577247.png

 

Edit: Also added a second option that uses string functions, once again providing that the different categories etc always show in the same order:

 

DataNath_0-1666970560900.png

Kpratt
5 - Atom

@DataNath   This is exactly what I need!  Thank you very much.  

The RegEx solution works perfectly.  Thanks again!

Labels