- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to remove ETX character from json value ?
- Labels:
-
Apache NiFi
Created ‎11-09-2022 06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I could not split a JSON due to a special ETX character existing in a JSON value, SplitJson processor returns an error that it is not a Valid JSON.
The JSON looks like that:
[ {"key_data":"val_data"},
{"key_data":"val_ETXdata"},
{"key_data":"val_data"},
{"key_data":"val_data"},... ]
I used The next regex expression to replace it but it doesn't work:
\x03(?=[^"]*")
Created ‎11-10-2022 12:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think everything works fine, the json flowfiles are the response of an invokeHttp request to an API, I receive more than 5000 flowfiles, each flowfile contains 200 records.
Problems happen only with 4 files that contain the ETX symbol.

- « Previous
-
- 1
- 2
- Next »