topic Re: CONCATENATE in Application Development and Automation Discussions

CONCATENATE

Former Member — Fri, 27 Jun 2008 05:39:59 GMT

i have concatenated strings with comma.

but i want a space to be inserted after each comma

how is it possible to insert space after comma?

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:42:54 GMT

concatenate <f1> ',' <f2> into <f3> separated by SPACE.

Reward if useful.

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:44:23 GMT

Hi,

Try giving..

as ',' ' ' ',' ' ' into a variable

and at the end of the concatenate statement give

Respecting Space or separated by space.

Cheers,

Sai

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:44:33 GMT

Use separated by SPACE or

concatenate f1 space ',' space f2 into f3.

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:45:13 GMT

hi silpa,

You can do like that :

concatenate VAR1 ',' VAR2 into VAR3 separated by SPACE.

I hope this will help you.

Help children of U.N World Food Program by rewarding points and encourage others to answer your queries.

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:47:01 GMT

hi,

try :

concatenate f1 f2 into f3 separated by ', '. "comma, followed by a space

Regards,

Subramanian

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:50:15 GMT

Hi,

it can be done like dis...



DATA line TYPE char80 VALUE 'hi,hello,welcome'.

WRITE line.

REPLACE ALL OCCURRENCES OF ',' IN line WITH ',|'.

TRANSLATE line USING '| '.

WRITE line.

Cheers,

Jose.

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:51:35 GMT

Use Addition

Separated by space

along with the concatenate.

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 05:59:47 GMT

Hi Silpa,

You can use the keyword SEPERATED BY SPACE.

Concatenate string1 ',' string2 into string3 seperated by space.

But here we get space between string1 and ',' also.

Inorder to avoid that, do this way.

Concatenate string1 ',' into string1.

Concatenate string1 string2 into string3 seperated by space.

Hope this helps you.

Any queries, get back to me.

Regards,

Chandra Sekhar

Re: CONCATENATE

Former Member — Fri, 27 Jun 2008 06:21:32 GMT

Thank you for all the replies.