Substring a field inside of an array?
I’m trying to substring the field $studySiteChecklist.checklist.lastUpdateDate but I can get it to keep the same output as the input.
Any ideas?
[{
"country": "a",
"studySiteChecklist": {
"c...
Forum Discussion
I think @tlikarish suggestion is a good one. Another option would be is to use the map method that is available within an array object. If you want to conditionally update elements in the array you can use the if condition within the update expression of the map method.
I have tried mapping already with the following.
jsonPath($, “$studySiteChecklist.checklist[*].lastUpdateDate”).map(x => x.substr(0,10)).toString()
But I got the follwing which is not correct.
Thank you for the suggestion
Bill
