Array to CSV add separator between every character

Question

I'm using alasql to convert into CSV:

data = ["402 Fourth Avenue", "11 Russell Avenue", "East Diamond Avenue"];

function exportData(list) {
    alasql.promise('SELECT * INTO CSV("test.csv", {separator:" "} ) FROM ?',list)
     .then(function(data){
         console.log('Data saved');
    }).catch(function(err){
         console.log('Error:', err);
    });
}

When I pass it through the function my result ends up like this:

4 0 2   "F" "o" "u" "r" "t" "h"   "A" "v" "e" "n" "u" "e"

I cannot figure out why! Thank you in advance you will make my day!

Barmar · Accepted Answer · 2016-07-08 23:31:37Z

2

Based on this example in the documentation, the argument should be a 3-dimensional array.

The first dimension corresponds to the placeholders (?) in the query.
The second dimension is the rows of the CSV.
The third dimension is the columns in the CSV.

So data should be a 2-dimensional array, and then you should wrap it in another array when calling alasql.

data = [["402 Fourth Avenue"], ["11 Russell Avenue"], ["East Diamond Avenue"]];

function exportData(list) {
    alasql.promise('SELECT * INTO CSV("test.csv", {separator:" "} ) FROM ?',[list])
     .then(function(data){
         console.log('Data saved');
    }).catch(function(err){
         console.log('Error:', err);
    });
}

answered Jul 8, 2016 at 23:31

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

1 Comment

dgrubman Over a year ago

thank you!! My array wasn't up to snuff. Much appreciated!

Collectives™ on Stack Overflow

Array to CSV add separator between every character

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related