For example:
=select([{"name":"Drew","age":30,"gender":"male"},{"name":"Michelle","age":31,"gender":"female"}],"name")
would return
["Drew","Michelle"]
using key name of age would give
[30,31]
data=[{"name":"Drew","age":30,"gender":"male"},{"name":"Michelle","age":31,"gender":"female"}]
=findAll(jsonEncode(data,"(?<=\"name\":\")[^\"]*(?=\")")
["Drew","Michelle"]
=findAll(jsonEncode(data,"(?<=\"age\":)[^,\\}]*(?=[,\\}])")
=findAll(jsonEncode(data,"(?<=\"age\":)\\d+")
["30","31"]