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?