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.
Solved! Go to Solution.
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:
@DataNath This is exactly what I need! Thank you very much.
The RegEx solution works perfectly. Thanks again!