I have data structure something like this.
[
{"name": "John", "gender": "Male", "id": "1"},
{"name": "Max", "gender": "Male", "id": "2"},
{"name": "John", "gender": "Male", "id": "3"},
{"name": "Sam", "gender": "Male", "id": "4"},
{"name": "Max", "gender": "Male", "id": "5"},
{"name": "Sam", "gender": "Male", "id": "6"},
{"name": "Sam", "gender": "Male", "id": "7"},
{"name": " ", "gender": "Male", "id": "8"},
{"name": "John", "gender": "Male", "id": "9"},
{"name": " ", "gender": "Male", "id": "10"},
]
I am trying to sort on it based on name property.
I need all the records with name=max should come first followed by name=Sam and then name=John and the remaining records that have empty name field or any other value.
I tried different techniques but didn't get the desired results.
Can someone suggest to me how I can achieve this?
Thanks.