How sort internal table with punctuation on non unicode system?

[Former Member]

Hi

We have a system with NON UNICODE. I would like sort internal table using Sort method.

When I use:

Sort itab By nachn Ascending. ""system sort by not with puntuation

e.g. when I have A, C, Č, B, Z,

System sort like that:

A, B, C, Z, Č,

But correct is:

A, B, C, Č, Z,

Thank you

[former_member1716]

Hi,

I would suggest you to convert the UNICODE to ASCII values and then try to sort. Hope this will work.

Regards,

Satish

[former_member1716]

This FM  URL_ASCII_CODE_GET Will give you the ASCII value for any character.

Regards,

Satish

[Former Member]

Hi

Thank you for your answer.

When I check FM URL_ASCII_CODE_GET and I put char I give this result.

A = 41

C = 43

Č = C8

Z = 5A

B = 42

When I sort by Ascii value, still I get wrong result, because Č(C8) is greater like Z(5A).

Or I doing something wrong?

Thank you

[former_member1716]

Why dont you try to convert the character to Binary and then sort.

[Former Member]

Hi

When I use SORT "AS TEXT", this works.

Thank you

[Tomas_Buryanek]

Try addition SORT ... AS TEXT. It works for me, but it depends on "locale text environment" (ABAP keyword documentation for more details):

Character-like components are sorted by default by their binary representation (code page). Textual sorting of character-like components can be performed using the addition AS TEXT.

[Former Member]

Hi

Thank for you answer. I have a mistake in Sort sxpression.

SORT itab BY NACHN VORNA ASCENDING AS TEXT ICON ASCENDING. ""sort not correctly

SORT itab BY NACHN ASCENDING AS TEXT VORNA ASCENDING AS TEXT ICON ASCENDING. ""sort correctly

Thank you