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

utilizing jQuery to create dynamic data changes based on JSON file

Jest - Silence greets the test results

Navigate through each element with a specific class name in a block of HTML code using

Using Typescript with Material UI Select

Requesting data from a server using jQuery's AJAX functionality

Utilizing JavaScript in AJAX Responses

Error in Next.js: The function (0 , firebase_auth__WEBPACK_IMPORTED_MODULE_1__.onAuthStateChanged) is not defined as a function

Puppeteer: Eliminate hyperlinks on webpage

Storing an Excel file with JavaScript: A comprehensive guide

When invoking a function within another function, it is essential to ensure that both values are returned within the function

What is the best way to steer a vehicle in the desired direction by utilizing the arrow keys on the keyboard?

Creating a Map Using HTML and JavaScript

Is it feasible to utilize math.max with an array of objects?

Whenever I adjust the layout of the navigation bar, the edges end up getting clipped

Differences between throwing errors, returning error objects, and using callbacks in Javascript

The body parser is designed to efficiently parse and handle both gzip and json formatted HTTP POST request bodies

Ways to activate an event based on the dimensions (width/height) of

Issue with jQuery click event not firing on multiple buttons with identical names

REACT performance impacted by slow array filtering

Executing the onSuccess callback in Ajax without any ability to manipulate the ajax requests