- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JSON Exraction specific key and value
- Labels:
-
Apache NiFi
Created on
‎09-09-2019
10:41 AM
- last edited on
‎09-09-2019
02:40 PM
by
ask_bill_brooks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
how can I extracttext specific key and value from json data ?
{
"key1" : "value1",
"key2" : "value2",
"key3" : "value3",
}
I would like to apply the extraxttext on Key2 and its value only.
Created on ‎09-09-2019 08:01 PM - edited ‎09-09-2019 08:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with this regex
(?:\"key2\"\\s*:\\s*)(.*?),
This will extract only the value of "key2" key i.e "value2"
-
if you don't need quotes to be extracted then use this regex
(?:\"key2\"\\s*:\\s*)"(.*?)",
This will extract only the value of "key2" key i.e value2
Created on ‎09-09-2019 08:01 PM - edited ‎09-09-2019 08:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with this regex
(?:\"key2\"\\s*:\\s*)(.*?),
This will extract only the value of "key2" key i.e "value2"
-
if you don't need quotes to be extracted then use this regex
(?:\"key2\"\\s*:\\s*)"(.*?)",
This will extract only the value of "key2" key i.e value2
Created ‎09-10-2019 07:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot!
