topic Re: Sort internal table on name (case sensitive sort) in Application Development and Automation Discussions

Sort internal table on name (case sensitive sort)

Former Member — Thu, 16 Apr 2009 14:21:21 GMT

Hi Experts,

I want to sort my internal table by a certain field, but without it taken in account lower- or upper-case.

Let's say I have the following list:

- Abe

- celine

- bart

- Zorro

- Bambi

I do this in my code:

SORT it_names BY name

The result:

- Abe

- Bambi

- Zorro

- bart

- celine

How do I get the following result?

- Abe

- Bambi

- bart

- celine

- Zorro

Former Member — Thu, 16 Apr 2009 14:26:20 GMT

Hi,

try below

loop at it_names into wa_name.
translate wa_name-name to lowercase..
append wa_name to it_names_final.
endloop.

then try to sort it_names_final by names.

now table it_names_final will sort out correctly.

Former Member — Thu, 16 Apr 2009 14:31:34 GMT

But then I don't get the original name (?)

Former Member — Thu, 16 Apr 2009 14:47:20 GMT

I added a new field to the internal table where I put the name in upper case and sorted on this...