Mapping two dimensions array in Javascript

Question

With an input of a 2 dimensions array I need to get as output an array with the elements in uppercase.

This is my try, but it doesn't works.

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila', 'avila', 'burgos', 'madrid', 'sevilla']];
var cityCell = [['sevilla']];


console.log(cityRow);
function upperCaseArray(myArray) {
  var upperized = myArray.map(function(city){
    console.log(typeof city);
    return city.toUpperCase();
  });
  return upperized;
}

console.log(upperCaseArray(cityColumn));
console.log(upperCaseArray(cityRow));
console.log(upperCaseArray(cityCell));
// output desired:
// [['AVILA], ['BURGOS'], ['MADRID'], ['SEVILLA']]
// [['AVILA, 'AVILA', 'BURGOS', 'MADRID', SEVILLA']]
// [['SEVILLA']]

Note: thesee inputs are that I've get from a Google Sheet range SpreadsheetApp.getActiveSpreadsheet().getSelection().getActiveRange().getValues(). I'm starting coding Google Apps Script.

CertainPerformance · Accepted Answer · 2018-11-07 09:24:17Z

4

Because your strings are nested inside arrays which are inside arrays themselves, you need two .maps:

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila', 'avila', 'burgos', 'madrid', 'sevilla']];
var cityCell = [['sevilla']];
function upperCaseArray(arr) {
  return arr.map(function(subarr) {
    return subarr.map(function(str) {
      return str.toUpperCase();
    });
  });
}
console.log(upperCaseArray(cityColumn));
console.log(upperCaseArray(cityRow));
console.log(upperCaseArray(cityCell));

answered Nov 7, 2018 at 9:24

CertainPerformance

373k55 gold badges354 silver badges359 bronze badges

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

Comments

pgs · Accepted Answer · 2018-11-07 09:33:18Z

1

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila, avila, burgos, madrid, sevilla']];
var cityCell = [['sevilla']];


console.log(cityRow);
function upperCaseArray(arr) {
  return arr.map(a => a.map(item => item.toUpperCase()));
  }

console.log(upperCaseArray(cityColumn));
console.log(upperCaseArray(cityRow));
console.log(upperCaseArray(cityCell));

answered Nov 7, 2018 at 9:33

pgs

213 bronze badges

Comments

Johan · Accepted Answer · 2018-11-07 09:35:01Z

1

First off, your elements in the arrays need to be enclosed with quotes " or ' to mark them as strings, otherwise the interpretator will see them as undefined variables.

You can use the map function to apply a function to all elements in an array. But since this is a 2 dimensional array you need to apply it in a nested way, like the following:

var cityColumn = [["avila"], ["burgos"], ["madrid"], ["sevilla"]];
var cityRow = [["avila", "avila", "burgos", "madrid", "sevilla"]];
var cityCell = [["sevilla"]];

function arrUpper(arr) {
    // o as in outer, and i as in inner
    return arr.map(o => o.map(i => i.toUpperCase()));
}

console.log(arrUpper(cityColumn));
console.log(arrUpper(cityRow));
console.log(arrUpper(cityCell));

Output

[["AVILA"], ["BURGOS"], ["MADRID"], ["SEVILLA"]]
[["AVILA", "AVILA", "BURGOS", "MADRID", "SEVILLA"]]
[["SEVILLA"]]

edited Nov 7, 2018 at 9:35

answered Nov 7, 2018 at 9:29

Johan

3,6311 gold badge20 silver badges31 bronze badges

1 Comment

CertainPerformance Over a year ago

IIRC, Rhino (GAS) doesn't support ES6 syntax, unfortunately

pgs · Accepted Answer · 2018-11-07 09:36:43Z

1

I had to add single quotes to strings.

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila, avila, burgos, madrid, sevilla']];
var cityCell = [['sevilla']];


console.log(cityRow);
function upperCaseArray(arr) {
  return arr.map(a => a.map(item => item.toUpperCase()));
  }

console.log(upperCaseArray(cityColumn));
console.log(upperCaseArray(cityRow));
console.log(upperCaseArray(cityCell));

