How can I troubleshoot my outdated JavaScript tool that is duplicating elements in an array?

Question

How can I troubleshoot my outdated JavaScript tool that is duplicating elements in an array?

Below is the input that needs to be converted into JSON format as shown:

{RS0004036}:{0;3}:{0000003AB;0000003BC}_{RS0004036}:{3;3}:{0000003DE;0000003FG}_{RS0004036}:{1;2}:{0000003HI;0000003JK}

The code should parse the above input and generate a JSON string as follows. The resulting JSON will contain a single store value at index 0 of the input string and will not repeat under partList. The desired JSON output should look like this.

"storeList": [ 
{ 
"store": "RS0004036", 
"partList": [ 
{ 
"part": "0000003AB", 
"partSub": "0000003BC", 
"qtyOnHand": "0", 
"qtyMinMax": "3" 
}, 
{ 
"part": "0000003DE", 
"partSub": "0000003FG", 
"qtyOnHand": "3", 
"qtyMinMax": "3" 
}, 
{ 
"part": "0000003HI", 
"partSub": "0000003JK", 
"qtyOnHand": "1", 
"qtyMinMax": "2" 
} 
] 
} 
]

Here is the provided code:

const hdr_str = '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}';;

var storeList = {}; 
var partList = []; 
storeList.partList = partList; 

//Processing 
const partsDataEntries = hdr_str.split('_'); 

for (var index = 0; index < partsDataEntries.length; index++) { 
const element = partsDataEntries[index].slice(1, -1); 
console.log('element0' + element); 
if (element != '') { 
const storepart = element.split(':'); 
const storeId = storepart[0].slice(1, -1); 
const [qtyOnHand, qtyMinMax] = element.split(':')[1].split(';');

console.log("element.split(':')[1]" + element.split(':')[1]); 
const qtyOH = qtyOnHand.substring(1, qtyOnHand.length); 
const qtyMM = qtyMinMax.substring(0, qtyMinMax.length - 1); 
const [partnum, partsub] = element.split(':')[2].split(';'); 

const part = partnum.substring(1, partnum.length); 
storeList.storeId = storeId; 

partList = { 
"partnum": part, 
"partsub": partsub, 
"qtyOnHand": qtyOH, 
"qtyMinMax": qtyMM 
} 

storeList.partList.push(partList); 
} 
} 
console.log(JSON.stringify(storeList));

The issue is with repeating elements in my tool with an outdated JavaScript engine that cannot be replaced. Can anyone suggest how to resolve it?

{"partList":[{"partnum":"0000003AB","partsub":"0000003BC","qtyOnHand":"0","qtyMinMax":"3"},{"partnum":"0000003AB","partsub":"0000003BC","qtyOnHand":"0","qtyMinMax":"3"},{"partnum":"0000003AB","partsub":"0000003BC","qtyOnHand":"0","qtyMinMax":"3"}],"storeId":"RS0004036"}

javascript arrays json

Answer 1

Answer №1

One way to extract and store all the necessary details into specific variables/properties is by using a matching technique.

const
    data = '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}',
    result = data
        .split('_')
        .reduce((r, s) => {
            const
                [store, qtyOnHand, qtyMinMax, part, partSub] = s.match(/[^\{\};:]+/g),
                item = { part, partSub, qtyOnHand, qtyMinMax };
            let o = r.find(o => o.store === store);
            if (o) o.partList.push(item);
            else r.push({ store, partList: [item] });
            return r;
        }, []);

console.log(result);

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

Answer 2

One way to extract and store all the necessary details into specific variables/properties is by using a matching technique.

const
    data = '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}',
    result = data
        .split('_')
        .reduce((r, s) => {
            const
                [store, qtyOnHand, qtyMinMax, part, partSub] = s.match(/[^\{\};:]+/g),
                item = { part, partSub, qtyOnHand, qtyMinMax };
            let o = r.find(o => o.store === store);
            if (o) o.partList.push(item);
            else r.push({ store, partList: [item] });
            return r;
        }, []);

console.log(result);

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

Answer 3

Answer №2

If you want to avoid using string split/slice, consider utilizing named capturing groups in a regular expression, like this:

const regex = /{(?<store>RS\d*)}:{(?<qtyOnHand>\d+);(?<qtyMinMax>\d+)}:{(?<part>.+)_(?<partSub>.+)}/gm;

