Remove non breaking space from csv

[#1]

Hey all,

I'm currently using the following processor chain to read a csv and load the data into a postgres table.

ListFile -> FetchFile -> QueryRecord -> Split Record -> PutDatabaseRecord

Some of my data points have a non-breaking space before or after the information. I tried using trim and replace in the QueryRecord processor, but it didn't remove the space.

Any ideas how I could get rid of this type of space?

[#2]

I solved this issue by creating a custom processor that removes '/u00A0' from the content of the flowfile.

This works, but is probably not the ideal solution. It would be great if someone has ideas how to fix this in a more intuitive way