Designer - how to find a string and extract a value

Question

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.

DataNath · Accepted Answer

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:

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