Advertisement
Shell_Casing

piece of code

Dec 25th, 2018
451
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2.  
  3.  
  4.  
  5. let json =
  6.  
  7.     [
  8.         {
  9.             "TimeStamp": "2018-10-02T11:30:07.211Z",
  10.             "Value": "109316.4691",
  11.             "Quality": 3
  12.         },
  13.         {
  14.             "TimeStamp": "2018-10-02T11:30:49.811Z",
  15.             "Value": "109312.0255",
  16.             "Quality": 3
  17.         },
  18.         {
  19.             "TimeStamp": "2018-10-02T11:31:04.011Z",
  20.             "Value": "109310.5443",
  21.             "Quality": 3
  22.         },
  23.         {
  24.             "TimeStamp": "2018-10-02T11:31:11.111Z",
  25.             "Value": "109309.8037",
  26.             "Quality": 3
  27.         }
  28.     ];
  29.  
  30.  
  31. let fields = Object.keys(json[0]);
  32.  
  33. function replacer(key, value) {
  34.     return value === null ? '' : value;
  35. }
  36.  
  37. let csv = json.map(row => {
  38.     return fields.map(fieldName => {
  39.         return JSON.stringify(row[fieldName], replacer)
  40.     }).join(',')
  41. });
  42.  
  43. csv.unshift(fields.join(',')); // add header column
  44.  
  45. console.log(csv.join('\r\n'));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement