Custom field returning a string of values

[FrankatMSC]

I have a scenario that is returning a users name from a requests custom field.  On my form it stores just the name but the search module returns the string below.  I've looked at all the function Fusion offers but I can't see one that would allow me to parse just the ID. "
I've tried using variations of substring and spit.  Do I need to somehow store it in an array first?  Any suggestions will be greatly appreciated!1

        "value": [
            "{\"objCode\":\"USER\"",
            "\"name\":\"Kelly Powell\"",
            "\"ID\":\"61252bb0000eb57eae6652713ab41b15\"}"
        ]
   

[KristenS_WF · Accepted solution]

Try passing the value to a Parse JSON module.  All 3 of the items in your string would be text types in the data structure.  Once parsed, you should be able select the items individually.

[FrankatMSC]

Thank you @KristenS_WF .  That was such a clean solution.  Here I was trying all mixes of functions trying to parse it, not realizing it was JSON.
I love how I learn something new about Fusion nearly everyday!!

Thanks again!!

[KristenS_WF]

Happy to help!