how to arrange in ascending order

Neto Bezerra

Hi, guys. I have a doubt: there is how to arrange in increasing order the months and years?
https://1drv.ms/i/s!AjClnevQ_1BJg7ly2EvPzDLZ00GTQQ

Thankssss

Binnu Jesudasan Gudapati

Edit > Line Operations > Sort Lines As Integers Ascending

guy038

Hello Neto Bezerra and Binnu Jesudasan Gudapati,

Binnu, I don’t think that’s exactly the sorted list of dates that would like Neto ! Indeed, from the original example list of dates, below :

if we perform the sort Edit > Line Operations > Sort Lines As Integers Ascending, we obtain :

It’s easy that this list is not sorted by year :-(( But you can easily sort a list of dates, if your remember one important rule :

Write the different items of the date, from left to right, from the less frequently changed item to the more frequently changed item

In our case, as years changed less frequently than months, we must re-organize the list, according to the template year/month. To do so, just use the following S/R, in Regular expression mode :

SEARCH : (\d+)/(\d+)

REPLACE : \2/\1 or $2/$1

Therefore, from the original example, above, we get, after the S/R, the new list :

Finally, we perform the classical sort Edit > Line Operations > Sort Lines Lexicographically Ascending, to obtain the well-sorted list ( to my mind ! ), below :

Best Regards,

guy038

Scott Sumner

Perhaps the OP needs the data to be in the
MM/YYYY
format after the sort.

Simply performing again guy038’s regex search and replace will do that.

guy038

Hi Scott,

Oh yes ! I forgot that final point ! Thanks for your reply !

guy038

Neto Bezerra

Thanks so much, guys!!!

Neto Bezerra

Guys, there is a possibility to put some kind of marking or space for when happening a break in the sequence?
Example:

2011/03
2011/04
2011/05

2011/07
2011/08

2012/01
2012/02

Thank you very much in advance!!

Scott Sumner

You need to do some programming in order to achieve that.