topic Re: Blank Fields while concatenating in Application Development and Automation Discussions

Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 06:17:32 GMT

Hi all,

I have a requirement wherein I have to concatenate some fields to get my new concatenated field.There are some blank records in the table i m taking data from.say like this

Columns: A B C D

DATA: 23 bhd g56

Column C is blank in this case n I want to concatenate A,B,C and D seperated by '-'

Now after concatenation output is 23-bhd--g56

I dnt want hyphen to cm for blank fields aswell

sud cm like this 2-bhd-g56

Is it possible?

Re: Blank Fields while concatenating

former_member210123 — Mon, 31 Mar 2008 06:22:11 GMT

add this statement after concatenate.

REPLACE ALL OCCURRENCES OF '--' IN:

text1 WITH '-'.

This will solve your problem.

Re: Blank Fields while concatenating

asik_shameem — Mon, 31 Mar 2008 06:23:35 GMT

Hi,

before concatenating, check c is initial or not.

IF NOT c IS INITIAL.
  CONCATENATE A B C D INTO NEW SEPARATED BY '-'.
ELSE.
    CONCATENATE A B D INTO NEW SEPARATED BY '-'.
ENDIF.

Re: Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 06:25:26 GMT

Hi Bharath,

This will work if there is only one fields missing but wat if we two missing filds in continuation?

Re: Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 06:25:36 GMT

Hi deepika...

Write the below code..

if a = space.

then do..

concatenate b '-' c '-' d .

endif.

if b = space.

then do..

concatenate a '-' c '-' d .

endif.

if c = space.

then do..

concatenate a '-'b '-' d .

endif.

if d = space.

then do..

concatenate a '-' b '-' c.

endif.

reward points always gives motivation....

Re: Blank Fields while concatenating

former_member210123 — Mon, 31 Mar 2008 06:32:46 GMT

REPLACE ALL OCCURRENCES OF '--*' IN:

text1 WITH '-'

This will work.

Re: Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 06:36:38 GMT

After replace occurences statement use

CONDENSE text NO-GAPS.

Re: Blank Fields while concatenating

former_member156446 — Mon, 31 Mar 2008 06:39:32 GMT

Hi Deepika if you ABCD are the coulmns of internal table

you can use the code below:


LOOP AT p_final_table ASSIGNING <fs_record>.
DO.
ASSIGN COMPONENT sy-index OF STRUCTURE <fs_record> TO <fs_comp>.
IF sy-subrc <> 0.
EXIT.
ENDIF.
lf_buf = <fs_comp>.
CLEAR lf_buf.
ENDDO.
if not A is initial and not B is initial and not C is initial  "<<<<<< look
CONCATENATE lf_line co_line_feed INTO lf_line sperated by '-'.

hope its helpful...

Edited by: Jackandjay on Mar 31, 2008 2:41 AM

Re: Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 06:45:47 GMT

It is working fine for previous replace code.but if i give '--*' it is not working for any of them

Re: Blank Fields while concatenating

asik_shameem — Mon, 31 Mar 2008 07:25:26 GMT

Hi,

Hope it will solve yer prob.

while sy-subrc = 0.

REPLACE ALL OCCURRENCES OF '--' IN text WITH '-'.

endwhile.

Re: Blank Fields while concatenating

Former Member — Mon, 31 Mar 2008 07:37:57 GMT

Thanx Shameem,it worked:)

one silly question- wat exactly sy-subrc does?

Re: Blank Fields while concatenating

asik_shameem — Mon, 31 Mar 2008 08:01:00 GMT

Hi,

It checks whether expression or statement or condition is successful or not

Return value set by the following ABAP statements. In general, a content of 0 means that the statement was executed without problems.