2008 Jun 27 6:39 AM
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?
2008 Jun 27 6:44 AM
Hi,
Try giving..
as ',' ' ' ',' ' ' into a variable
and at the end of the concatenate statement give
Respecting Space or separated by space.
Cheers,
Sai
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?
2008 Jun 27 6:42 AM
concatenate <f1> ',' <f2> into <f3> separated by SPACE.
Reward if useful.
2008 Jun 27 6:44 AM
Hi,
Try giving..
as ',' ' ' ',' ' ' into a variable
and at the end of the concatenate statement give
Respecting Space or separated by space.
Cheers,
Sai
2008 Jun 27 6:44 AM
Use separated by SPACE or
concatenate f1 space ',' space f2 into f3.
2008 Jun 27 6:45 AM
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.
2008 Jun 27 6:47 AM
hi,
try :
concatenate f1 f2 into f3 separated by ', '. "comma, followed by a space
Regards,
Subramanian
2008 Jun 27 6:50 AM
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.
2008 Jun 27 6:51 AM
2008 Jun 27 6:59 AM
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
2008 Jun 27 7:21 AM
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |