Page 1 of 1
how to elimanitate space
Posted: Thu Mar 16, 2006 10:43 pm
by suneel kumar
Hi,
in the source date like "suneel reddi" but i want output like "suneelreddi"
pls give me sucessions.
thanks in advance
suneel
Posted: Thu Mar 16, 2006 11:02 pm
by balajisr
You can use EReplace function to eliminate space.
--Balaji S.R
Posted: Thu Mar 16, 2006 11:07 pm
by balajisr
should work fine.
--Balaji S.R
Posted: Thu Mar 16, 2006 11:08 pm
by rasi
Suneel
As Balaji mentioned you can use Ereplace function to replace space.
Syntax:
Ereplace(InputValue,' ','')
Example
Ereplace('suneel reddi',' ','')
Result : suneelreddi
Regards
Thanks Balaji
Posted: Thu Mar 16, 2006 11:29 pm
by suneel kumar
rasi wrote:Suneel
As Balaji mentioned you can use Ereplace function to replace space.
Syntax:
Ereplace(InputValue,' ','')
Example
Ereplace('suneel reddi',' ','')
Result : suneelreddi
Regards
Posted: Fri Mar 17, 2006 1:57 am
by ArndW
Use the convert function to remove all spaces, i.e.
. It will only convert one char to another so is more limited than EREPLACE, but it is more efficient.
Posted: Mon Mar 20, 2006 7:59 am
by srimitta
Suneel,
"suneel reddi" = Trim("Remove..all..Spaces....", " ", "A")
* ...returns "suneelreddi"
Trim("suneel reddi"," ","A") Returns "suneelreddi"
Goodluck
Mitta
Posted: Mon Mar 20, 2006 8:09 am
by DSguru2B
OR
you could just use the transform functioni "LETTERS()"
eg LETTERS(suneel reddi) is going to return you "suneelreddi"
Cheers