DSXchange

I have couple of char columns in source which are concatenated in source stage. So in next stage I have a transformer where the result data type is changed from char to varchar.
Next there is one more transformer, where this varchar result column has inbetween spaces, how to remove these inbetween space?

StripWhiteSpace function in transformer

or CompactWhiteSpace try this

"inbetween spaces"? Pretty vague.

How about some before and after examples so we have some confidence that the right question is being answered.