String comparison while reading internal table

[Former Member]

Hi All,

I have an internal table which has consolidated records from several tables.

Now I want to READ only those records where the coloumn : OBJNR starts with ZZ.

Now, we cannot use LIKE 'ZZ*' in READ statements like we can use in SELECT statements.

Other option for me is using offset.

READ t_itab into w_itab.

     if w_itab-objnr+0(2) eq 'ZZ'.

something like this.

IS there any other better way?

REgards,

Faiz

[Former Member]

This will fetch all those records which contain the substring 'ZZ' at any position in the string.In my case it should be right at the beginning .I will try 'ZZ*' .

[ramakrishnappa]

Hi,

Use LOOP & CP ( contains pattern ) statements as below

LOOP AT t_tab INTO w_itab WHERE objnr CP  'ZZ*'.

" Here you can collect into other internal table, or exit if u need only 1 record

ENDLOOP.

Hope this helps you.

Regards,

Rama

[Former Member]

This will fetch all those records which contain the substring 'ZZ' at any position in the string.In my case it should be right at the beginning .I will try 'ZZ*' .

[ramakrishnappa]

Hi,

as suggested in my previous reply, it gets you all records which starts from ZZ......

Example:

let us say internal table is having records as below

ZZ123

ZX123

ZY123

ZZ222

ZX222

ZY222

Now,

LOOP AT t_tab INTO w_itab WHERE objnr CP  'ZZ*'.

" we get only ZZ123 & ZZ222

ENDLOOP

.

Regards,

Rama

[Former Member]

Hi  , thanks for your answer, but i have a doubt ..  what will happen if suppose column name is AAZZBBC? , it will consider it or not ? can you clarify me please?

[ramakrishnappa]

Hi Karthi,

Karthi Mrvk wrote:

what will happen if suppose column name is AAZZBBC? , it will consider it or not ? can you clarify me please?

Well, if your column contains a value AAZZBBC, it will not consider this record as we are looking for only ZZ*....

To consider your value we need to be like this AA* or *ZZ*

Regards,

Rama

[matt]

Why not write a test program and see what happens?

[arivazhagan_sivasamy]

Hi Faizur,

LOOP AT t_tab INTO w_itab WHERE objnr CP  'ZZ*'  from 1 to 1.

endloop.

Now you will get only one record.

Arivazhagan S

[matt]

WRONG FOR TWO REASONS!

1. The syntax should be LOOP AT t_tab INTO w_itab FROM 1 TO 1 WHERE objnr CP 'ZZ*'.

2. Unless the first record begins ZZ, you'll get nothing.

[RaymondGiuseppi]

You could use a READ TABLE on partial value (here ZZ) and then a LOOP, exit when no longer leading 'ZZ'. (cf. attached sample) you will be required to use a sorted type table or to sort the table to use a binary-search implicitly or explicitly.

Regards,

Raymond

[Former Member]

hi Faizur,

LOOP t_itab into w_itab.

  FIND ALL OOCUREENCES OF REGEX 'ZZ*'

          IN w_itab-objnr

          MATCH OFFSET moff.

  if moff eq 0.

  .....

ENDLOOP.

Another way is move all objnr data to it_itab that only have one field 'OBJNR'.

FIND ALL OOCURRENCES OF REGEX 'ZZ*'

        IN TABLE it_itab

        RESULTS result_tab.

the result_tab is what you wanted, which start will 'ZZ'.

regards,

Archer

[ThangaPrakash]

Use CP (Contains pattern)