Node.js write to CSV file

Question

I have an array of text lines in JavaScript inside variable named "dataArray":

[
  'freq[Hz];re:Trc1_S11;im:Trc1_S11;re:Trc2_S21;im:Trc2_S21;',
  '2.400000000000000E+009;1.548880785703659E-001;1.067966520786285E-001;1.141964457929134E-003;5.855074618011713E-003;',
  '2.400166666666667E+009;1.546109169721603E-001;1.043454632163048E-001;1.287244027480483E-003;5.807569250464439E-003;',
  '2.400333333333334E+009;1.546102017164230E-001;1.018797382712364E-001;1.497663557529450E-003;5.986513104289770E-003;',
  '2.400500000000000E+009;1.545133888721466E-001;9.928287565708160E-002;1.647840370424092E-003;5.912321619689465E-003;',
  '2.400666666666667E+009;1.544111520051956E-001;9.671460092067719E-002;1.589289400726557E-003;5.917594302445650E-003;',
  ...
]

First line contains headers, and other lines contain data.

I need to write this into .csv file and store that file. How can I do this (I'm using Node.js)?

Have you looked at this? stackoverflow.com/questions/10227107/write-to-a-csv-in-node-js — dikuw
– dikuw, Commented Jan 5, 2020 at 14:25

Marc · Accepted Answer · 2020-01-05 15:25:52Z

First i converte the array to a valid csv data, for that i replace all ; with ,

Then i join all entries together with a newline (csv.join("\r\n")) and write it to a file.

const fs = require("fs");

const data = [
    'freq[Hz];re:Trc1_S11;im:Trc1_S11;re:Trc2_S21;im:Trc2_S21;',
    '2.400000000000000E+009;1.548880785703659E-001;1.067966520786285E-001;1.141964457929134E-003;5.855074618011713E-003;',
    '2.400166666666667E+009;1.546109169721603E-001;1.043454632163048E-001;1.287244027480483E-003;5.807569250464439E-003;',
    '2.400333333333334E+009;1.546102017164230E-001;1.018797382712364E-001;1.497663557529450E-003;5.986513104289770E-003;',
    '2.400500000000000E+009;1.545133888721466E-001;9.928287565708160E-002;1.647840370424092E-003;5.912321619689465E-003;',
    '2.400666666666667E+009;1.544111520051956E-001;9.671460092067719E-002;1.589289400726557E-003;5.917594302445650E-003;'
];


const csv = data.map((e) => {
    return e.replace(/;/g, ",");
});



fs.writeFile("./data.csv", csv.join("\r\n"), (err) => {
    console.log(err || "done");
});

Collectives™ on Stack Overflow

Node.js write to CSV file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related