DSXchange • how to remove all spaces in a string

Page 1 of 1

how to remove all spaces in a string

Posted: Fri Aug 20, 2010 4:27 am

by nani0907

how to remove all spaces in a string

example: jhon is good

i need out put as jhonisgood

Posted: Fri Aug 20, 2010 5:15 am

by ArndW

Code: Select all

CONVERT(' ','',In.ColumnName)

Code: Select all

TRIM(In.ColumnName,' ','A')

Posted: Fri Aug 20, 2010 4:42 pm

by ray.wurlod

StripWhiteSpace(InLink.TheString)

This one is more "self documenting" than the others.