topic Re: query in Application Development and Automation Discussions

query

Former Member — Thu, 21 Feb 2008 12:55:36 GMT

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 — Thu, 21 Feb 2008 13:02:16 GMT

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 — Thu, 21 Feb 2008 13:12:57 GMT

solved..