Support Questions

Find answers, ask questions, and share your expertise

Remove non breaking space from csv

avatar
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

avatar
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