sorting numbers

[archel]

Hi

I would like to know what the easiest way would be to sort the following:

100|test
5|test
2|test
10|test

into

2|test
5|test
10|test
100|test

I could use java and logic if to check line per line but that seems to be a lot of work for something simple.

Thanks in advance.
Steven

 

[Radzhab]

var lst = project.Lists["MyList"];
var rez = lst.Select(x => x).OrderBy(x => int.Parse(x.Split('|')[0])).ToList();

 

[archel]

Thanks for the response. I'll try this out when I can.

 

[archel]

Hi

I just tried it but can't seem to get it to work. The file content of the list stays the same. See image.
Any idea what I do wrong?

Thanks

Steven

 

[Radzhab]

var lst = project.Lists["MyList"];
var rez = lst.Select(x => x).OrderBy(x => int.Parse(x.Split('|')[0])).ToList();
lst.Clear();
lst.AddRange(rez);

 

[archel]

Thanks!