topic Re: processing string-- still having problem in Application Development and Automation Discussions

processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:29:12 GMT

Hi,

i need to remove all spaces in a string immediately after ',' but not all .

for eg :

name = first, middle last

after processing it should appear as

first,middle last.

replace ', ' with ',' into name ...doesn't seems to be working. is there any way to do that in a single statement.

your help would be appreciated.

Thanks,

Kranthi.

Message was edited by: kranthi kumar

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:38:44 GMT

it worked for me... see below code

data : name(40).

name = 'first, middle last'.

replace ', ' with ',' into name.

write : name.

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:43:47 GMT

Hi Kranthi,

try this....

REPLACE FIRST OCCURRENCE OF '' IN name WITH ','.

REPLACE FIRST OCCURRENCE OF ',,' IN name WITH ','.

reagrds

vijay

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:44:21 GMT

data: l_str type string.

l_str = 'First , Middle Last'.

write:/ l_str.

replace ' , ' with ',' into l_str.

write:/ l_str.

Output:

First , Middle Last

First,Middle Last

<u>worked for me too.</u>

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:44:53 GMT

Hi,

for helful answers please reward .

thanks

vijay

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:47:48 GMT

Thanks all for your response.

however, if there is MORE than one SPACE after COMMA it doesn't work ,could you let me know more feasible solution

Thanks,

Kranthi.

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:52:15 GMT

I think You requirement will not allow you to use condense.

so i will find some thing...

vijay

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 16:54:41 GMT

use the CONDENSE command

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 17:01:00 GMT

Condense is not working...but i need to remove spaces Immediately after ','

Thanks,

Kranthi.

Message was edited by: kranthi kumar

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 17:04:27 GMT

CONDENSE NO-GAPS will remove all spaces, but just CONDENSE will remove all but one spaces.

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 17:06:42 GMT

data : w_str1(40),

w_str2 like name.

split name at ',' into w_str1 w_str2.

shift w_str2 left deleting leading space.

concatenate w_str1 ',' w_str2 into name.

Re: processing string-- still having problem

Former Member — Thu, 01 Dec 2005 17:14:03 GMT

Hi Kranthi,

Try to use the below code.

data: test(15),

test1(10),

test2(10).

test = 'first, last'.

split test at ',' into test1 test2.

condense test2.

concatenate test1 ',' test2 into test.

write:/ test .