Cloudera Community
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community Blogs — Read the Announcement
Melodix
user rank
New Contributor

Re: Remove non breaking space from csv

by New Contributor in Support Questions
‎03-26-2021 04:39 AM
‎03-26-2021 04:39 AM
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 ... View more

Remove non breaking space from csv

by New Contributor in Support Questions
‎03-25-2021 05:05 AM
‎03-25-2021 05:05 AM
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? ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎02-10-2023 04:33 AM
Community Statistics
Member Since ‎03-25-2021 04:19 AM
Last Visited ‎02-10-2023 04:33 AM
Posts 3
Kudos received 1