I am reading in a text file with some data that looks like this:

This is my file
showing some data
data1 = 12
data2 = 156

I want to convert this data into a CSV file while keeping the same format of the text file, like this:

This,is,my,file
showing,some,data
data1,=,12
data2,=,156

My first attempt was to read the text file into a string. The split that string into an array, splitting it at every ' ' (space) char. However, that doesn't seem to work.

I also attempted to split the string into an array at every 'newline' char but it doesn't seem to work.

Can anyone guide me in the right direction? Or how should I go about doing this?

Thanks

I am reading in a text file with some data that looks like this:

This is my file
showing some data
data1 = 12
data2 = 156

I want to convert this data into a CSV file while keeping the same format of the text file, like this:

This,is,my,file
showing,some,data
data1,=,12
data2,=,156

My first attempt was to read the text file into a string. The split that string into an array, splitting it at every ' ' (space) char. However, that doesn't seem to work.

I also attempted to split the string into an array at every 'newline' char but it doesn't seem to work.

Can anyone guide me in the right direction? Or how should I go about doing this?

Thanks

• javascript
• node.js
• csv

Share Improve this question Follow asked Dec 22, 2018 at 1:31 MauricioMauricio 11933 silver badges1212 bronze badges 0

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

You should be able to:

1. split on line breaks
2. split on white space
3. join with mas
4. join with new lines:

let s = `This is my file
showing some data
data1 = 12
data2 = 156`

let text = s.split('\n')                               // split lines
            .map(line => line.split(/\s+/).join(','))  // split spaces then join with ,
            .join('\n')                                // rejoin lines

console.log(text)

You could also just replace all non-linebreak whitespace with mas:

let s = `This is my file
showing some data
data1 = 12
data2 = 156`

console.log(s.replace(/[^\S\n]+/g, ','))

Try str.replace(/ /g, ',');

Code

str = "This is my file\n\
showing some data\n\
data = 12\n\
data2 = 156";

document.write((str.replace(/ /g, ',')).replace(/\n/g,"<br />"));