Arcade Expression - Calculate Field - Reorganizing data within a field

Roose_22

I'm creating a grid index for roads. I've created the field (Page:Grid) and it includes the page number and grid number, but they are listed as such: 

I'd like the data to display with the page number then all grids on that particular page. So rather than reading 26: C1, 26: C2, 26: C3, 26: C4 it would appear 26: C1, C2, C3, C4. I was thinking calculate field would be the best way to reorganize the field the way I'd like. Is this possible?

 

kenbuja

This should give you the correct output

var arrField = Split($feature['Page:Grid'],",");
var dict = {}
for (var i in arrField) {
  var input = Split(arrField[i], ": ");
  var key = input[0];
  if (HasKey(dict, key)) {
    var value = Concatenate([dict[key], input[1]], ", ")
    dict[key] = value;
  } else {
    dict[key] = input[1]
  }
}
var output = [];
for (var k in dict) {
  Push(output, Concatenate([k, dict[k]], ': '))
}
return Concatenate(output, ' | ')

For example, this would return "20: E5 | 21: A5 | 22: A1 | 26: D1, E1" for row 8