topic Re: Sort by string in Application Development and Automation Discussions

Sort by string

Former Member — Thu, 10 Jul 2008 12:53:26 GMT

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

Re: Sort by string

Former Member — Thu, 10 Jul 2008 12:56:03 GMT

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.

Re: Sort by string

Former Member — Thu, 10 Jul 2008 12:57:12 GMT

Thanks Ravi.

Re: Sort by string

Former Member — Thu, 10 Jul 2008 13:10:24 GMT

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