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
Delta Processing using change capture
Moderators: chulett, rschirm, roy
Delta Processing using change capture
Man Has Created Money...Its not Money which has created Man....
You can remove all the occurences of a character as follows:
Code: Select all
Trim (Input.Column," ", "A" )
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... or, slightly more efficiently,
Code: Select all
Convert(" ", "", InLink.TheString)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.