how to elimanitate space

[suneel kumar]

Hi,

in the source date like "suneel reddi" but i want output like "suneelreddi"

pls give me sucessions.

thanks in advance

suneel

[balajisr]

You can use EReplace function to eliminate space.

--Balaji S.R

[balajisr]

Code: Select all

str = EReplace(str," ","")

should work fine.

--Balaji S.R

[rasi]

Suneel

As Balaji mentioned you can use Ereplace function to replace space.

Syntax:
Ereplace(InputValue,' ','')

Example
Ereplace('suneel reddi',' ','')

Result : suneelreddi


Regards

[suneel kumar]

Suneel

As Balaji mentioned you can use Ereplace function to replace space.

Syntax:
Ereplace(InputValue,' ','')

Example
Ereplace('suneel reddi',' ','')

Result : suneelreddi


Regards

[ArndW]

Use the convert function to remove all spaces, i.e.

Code: Select all

Convert(' ','',In.Col)

. It will only convert one char to another so is more limited than EREPLACE, but it is more efficient.

[srimitta]

Suneel,

"suneel reddi" = Trim("Remove..all..Spaces....", " ", "A")
* ...returns "suneelreddi"


Trim("suneel reddi"," ","A") Returns "suneelreddi"

Goodluck
Mitta

[DSguru2B]

OR
you could just use the transform functioni "LETTERS()"

eg LETTERS(suneel reddi) is going to return you "suneelreddi"

Cheers