Support Questions

Find answers, ask questions, and share your expertise

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

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.