Question Replicator rdbms character NUL not recognised

Hello,
I have a .txt file that contains the character NUL => \0 (see in attechements).
And when using the replicator rdbms it gave me the error below.

Hi,
Apparently the message is raised by Postgresql, UTF-8 does not like NUL chars.
What is your question? You want to ignore these characters? Or you want to integrate them into your Postgresql db?

Hi,
Yes, my question is how to ignore those characters?

I would add a "Transformation Line" scripting in the file's Metadata for replacing every NUL char with an empty string ''.
- In the File's properties, go into the Transformation tab
- Add this Script in the Line section:- Set the Language to: rhino

=> make sure your mapping is using Load File to Rdbms (not the Postgres with Copy), so that Stambia's File Driver is used and applies the above script.

Note: the above solution works well but as always, undesired characters should be removed at the data source - if possible.

Hi,
Thank you my replicator run whithout an error but it didn't insert any line, so I went to consult the data of my file in the metadata and then I got the error :NullPointerexception:null

Note: I'm using just a replicator in a process, there is no mapping in it.

Can you share an Export models and dependencies of the process + the sample data file?
You can send these elements in a support ticket if you prefer.

Okay

Hello,
Thank you Thomas BLETON the script you gave me finally worked well.