topic Re: concatenate question? in Application Development and Automation Discussions

concatenate question?

vsubbakrishna — Fri, 05 Jan 2007 16:27:43 GMT

existing data:

i_input_name( with only one field) contains 4 records

name1

name2

name3

name4

desired output should be a single line separated by ',' into another itab2-result_line

ie itab2-result_line = name1,name2,name3,name4

thanks,

subba

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 16:31:48 GMT

CONCATENATE NAME1 NAME2 NAME3 NAME4 INTO ITAB2-RESULT SEPARATED BY ','.

Max

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 16:32:02 GMT

Hello,

data: lv_text type string.

LOOP AT ITAB.

CONATENATE LV_TEXT ITAB-FIELD1 into LV_TEXT separeted by ','.

ENDLOOP:

If useful reward.

Vasanth

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 16:32:44 GMT

hi,

Try this...........

DATA : BEGIN OF itab OCCURS 0,

name TYPE string,

END OF itab.

DATA result TYPE string.

itab-name = '1'.

APPEND itab.

itab-name = '2'.

APPEND itab.

itab-name = '3'.

APPEND itab.

itab-name = '4'.

APPEND itab.

LOOP AT itab.

IF sy-tabix = 1.

CONCATENATE result itab-name INTO result.

ELSE.

CONCATENATE result itab-name INTO result SEPARATED BY ','.

ENDIF.

ENDLOOP.

WRITE result.

Regards

Re: concatenate question?

RichHeilman — Fri, 05 Jan 2007 16:33:24 GMT

Loop at your internal table and check if the first record, if so, then simply move the value to RESULT, if not then concatenate the value with RESULT and seperate it with ','. See below.

Loop at i_input_name.

   if sy-tabix = 1.
      result = i_input_name-field.
  else.

 concatenate result i_input_name-field into result seperated by ','.
endif.

endloop.

write:/ result.

Regards,

Rich Heilman

Message was edited by:

Rich Heilman

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 17:29:46 GMT

Please try this,


DATA: v_string TYPE string.
CONCATENATE LINES OF i_scarr INTO v_string SEPARATED BY ','.
WRITE:/ v_string.
* you can replace the v_string with your required internal table field

Regards

Kathirvel

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 17:42:03 GMT

loop at i_input_name.

concatenate v_str i_input_name-<field> into v_str separated by ','.

endloop.

to remove ',' at the end.

v_strlen = strlen(v_str).

v_str = v_str+0(v_strlen).

Re: concatenate question?

Former Member — Fri, 05 Jan 2007 17:53:43 GMT

data : V_name type string.

loop at i_input_name.
 concatenate v_name i_input_name. separated by ','.
endloop.

v_len = strlen( v_name ). :  "to remove last comma
v_len = v_len - 1.
v_name = v_name+0(v_len).

Re: concatenate question?

vsubbakrishna — Mon, 08 Jan 2007 07:18:50 GMT

problem solved........pts assigned...

subba

Re: concatenate question?

vsubbakrishna — Mon, 08 Jan 2007 07:19:17 GMT

answered

Re: concatenate question?

Former Member — Mon, 08 Jan 2007 09:43:24 GMT

assign a variable name type string

concatenate name1 name2 name3 name4 into name.

bye