Menu
I am looking for the easiest way to solve this problem. I have a huge data set that i cannot load into excel of this type of format
This is a sentence|10 This is another sentence|5 This is the last sentence|20 What I want to do is sort this from least to greatest based on the number.
cat MyDataSet.txt | tr "|" "\t" | ??? Not sure what the best way is to do this, I was thinking about using awk to switch the columns and the do a sort, but I was having trouble doing it.
Help me out please
376
Use the -k option to sort on a certain column. For example, use " -k 2 " to sort on the second column. In old versions of sort, the +1 option made the program sort on the second column of data ( +2 for the third, etc.).
In Excel, you can sort your table by one or more columns, by ascending or descending order, or do a custom sort.
If you want to sort the table columns independently from each other, click on the Arrange All button in the ribbon toolbar tab Variables. After clicking, the Arrange_All function appears in the sidebar. If you click on it, one property will show in the Properties Panel - Desc.
sort -t\| -k +2n dataset.txt Should do it. field separator and alternate key selection
152
You usually don't need cat to send the file to a filter. That said, you can use the sort filter.
sort -t "|" -k 2 -n MyDataSet.txt This sorts the MyDataSet.txt file using the | character as field separator and sorting numerically according to the second field (the number).
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
