topic Re: Find duplicate words in string. in Application Development and Automation Discussions

Find duplicate words in string.

Former Member — Wed, 12 Dec 2018 06:17:17 GMT

Hello.

For example, I have a string

my string = 'morning day evening day hello age day morning'

I need to write words that occurs more than 1 time. So for this example answer is:

morning, day

How can I solve this in abap?

Firstly I split string into table.

DATA itab TYPE TABLE OF string.
SPLIT my_string AT SPACE INTO itab.

So I have table itab with my words.

Now I need to select rows that dont repeat.

In SQL its easy to use

select * from itab groupby field_name having count(*) > 1

But how can I do that in ABAP?

Re: Find duplicate words in string.

DoanManhQuynh — Wed, 12 Dec 2018 06:50:42 GMT

you can loop at group by and get the size of group, if it > 1 then it duplicate text.

Re: Find duplicate words in string.

Former Member — Wed, 12 Dec 2018 08:24:37 GMT

how to loop at group by at abap?

Re: Find duplicate words in string.

Muthu_raja — Wed, 12 Dec 2018 08:41:29 GMT

itab1[] = itab[].
Loop at itab assigning <fs_data>.
Read table itab1 assigning <fs_data1> with key table line eq <fs_data>.
if ( sy-subrc eq 0 ).
   write :/ <fs_data1>.
endif.
Endloop.

Re: Find duplicate words in string.

Patrick_vN — Wed, 12 Dec 2018 10:12:16 GMT

Check the abap docu: https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abaploop_at_group.htm

Re: Find duplicate words in string.

matt — Wed, 12 Dec 2018 12:25:41 GMT

You know that's the link to this question... Not massively helpful, I feel.

Re: Find duplicate words in string.

s1252 — Wed, 12 Dec 2018 16:04:09 GMT

Refer http://zevolving.com/2015/10/abap-740-loop-at-with-group-by/

Re: Find duplicate words in string.

DoanManhQuynh — Thu, 13 Dec 2018 00:06:24 GMT

look at demo package in sap or simply F1 help on statement LOOP AT GROUP.

Re: Find duplicate words in string.

Former Member — Fri, 21 Dec 2018 08:38:04 GMT

Hi,

I prefer to use alternative internal table to store the count.

very simple is:

data MY_STRING type STRING value 'morning day evening day hello age day morning'.
data ITAB type table of STRING.

data: begin of ITAB2 occurs 0,
        WORDS type STRING,
        COUNT type INT4,
      end of ITAB2.

refresh ITAB.
split MY_STRING at SPACE into table ITAB.

"Counting duplicated words
refresh itab2.
loop at ITAB into data(LS_ITAB).
  clear itab2.
  ITAB2-WORDS = LS_ITAB.
  ITAB2-COUNT = 1.
  collect ITAB2.
endloop. 

"Read or loop with itab2 with condition
loop at ITAB2 where COUNT > 1.
  write: / ITAB2-WORDS, ITAB2-COUNT.
endloop.

Regards,

Nam

Re: Find duplicate words in string.

matt — Fri, 21 Dec 2018 11:05:26 GMT

For best efficency, ITAB2 should be a HASHED table.

Re: Find duplicate words in string.

Former Member — Mon, 24 Dec 2018 02:12:34 GMT

Thanks Matthew for pointing it out.