javascript sort array of string by value after special character

Question

I want to sort by array which contains value having colon (:)

This is the below input

[
  'Severity',
  'Name',
  'U1A_Shift SCM: UPTT-Pressure (Bara)',
  'U1A_Shift SCM: DPTT-Pressure (Bara)',
  'U3B SCM: APTT-Pressure (Bara)',      
  'U3B SCM: UPTT-Pressure (Bara)',      
  'U1B SCM: DPTT-Pressure (Bara)',      
  'U1B SCM: UPTT-Pressure (Bara)',      
  'U3B SCM: DPTT-Pressure (Bara)',      
  'U1A_Shift SCM: UPTT-Temp (DegC)',    
  'U1A_Shift SCM: DPTT-Temp (DegC)',    
  'U3B SCM: APTT-Temp (DegC)',
  'U3B SCM: UPTT-Temp (DegC)',
  'U1B SCM: DPTT-Temp (DegC)',
  'U1B SCM: UPTT-Temp (DegC)',
  'U3B SCM: DPTT-Temp (DegC)',
  'U1B SCM: PCV-CHOKE status - Control position',
  'U3B SCM: PCV-CHOKE status - Control position',
  'U1A_Shift SCM: PCV-CHOKE status - Control position',
  'Alarms',
  'Advisories',
  '__row_index'
]

I want to sort / group it by the value after colon (:)

This should be below output

[
    'Severity',
    'Name': 'U3B',
    'U1A_Shift SCM: UPTT-Pressure (Bara)',    // grouped by UPTT-Pressure (Bara)
    'U3B SCM: UPTT-Pressure (Bara)',
    'U1B SCM: UPTT-Pressure (Bara)',
    'U1A_Shift SCM: DPTT-Pressure (Bara)',    //grouped by DPTT-Pressure (Bara)
    'U1B SCM: DPTT-Pressure (Bara)',
    'U3B SCM: DPTT-Pressure (Bara)',
    'U3B SCM: APTT-Pressure (Bara)', // grouped by APTT-Pressure (Bara)
    'U1A_Shift SCM: UPTT-Temp (DegC)', // grouped by UPTT-Temp (DegC)
    'U3B SCM: UPTT-Temp (DegC)',
    'U1B SCM: UPTT-Temp (DegC)',
    'U1A_Shift SCM: DPTT-Temp (DegC)', // grouped by DPTT-Temp (DegC)
    'U1B SCM: DPTT-Temp (DegC)',
    'U3B SCM: DPTT-Temp (DegC)',
    'U3B SCM: APTT-Temp (DegC)', // grouped by APTT-Temp (DegC)
    'U1B SCM: PCV-CHOKE status - Control position', // grouped by PCV-CHOKE status - Control position
    'U3B SCM: PCV-CHOKE status - Control position',
    'U1A_Shift SCM: PCV-CHOKE status - Control position',
    'Alarms',
    'Advisories',
    '__row_index',
]

I need to sort this array value which lies after ":" Eg: APTT-Temp (DegC)

How can i sort / group array values

Any help would by highly appreciated :)

@evolutionxbox : sorry man initially it was object, i've updated the desired output as arrays now. :) — Mitul Panchal, May 04 '21 at 13:57
Please also note that neither the input nor the output are valid JSON. — evolutionxbox, May 04 '21 at 13:57
@RyanWilson : sorry man my bad earlier was an object i 've updated the desired output — Mitul Panchal, May 04 '21 at 13:58
What happens if an item doesn't have `:`? The output has some at the bottom and some at the top — adiga, May 04 '21 at 13:59
@evolutionxbox : bro input is random values output should be grouped by the value after 'colon' (:) if u check. it can be any order but should be grouped. hope u get it :) — Mitul Panchal, May 04 '21 at 14:00
@adiga: we need to check only if colon is present then sort it if its not simply leave it as it is. — Mitul Panchal, May 04 '21 at 14:01
@evolutionxbox : doesn't matter any order is fine but should be grouped by value after 'COLON' dats the only condition — Mitul Panchal, May 04 '21 at 14:03
Can the input have items without `:` in between items with `:`? Something like this: `['a', 'b:c', 'd', 'e:f', 'g', 'h']`? How does the grouping work in that case? — adiga, May 04 '21 at 14:04
yes inputs can have items without colon too so basically we need group it like ['a', 'b:c', 'f:c', 'z:c', 'd', 'e:f', 'g:f', 'y:f', g, h] but group by val after ':'(colon) — Mitul Panchal, May 04 '21 at 14:06

