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(?=[^"]*")
also
[\x03](?=[^"]*")
can someone show me a trick to remove it please, I would appreciate it.