Support Questions
Find answers, ask questions, and share your expertise

Remove non breaking space from csv

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?

1 REPLY 1

Re: Remove non breaking space from csv

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