Challenges with extracting and organizing dates using JavaScript regular expressions

Question

Challenges with extracting and organizing dates using JavaScript regular expressions

My task involves organizing these text rows into specific groups based on certain criteria and names.

Il Messaggero Roma 22 settembre 2023
Il Messaggero Roma 21 settembre 2023
Il Messaggero 22 settembre 2023
Il Messaggero 21 settembre 2023
Il Messaggero Roma 21 agosto 2023
Il Messaggero Roma 20 agosto 2023
Le Grandi Glorie del Rock – 15 febbraio 2023
Corriere della Sera Sette 26 agosto 2023

The goal is to group them like this:

Il Messaggero Roma [settembre 2023]
Il Messaggero Roma [agosto 2023]
Il Messaggero [settembre 2023]
Le Grandi Glorie del Rock - [febbraio 2023]
Corriere della Sera Sette [agosto 2023]

Unfortunately, the current grouping is incorrect, with some items included erroneously under wrong names:

settembre [settembre]
agosto [agosto]
febbraio [febbraio]

For example, "

Corriere della Sera Sette 25 Agosto 2023

" and "Il Messaggero" are incorrectly grouped under:

settembre [settembre]
agosto [agosto]

I have attempted to resolve this issue using the following code:

Function for grouping texts such as Il messaggero 21 settembre 2023 or

Le Grandi Glorie del Rock – 15 febbraio 2023

function groupByDate(data) {
    // Code implementation goes here
}

Regex pattern used for matching

function extractGroup(text) {
    // Regex function details here
}

Initialization of table data

function initializeDataTable(data) {
    // Table initialization logic
}

You can find the complete code for table initialization HERE. However, I believe it may not be relevant for solving the current issue.

javascript regex

Answer 1

Answer №1

To create a grouping key, you must extract the part of the text before the date while excluding the day number. You can achieve this using a regular expression replacement.

function groupByDate(data) {
  var groupedData = {};
  data.forEach(function(item) {
    var date = item.id.replace(/^(.*?)\d{1,2}\s((?:january|february|march|april|may|june|july|august|september|october|november|december)\s\d{4})/i, '$1[$2]');
    if (date != item.id) {
      key = date[0].toLowerCase();
    } else {
      key = 'other';
    }
    if (!groupedData[key]) {
      groupedData[key] = [];
    }
    groupedData[key].push(item);
  });
  return groupedData;
}

Answer 2

To create a grouping key, you must extract the part of the text before the date while excluding the day number. You can achieve this using a regular expression replacement.

function groupByDate(data) {
  var groupedData = {};
  data.forEach(function(item) {
    var date = item.id.replace(/^(.*?)\d{1,2}\s((?:january|february|march|april|may|june|july|august|september|october|november|december)\s\d{4})/i, '$1[$2]');
    if (date != item.id) {
      key = date[0].toLowerCase();
    } else {
      key = 'other';
    }
    if (!groupedData[key]) {
      groupedData[key] = [];
    }
    groupedData[key].push(item);
  });
  return groupedData;
}

Answer 3

Answer №2

My approach involves creating 2 functions for each radio button or badge option.

function extractGroup(text) {
    var containsNxM = /\d+x\d+/.test(text);
    if (containsNxM) {
        var match = text.match(/^([a-zA-Z\s]+\s\d+x)/);
        return match ? match[0] : '';
    } else {
        return text;
    }
}

Additionally, I have another function:

function groupNewspapers(text) {
  var containsHash = /#\s\d+\s\w+\s\d+/g.test(text);
  if (containsHash) {
    var match = text.match(/^([a-zA-Z\s]+)\s#\s\d+\s(\w+\s\d+)/gm);
    return match.map(function(line) {
      return line.replace(/^([a-zA-Z\s]+)\s#\s\d+\s(\w+\s\d+)/, '$1 # $2').replace(/^\d+\s\w+\s/, '');
    }).join('\n');
  } else {
    return text;
  }
}

When it comes to table initialization, I have updated the code as follows:

function initializeDataTable(data) {
    if (dataTable) {
        dataTable.destroy();
    }
    var tableData = [];
    if (grouped) {
        groupedData = {};
        data.forEach(function(item) {
            var groupName;
            if (item.badge === 'serietv') {
                groupName = extractGroup(item.id);
            } else if (item.badge === 'quotidiani') {
                groupName = groupNewspapers(item.id);
            }

            if (!groupedData[groupName]) {
                groupedData[groupName] = [];
            }
            groupedData[groupName].push(item);
        });

Answer 4

My approach involves creating 2 functions for each radio button or badge option.

function extractGroup(text) {
    var containsNxM = /\d+x\d+/.test(text);
    if (containsNxM) {
        var match = text.match(/^([a-zA-Z\s]+\s\d+x)/);
        return match ? match[0] : '';
    } else {
        return text;
    }
}

Additionally, I have another function:

function groupNewspapers(text) {
  var containsHash = /#\s\d+\s\w+\s\d+/g.test(text);
  if (containsHash) {
    var match = text.match(/^([a-zA-Z\s]+)\s#\s\d+\s(\w+\s\d+)/gm);
    return match.map(function(line) {
      return line.replace(/^([a-zA-Z\s]+)\s#\s\d+\s(\w+\s\d+)/, '$1 # $2').replace(/^\d+\s\w+\s/, '');
    }).join('\n');
  } else {
    return text;
  }
}

When it comes to table initialization, I have updated the code as follows:

function initializeDataTable(data) {
    if (dataTable) {
        dataTable.destroy();
    }
    var tableData = [];
    if (grouped) {
        groupedData = {};
        data.forEach(function(item) {
            var groupName;
            if (item.badge === 'serietv') {
                groupName = extractGroup(item.id);
            } else if (item.badge === 'quotidiani') {
                groupName = groupNewspapers(item.id);
            }

            if (!groupedData[groupName]) {
                groupedData[groupName] = [];
            }
            groupedData[groupName].push(item);
        });

Challenges with extracting and organizing dates using JavaScript regular expressions

Answer №1

Answer №2

Similar questions

What is the process for inserting or removing a row with Javascript?

When using the parseFloat function with a regular expression input, it results

Vue enables components to be used in any part of the application, not limiting them to

What is the best way to initiate an onload event from a script embedded within a jquery plugin?

Discovering the Voice Channel of a User using Discord.js v13

Merging Two Angular Pages within a Jhipster Application

Creating a dynamic input box that appears when another input box is being filled

What is the most efficient way to apply a single click handler instead of using multiple click handlers for the same

Managing asynchronous data using rxjs

Populate a div using an HTML file with the help of AJAX

Submitting a form using jQuery and processing the response

Please provide either a render prop, a render function as children, or a component prop to the Field(auto) component

"JavaScript function to add objects to an array when button is clicked

Utilizing SlickGrid and DataView for calculating totals efficiently without the need for grouping

How to use the v-model to round up a number in Vue.js

Using Jquery to make an Ajax request to an Asp.net Web Method

Improving the method of accomplishing a task using AngularJS

Can you provide a database of words for different cities, towns, and countries in MongoDB (or in JSON

Trouble with parsing dates in JavaScript using Moment.js

Troubleshooting issue with node.js 13 import functionality