Skip to Content
0
Former Member
Nov 17, 2005 at 01:59 PM

sort a file by a field of a line

22 Views

Hi all,

I need to sort a file by a field of a line. An example :

I have the csv file:

field1;field2;field3

1;2;3

7;3;1

4;1;2

and i must sort these lines using the field2. So the result is:

field1;field2;field3

4;1;2

1;2;3

7;3;1

I try to use the sort fonction (in the SP13), but it don't work. I read and apply some examples on SAP .pdf but it don't (again) work.

I try:

with the structure of message:

file

line 1..unbouded

field1 0..1

field2 0..1

field3 0..1

field2 -> sort(Numerical)->splitByValue(EachValue)->collapseContexts->line

field2->sort(Numerical)->splitByValue -> collapseContexts ->splitByValue(EachValue) -> field2

It don't work.

Anybody could help me and give the mapping which work ?