answered Nov 7, 2018 at 9:36

pgs

213 bronze badges

3 Comments

CertainPerformance Over a year ago

IIRC, Rhino (GAS) doesn't support ES6 syntax, unfortunately

pgs Over a year ago

I'm not following. Why should it support Rhino (GAS)?

CertainPerformance Over a year ago

Because OP is using GAS (which runs on Rhino)

Mamun · Accepted Answer · 2018-11-07 09:56:22Z

1

You can join() the array to make the array as a string. Then upper case the string. Finally split() them to from the array again.

Change

return city.toUpperCase();

To

return city.join(',').toUpperCase().split(',');

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila', 'avila', 'burgos', 'madrid', 'sevilla']];
var cityCell = [['sevilla']];

function upperCaseArray(myArray) {
  var upperized = myArray.map(function(city){
    return city.join(',').toUpperCase().split(',');
  });
  return upperized;
}

console.log(upperCaseArray(cityColumn));
console.log(upperCaseArray(cityRow));
console.log(upperCaseArray(cityCell));

edited Nov 7, 2018 at 9:56

answered Nov 7, 2018 at 9:49

Mamun

69k9 gold badges51 silver badges62 bronze badges

Comments

TheMaster · Accepted Answer · 2018-11-07 10:54:00Z

1

You can use map recursively.

function toUpper(arr){
  if(arr.map){
   return arr.map(toUpper);
  } else {
   return arr.toUpperCase();
  }
}

Recursion depth for a two dimensional array is 2. GAS supports upto 1000.

answered Nov 7, 2018 at 10:54

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

Comments

front_end_dev · Accepted Answer · 2018-11-07 09:28:02Z

0

var cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
var cityRow = [['avila', 'avila', 'burgos', 'madrid', 'sevilla']];
var cityCell = [['sevilla']];

function parseData(input){
        return input.reduce(function(o,i){
            return i.reduce(function(oo,ii){
                oo.push(ii.toUpperCase());
                return oo;
            },[]);
        },[]);
    }

console.log(parseData(cityCell));
console.log(parseData(cityRow));
console.log(parseData(cityColumn));

answered Nov 7, 2018 at 9:28

front_end_dev

2,0661 gold badge13 silver badges15 bronze badges

5 Comments

CertainPerformance Over a year ago

.map is probably more appropriate than reduce when you're transforming every element in one array into an element in another array

front_end_dev Over a year ago

.map will change the original object itself that not what you want.

CertainPerformance Over a year ago

No, .map does not mutate the original array. (none of the array methods mutate except for splice, push, pop, shift, unshift, sort, reverse IIRC)

front_end_dev Over a year ago

if it's not mutate then it will also create the new object

front_end_dev Over a year ago

@CertainPerformance In terms of performance both are more or less same. Better to go with for loop. Found same good performance metrics on github github.com/dg92/Performance-Analysis-JS . Have a look into it.

Mohammad Usman · Accepted Answer · 2018-11-07 09:40:30Z

0

You can use .map() to create arrays with uppercase strings:

let cityColumn = [['avila'], ['burgos'], ['madrid'], ['sevilla']];
let cityRow = [['avila', 'avila', 'burgos', 'madrid', 'sevilla']];
let cityCell = [['sevilla']];

function upperCase(arr) {
   return arr.map(function(a) {
      return a.map(function(s) { return s.toUpperCase(); });
   });
};

console.log(upperCase(cityColumn));
console.log(upperCase(cityRow));
console.log(upperCase(cityCell));

.as-console-wrapper { max-height: 100% !important; top: 0; }

edited Nov 7, 2018 at 9:40

answered Nov 7, 2018 at 9:24

Mohammad Usman

39.6k20 gold badges99 silver badges101 bronze badges

1 Comment

Mohammad Usman Over a year ago

@CertainPerformance Thanks for the input. I've updated my answer accordingly.

Collectives™ on Stack Overflow

Mapping two dimensions array in Javascript

8 Answers 8

Comments

Comments

1 Comment

3 Comments

Comments

Comments

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

1 Comment

3 Comments

Comments

Comments

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related