You can then extract each element and retrieve the relevant property from the result of the capturing groups, for example:

let storeName = m.groups["store"];

Here is an updated snippet that extracts parts Lists and combines them into a list of stores:

const hdr_str = '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}';
let storeList = [];

//Processing
const partsDataEntries = hdr_str.split('_');

for (var element of partsDataEntries) {
  const regex = /{(?<store>RS\d*)}:{(?<qtyOnHand>\d+);(?<qtyMinMax>\d+)}:{(?<part>.+)_{(?<partSub>.+)}/gm;
  let m;

  while ((m = regex.exec(element)) !== null) {

    let store = storeList.find(x => x.store == m.groups["store"]);
    if (store == null) {
      store = {
        "store": m.groups["store"],
        partList: []
      };
      storeList.push(store);
    }

    let part = {
      "part": m.groups["part"],
      "partSub": m.groups["partSub"],
      "qtyOnHand": m.groups["qtyOnHand"],
      "qtyMinMax": m.groups["qtyMinMax"]
    };
    store.partList.push(part);

  }
}
console.log(storeList);
console.log(JSON.stringify(storeList));

Answer 4

If you want to avoid using string split/slice, consider utilizing named capturing groups in a regular expression, like this:

const regex = /{(?<store>RS\d*)}:{(?<qtyOnHand>\d+);(?<qtyMinMax>\d+)}:{(?<part>.+)_(?<partSub>.+)}/gm;

You can then extract each element and retrieve the relevant property from the result of the capturing groups, for example:

let storeName = m.groups["store"];

Here is an updated snippet that extracts parts Lists and combines them into a list of stores:

const hdr_str = '{RS0004036}:{1;2}:{0000003AB;0000003BC}_{RS0004036}:{0;3}:{0000003DE;0000003FG}_{RS0004036}:{3;3}:{0000003HI;0000003JK}';
let storeList = [];

//Processing
const partsDataEntries = hdr_str.split('_');

for (var element of partsDataEntries) {
  const regex = /{(?<store>RS\d*)}:{(?<qtyOnHand>\d+);(?<qtyMinMax>\d+)}:{(?<part>.+)_{(?<partSub>.+)}/gm;
  let m;

  while ((m = regex.exec(element)) !== null) {

    let store = storeList.find(x => x.store == m.groups["store"]);
    if (store == null) {
      store = {
        "store": m.groups["store"],
        partList: []
      };
      storeList.push(store);
    }

    let part = {
      "part": m.groups["part"],
      "partSub": m.groups["partSub"],
      "qtyOnHand": m.groups["qtyOnHand"],
      "qtyMinMax": m.groups["qtyMinMax"]
    };
    store.partList.push(part);

  }
}
console.log(storeList);
console.log(JSON.stringify(storeList));

How can I troubleshoot my outdated JavaScript tool that is duplicating elements in an array?

Answer №1

Answer №2

Similar questions

Using Rxjs to reset an observable with combineLatest

Error: Module not located or Image unable to load in React JS

I'm at a loss with this useState error, can't seem to figure

Using Node.js to read from a file and write the character 'Ł' to another file

When XML is accessed through an iframe, it is interpreted as HTML

I'm having trouble locating the source of the popstate loop that is generating numerous history entries

Implement a nested feature within the Accordion component

Are there any additional features available in NetSuite that allow for viewing multiple pages within a PDF document?

How to pass variables in AngularJS

Implementing autocompletion in an ASP.NET MVC4 application with AJAX and jQuery

Assistance required: Click on the button to select and copy all text within the specified paragraph ID

changing font size on a mobile-friendly site using javascript

Python Selenium driver.execute_script() is not returning expected values even though a return value is provided in the JavaScript script that is passed in

Utilizing the Sheet Elite API - Step-by-Step Guide for Sending Data to a Designated Sheet Through a POST Request

Displaying duplicate information within a JSON ListView

What is the best way to store a personalized configuration for a user within a Node module?

I am running into a problem trying to configure the "timezone" setting for MySQL within Sequelize and Node.js

Triggering a JavaScript function when the mouse moves off an element

Converting an Object with an ArrayList field to JSON and then back using Gson

CosmosDB Update in C#: Unable to identify JSON object type for the System.String[] data structure