Sorting a muli-value column by any of the values
Sorting a muli-value column by any of the values
jameyer
Posts: 1Questions: 0Answers: 0
Hi,
Consider a simple NFL table with 2 columns: Team and Record.
The Team column values are a simple strings and easy to sort,
The Record column contains wins losses and average margin.
A value of the Record column might look like this:
5-3 (+3.6)
How can I sort this table by either wins, losses, or average margin?
The header for the Record column might look like this:
Record
W-L (margin)
Thanks in advance for any clues.
Joe
Consider a simple NFL table with 2 columns: Team and Record.
The Team column values are a simple strings and easy to sort,
The Record column contains wins losses and average margin.
A value of the Record column might look like this:
5-3 (+3.6)
How can I sort this table by either wins, losses, or average margin?
The header for the Record column might look like this:
Record
W-L (margin)
Thanks in advance for any clues.
Joe
This discussion has been closed.
Replies
next easiest would be to parse the values and extract the portion you are interested in sorting by.