Save text data to nested array

Question

I have a text file with ID's like this:

111111111
222222222
333333333

And I need to parse the txt file into an nested array, because then I need to make an INSERT to a MySQL database. So the array format has to be in this way:

data_sql = [
   ['111111111'],
   ['222222222'],
   ['333333333']
]

Now I have the next code:

var data_sql = fs.readFileSync(`./uploads/${filename}`, 'utf8').split(/\r?\n/);

But it's saving the array like this:

data_sql = [
  '111111111', 
  '222222222',
  '333333333'
]

DedaDev · Accepted Answer · 2020-03-12 15:50:24Z

2

You can convert every entry to an array with a single item, like this

const formatedEntries = data_sql.map(entry => ([entry]))

answered Mar 12, 2020 at 15:50

DedaDev

5,2792 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Save text data to nested array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related