Delta Processing using change capture

reddy.cba · Post by **reddy.cba** » Tue Jun 26, 2007 3:35 am

Is there any Trim Function in R 7.5 enterprise edition to trim the Blank spaces in between two words.
Like if souce is 'vamshi mohan' can i get it as vamshi mohan.
Removing more than one spaces in between.
In the document it states we can use trail R function but this function is not available in the r 7.5 edition.
ANy idea how we can remove the spaces?
Thanks
Reddy

kumar_s · Post by **kumar_s** » Tue Jun 26, 2007 3:50 am

Hi Reddy,
But the example that you gave as input and out is same,

Like if souce is 'vamshi mohan' can i get it as vamshi mohan.

Do you mean to say, you need to get output as 'vamshimohan'?

reddy.cba · Post by **reddy.cba** » Tue Jun 26, 2007 6:00 am

Typo again..
WHen Input is Vamshi mohan , output should be vamshimohan.
Thanks
Vee Yes,

kris007 · Post by **kris007** » Tue Jun 26, 2007 6:11 am

You can remove all the occurences of a character as follows:

Code: Select all

Trim (Input.Column," ", "A" )

ray.wurlod · Post by **ray.wurlod** » Tue Jun 26, 2007 6:32 am

... or, slightly more efficiently,

Code: Select all

Convert(" ", "", InLink.TheString)