Support Questions

Find answers, ask questions, and share your expertise
Celebrating as our community reaches 100,000 members! Thank you!

Remove non breaking space from csv

New Contributor

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?


New Contributor

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