trim space that appears in between the column value populate

[Svengiyil]

Hi,

I need to remove the space which comes in between a column value.
For ex if the value is "abc def", I should populate this value as "abcdef".

How do I achieve this?

Thank you,
Svengiyil

[priyadarshikunal]

Code: Select all

trim(<column>,' ','A')

[ray.wurlod]

Code: Select all

Convert(" ", "", InLink.ColumnName)

[Svengiyil]

Thanks a ton Ray and Priyadarshi....It worked.

[abhijain]

Please mark this thread as Resolved using the green button at the top of the page.