我有一个需要按特定顺序过滤的JSON对象(数组数组):
order: ['Hors','TTC','Total général', 'verger', ' Tra']
data = [[" Tra", "100 - 149 ch", "Total"]
[" Tra", "150 - 199 ch", "150 - 159 ch"]
[" Tra", "150 - 199 ch", "160 - 169 ch"]
[" Tra", "500 - 999 ch", "Total"]
[" Tra", "Total", ""]
["Comparable", "", ""]
["Hors", "", ""]
["TTC", "", ""]
["Total général", "", ""]
["vergers", " 1 - 49 ch", "20 - 29 ch"]
["vergers", " 1 - 49 ch", "30 - 39 ch"]
["vergers", " 1 - 49 ch", "40 - 49 ch"]
["vergers", " 50 - 99 ch", "70 - 79 ch"]]我尝试使用sort(),但我不满足我的需要,并且一些字符串包含空格:
data.sort(function (a, b) {
return data.sort((a,b) => order.indexOf(a) - order.indexOf(b)) ;
});这个解决方案没有得到我需要的东西,但仍然保留相同的对象
发布于 2020-07-17 06:45:59
如果您希望返回的所有数据都像order数组中那样进行排序,那么可以像这样使用筛选器
order= ['Hors','TTC','Total général', 'vergers', ' Tra']
const data = [ [" Tra", "100 - 149 ch", "Total"], [" Tra", "150 - 199 ch", "150 - 159 ch"], [" Tra", "150 - 199 ch", "160 - 169 ch"], [" Tra", "500 - 999 ch", "Total"], [" Tra", "Total", ""], ["Comparable", "", ""], ["Hors", "", ""], ["TTC", "", ""], ["Total général", "", ""], ["vergers", " 1 - 49 ch", "20 - 29 ch"], ["vergers", " 1 - 49 ch", "30 - 39 ch"], ["vergers", " 1 - 49 ch", "40 - 49 ch"], ["vergers", " 50 - 99 ch", "70 - 79 ch"] ]
function sort(order){
result=[]
order.forEach(el =>result.push(data.filter(o=>el==o[0])));
result.unshift(data.filter(o=>!order.some(y=>y==o[0])))
return result.flat()
}
console.log(sort(order))
如果您只想过滤和排序有序数组中的元素,您可以尝试这样做
order= ['Hors','TTC','Total général', 'vergers', ' Tra']
const data = [ [" Tra", "100 - 149 ch", "Total"], [" Tra", "150 - 199 ch", "150 - 159 ch"], [" Tra", "150 - 199 ch", "160 - 169 ch"], [" Tra", "500 - 999 ch", "Total"], [" Tra", "Total", ""], ["Comparable", "", ""], ["Hors", "", ""], ["TTC", "", ""], ["Total général", "", ""], ["vergers", " 1 - 49 ch", "20 - 29 ch"], ["vergers", " 1 - 49 ch", "30 - 39 ch"], ["vergers", " 1 - 49 ch", "40 - 49 ch"], ["vergers", " 50 - 99 ch", "70 - 79 ch"] ]
function sort(order){
result=[]
order.forEach(el =>result.push(data.filter(o=>el==o[0])));
return result.flat()
}
console.log(sort(order))
发布于 2020-07-17 05:59:48
如果你想按每个数组的第一个元素排序,这应该是可行的:
(我把'verger‘改成了'vergers’。我猜那是一个打字错误)
var order = ['Hors','TTC','Total général', 'vergers', ' Tra']
var data = [
[" Tra", "100 - 149 ch", "Total"],
[" Tra", "150 - 199 ch", "150 - 159 ch"],
[" Tra", "150 - 199 ch", "160 - 169 ch"],
[" Tra", "500 - 999 ch", "Total"],
[" Tra", "Total", ""],
["Comparable", "", ""],
["Hors", "", ""],
["TTC", "", ""],
["Total général", "", ""],
["vergers", " 1 - 49 ch", "20 - 29 ch"],
["vergers", " 1 - 49 ch", "30 - 39 ch"],
["vergers", " 1 - 49 ch", "40 - 49 ch"],
["vergers", " 50 - 99 ch", "70 - 79 ch"]
];
data.sort((a,b) => order.indexOf(a[0]) - order.indexOf(b[0])) ;
console.log(data)
如果您还想过滤掉不匹配的元素:
var order = ['Hors','TTC','Total général', 'vergers', ' Tra']
var data = [
[" Tra", "100 - 149 ch", "Total"],
[" Tra", "150 - 199 ch", "150 - 159 ch"],
[" Tra", "150 - 199 ch", "160 - 169 ch"],
[" Tra", "500 - 999 ch", "Total"],
[" Tra", "Total", ""],
["Comparable", "", ""],
["Hors", "", ""],
["TTC", "", ""],
["Total général", "", ""],
["vergers", " 1 - 49 ch", "20 - 29 ch"],
["vergers", " 1 - 49 ch", "30 - 39 ch"],
["vergers", " 1 - 49 ch", "40 - 49 ch"],
["vergers", " 50 - 99 ch", "70 - 79 ch"]
];
data = data
.filter(x => order.indexOf(x[0]) > -1)
.sort((a,b) => order.indexOf(a[0]) - order.indexOf(b[0]));
console.log(data)
发布于 2020-07-17 06:09:04
const data = [
[" Tra", "100 - 149 ch", "Total"],
[" Tra", "150 - 199 ch", "150 - 159 ch"],
[" Tra", "150 - 199 ch", "160 - 169 ch"],
[" Tra", "500 - 999 ch", "Total"],
[" Tra", "Total", ""],
["Comparable", "", ""],
["Hors", "", ""],
["TTC", "", ""],
["Total général", "", ""],
["vergers", " 1 - 49 ch", "20 - 29 ch"],
["vergers", " 1 - 49 ch", "30 - 39 ch"],
["vergers", " 1 - 49 ch", "40 - 49 ch"],
["vergers", " 50 - 99 ch", "70 - 79 ch"]
]
function sequence(arr) {
return arr.filter(ele => ["Hors","TTC", "Total général"].some(val => val === ele[0]))
.concat(arr.filter(ele => ele[0] === "vergers"))
.concat(arr.filter(ele => ele[0] === " Tra"))
}
console.log(sequence(data));
https://stackoverflow.com/questions/62944021
复制相似问题