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?
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