Sort by string

[Former Member]

Hi,

Can we sort internal table by some string? I mean If we have materials, need to sort that by string 'R' (materials starts with 'R'). Can we do this using sort statement?

Thanks,

Sudha

[Former Member]

hi,

If you need the fields specifically start with 'R' ...do this way ...

loop at itab.
  if itab-field1+0(1)  = 'R' or
  itab-field1+0(1)  = 'r'.
    itab-field2 = 'X'.
  endif.
  modify itab index sy-tabix transporting field2. 
endloop.

sort itab by field2. 

Regards,

Santosh

[Former Member]

Hi,

When you sort the ITAB, it will internally sorted on the field you specify, you cannot sort by first character, second character...etc of the field in the internal table.

[Former Member]

Thanks Ravi.

[Former Member]

hi,

If you need the fields specifically start with 'R' ...do this way ...

loop at itab.
  if itab-field1+0(1)  = 'R' or
  itab-field1+0(1)  = 'r'.
    itab-field2 = 'X'.
  endif.
  modify itab index sy-tabix transporting field2. 
endloop.

sort itab by field2. 

Regards,

Santosh