topic Re: Sorting Alfa Numeric Value in Application Development and Automation Discussions

Sorting Alfa Numeric Value

Former Member — Sat, 26 Sep 2009 07:19:52 GMT

Hi,

I want to sort PF account Number in ascending order.

I m using : SORT itab_final BY eepfn.

It is giving -

DL/15467/1073

DL/15467/1132

DL/15467/1134

DL/15467/115

DL/15467/118

DL/15467/16

I want to sort value after ' DL/15467/ '.

Kindly help me out.

Thanks

Re: Sorting Alfa Numeric Value

former_member194669 — Sat, 26 Sep 2009 07:28:22 GMT

Try this way

Create one more field say LEN in table itab_final.


loop at itab_final.
  itab_final-len   = strlen( eepfn ).
  modify itab_final.
endloop.
SORT itab_final BY len eepfn.

a®

Re: Sorting Alfa Numeric Value

Former Member — Sat, 26 Sep 2009 07:36:14 GMT

Hi Pooja

One thing you can do is to add an integer type field to you itab_final say nsort

Then


LOOP AT itab_final.
SPLIT itab_final-eepfn AT '/' INTO lv_dummy lv_dummy itab_final-nsort.
"maybe here you could a TRANSLATE stattement too but I'm not very sure how to use that
MODIFY itab_final INDEX sy-tabix.
ENDLOOP.

SORT itab_final BY nsort.

Pushpraj

Re: Sorting Alfa Numeric Value

Former Member — Sat, 26 Sep 2009 07:53:20 GMT

Thanks a lot.