I know there are tons of sorting questions on here, but I'm unable to resolve my use case.
I am trying to sort a list in R (on Ubuntu 16.04) and am at my wits end! I've been trying to mess with the
collate settings and can get results to sort differently, but I'm unable to get the result I need. This is what I need:
2014_Actual / 2014_Target / 2014_Percent / 2015_Actual / 2015_Target / 2015_Percent
The trick I use in windows is to delete the underscore, so:
2014_Actual / 2014_Target / 2014Percent / 2015_Actual / 2015_Target / 2015Percent, which is acceptable to my users. But obviously this doesn't work in Linux since it ignores the underscore.
Does anybody have any ideas on how I could get the above mentioned sort order at the
Thanks in advance.
EDIT: Adding clarity: the problem is that when I sort the above in Linux, it ignores the underscore and gives:
2014_Actual / 2014Percent / 2014_Target / 2015_Actual / 2015Percent / 2015_Target