Splitting and sorting

[Former Member]

hi,

I have a text file which i have put into a data container. The text file has details llke,

INFTY SUBTY COUNTRYCODE PERNR E-MAIL

0105 2 CA 000000006 xyz@yahoo.com

0105 2 CA 000000004 xyz@yahoo.com

0105 2 CA 000000001 xyz@yahoo.com

in my data container it will be like this,

INFTY#SUBTY#COUNTRYCODE#PERNR#EMAIL

0105#2#CA#000000006#xyz@yahoo.com

0105#2#CA#000000004#xyz@yahoo.com

0105#2#CA#000000001#xyz@yahoo.com

I need to find the position of the pernr and do the other process.i found out the position of the pernr using the split command.Is there any command to get data of a particular column (for example 4th position(column) here)

in the datacontainer.I need to take the first record pernr and second record pernr and compare.So i need to get the pernr values. Also Is there any possibility to sort the contents in the data container.

please help me out with this,

Thanks in advance,

[former_member156446]

hi

  loop at itab into wa_1 index '1' transporting no fields.

  read table itab into wa_2 index '2'. " <<check the syntax

       if sy-subrc eq 0.

       you code for comparison..

       endif. 

endloop.
endloop.

or 


loop at itab into wa_1 index '1' transporting no fields.

loop at itab into wa_2 index '2' transporting no fields.

       if sy-subrc eq 0.

       you code for comparison..

       endif. 

endloop.
endloop.