Nina Scholz · Accepted Answer · 2021-05-05T07:21:59.533

2

You could collect all groups and single values and return a flat array.

const
    data = ['Severity', 'Name', 'U1A_Shift SCM: UPTT-Pressure (Bara)', 'U1A_Shift SCM: DPTT-Pressure (Bara)', 'U3B SCM: APTT-Pressure (Bara)', 'U3B SCM: UPTT-Pressure (Bara)', 'U3B SCM: DPTT-Pressure (Bara)', 'U1A_Shift SCM: UPTT-Temp (DegC)', 'U1A_Shift SCM: DPTT-Temp (DegC)', 'U3B SCM: APTT-Temp (DegC)', 'U3B SCM: UPTT-Temp (DegC)', 'U1B SCM: DPTT-Temp (DegC)', 'U1B SCM: UPTT-Temp (DegC)', 'U3B SCM: DPTT-Temp (DegC)', 'U1B SCM: PCV-CHOKE status - Control position', 'U3B SCM: PCV-CHOKE status - Control position', 'U1B SCM: DPTT-Pressure (Bara)', 'U1B SCM: UPTT-Pressure (Bara)', 'U1A_Shift SCM: PCV-CHOKE status - Control position', 'Alarms', 'Advisories', '__row_index'],
    map = data.reduce((m, s) => {
        const group = s.split(/:\s*/)[1] || m.size;
        return m.set(group, [...(m.get(group) || []), s]);
    }, new Map),
    grouped = Array.from(map.values()).flat(),
    counts = Array
        .from(map, ([k, { length }]) => [k, typeof k === 'string' && length])
        .filter(([, length]) => length);

console.log(counts);
console.log(grouped);

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

edited May 05 '21 at 07:21

answered May 04 '21 at 14:07

Nina Scholz

376,160
25
347
392

Hi Nina, what changed i might have to do in order to achieve this https://stackoverflow.com/questions/67369165/sort-array-of-objects-in-javascript-based-on-object-keys-substring – Mitul Panchal May 04 '21 at 14:36
you could build a new object with the order of the grouped keys from above. – Nina Scholz May 04 '21 at 14:39
could you plz help me with this section, I need it urgently :) – Mitul Panchal May 04 '21 at 14:42
@MitulPanchal Something like [this](https://stackoverflow.com/a/54230116)? – adiga May 04 '21 at 14:46
@NinaScholz yes what about object's value how we can fetch it for(const key of grouped) { obj[key] = 'whatever'; } – Mitul Panchal May 04 '21 at 15:10
you could map ordered entries and get an object from it. `result = Object.fromEntries(grouped.map(k => [k, originalObject[k]]))` – Nina Scholz May 04 '21 at 15:13
@adiga Thanks for the reference mate !! :) – Mitul Panchal May 04 '21 at 15:21
@NinaScholz : just a last question, any way i can get the count of grouped values in above example UPTT-Pressure (Bara) - count is 3, DPTT-Pressure (Bara) - 3, APTT-Pressure (Bara) - 1 – Mitul Panchal May 05 '21 at 07:14
please see edit. btw, a full question would be better than to change the question in comments. for any other changes, please ask a new question. – Nina Scholz May 05 '21 at 07:23
@NinaScholz Ok cool I'll do that for any new question, thanks for this help :) – Mitul Panchal May 05 '21 at 07:27

javascript sort array of string by value after special character

1 Answers1