Failed to notice the JSON is “minified” (compressed so it has no spaces) in the flow…
From: Bob Kuhfahl <rkuhf...@mitre.org> Reply-To: "users@nifi.apache.org" <users@nifi.apache.org> Date: Thursday, August 16, 2018 at 9:44 AM To: "users@nifi.apache.org" <users@nifi.apache.org> Subject: ReplaceText regex question I have to massage some JSON to pass into PutDatabaseRecord so I can insert the data into postgresql. Postgres wants the identifers to have double quotes and it seems the values need to have single quotes (for the strings). Sample JSON input: "producer_userid": "fdolomite", Search Value: (?<=\": )\"(.+)\" Replacement Value: '$1' I can get a small java program to use the above and replace the “ (double quotes) around the value to ‘ (single quotes) e.g.: "producer_userid": ‘fdolomite’, But… ReplaceText is not doing it. I’ve tried surrounding the search & replacement values in quotes (pretty sure that was not the problem, but heh). All I get in the log file is it moved the flow to success. From reading the source code for ReplaceText , it’s using the Java Pattern() and replaceAll() so I think my sample program is doing the same work, including matcher.find() So I must be missing something…