Hello all,
I am trying to extract just the ‘asdfasdf’ value from the following sample array:
[{“description”:“Blocked”,“folderCount”:0,“id”:”asdfasdf,”parentId”:”qwerqwer,”source”:“cloud”,“userCount”:1234}]
If someone could provide a guidance, that would be greatly appreciated.
Try a Pattern Parse step with this regex
parentId\”:\”{{parentId:/[^,]+/}}
Uncheck multiple
You might need to modify the pattern to meet your needs
Did grep to display the id section, then split it with string operation with the delimiter of ‘:’ and accessed the [1] of the list. However, the output still contains ’ " ’ (no spaces) in the beginning and ’ ""] ’ in the end.
Failed to get rid of them using awk plugin with the following expression:
{ gsub(/\"/, “”); gsub(/"]$/, “”); print }
If you’re still trying to figure this out, try using this expression and see if it gives you what you want.
“id":"([^"]+)”
Thank you.