-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathCSVToJSON.js
81 lines (74 loc) · 1.64 KB
/
CSVToJSON.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
const csvData = `id,parentId,data,
1,,root,
2,1,user,
3,1,newUser,
4,,myUser,
5,,MyData,
6,4,hello`
const csvToJson = (csvData) => {
const splitArray = csvData.split("\n");
const header = splitArray[0].split(",");
const data = splitArray.slice(1);
const result = [];
for(const value of data) {
const valueArr = value.split(",");
let obj = {
[header[0]]: valueArr[0],
[header[1]]: valueArr[1],
[header[2]]: valueArr[2],
"children": []
}
if(!valueArr[1]){
result.push(obj);
}else{
const parent = result.filter((item) => item.id === valueArr[1]);
if(parent) parent[0].children.push(obj)
}
}
return result
}
const output = csvToJson(csvData);
console.log(JSON.stringify(output));
/*
Output
[
{
"id": "1",
"parentId": "",
"data": "root",
"children": [
{
"id": "2",
"parentId": "1",
"data": "user",
"children": []
},
{
"id": "3",
"parentId": "1",
"data": "newUser",
"children": []
}
]
},
{
"id": "4",
"parentId": "",
"data": "myUser",
"children": [
{
"id": "6",
"parentId": "4",
"data": "hello",
"children": []
}
]
},
{
"id": "5",
"parentId": "",
"data": "MyData",
"children": []
}
]
*/