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?
trim space or blank in between
Moderators: chulett, rschirm, roy
Re: trim space or blank in between
StripWhiteSpace function in transformer
or CompactWhiteSpace try this
or CompactWhiteSpace try this