About chris_ruegger

chris_ruegger · ‎02-18-2018

@Shu Thanks very much, both of those solutions worked. Question: When using the ExtractText processor, how can I account for whitespace between the colon : and the actual ID string? This does not seem to work: "ID":(\w+)(.*?), If the start of my string is: {"ID": 12345, and I want to get the value 12345 Thanks!

chris_ruegger · ‎02-17-2018

I'm using the NIFI ExtractText Processor and I'm trying to come up with the regular expression to extract a field value from a JSON String. Sample JSON Data is: {"ID": 10649, "ORDER_ID": 85, "PRODUCT_ID": "JT8382X38", "CUSTOMER_ID": 57, "QUANTITY": 2, "ORDER_DATE": "2018-02-17 11:09:56.217", "REGION": "Far East", "NOTES": "Repeat Purchase", "AMOUNT": "7997.48", "STATUS": 105} I want to extract the ID field value (10649). What would be a valid regular expression to get this value? Thanks!

Online	Offline
Last Visited	‎02-18-2018 11:21 AM

Member Since	‎02-17-2018 07:04 PM
Last Visited	‎02-18-2018 11:21 AM
Posts	2
Kudos received	1

Cloudera Community

Re: NIFI extract text from JSON

NIFI extract text from JSON