query

[Former Member]

hi guys,

I have a value like this abc def..

i want to find the space and repalce with * and then have to remove values after *

for eg:

abc def = abc*

james cam = james*

how can i do this?

regards

senthil

[former_member137336]

Hello,

Do onething.

Do split at space into two fields say field1 and a dummy field. Now take the field1 and concatenate * with that field to make your required field

Regards

Farzan

[Former Member]

solved..