Verifying if a Google Apps Script sheet name or string contains a combination of letters and numbers using JavaScript

Question

Verifying if a Google Apps Script sheet name or string contains a combination of letters and numbers using JavaScript

I need help with my App Scripts code that checks for sheet names. In my project, there are two types of sheet names - those with only alphabets (e.g. master) and those with a combination of alphabets and numbers (PHY4125). The current code is set to check for the second type of sheet name, but my IF condition isn't working as expected. Is there another approach I can take to achieve the same task?

Here is my code snippet:

function autoConvert(e) {    
    var ss = e.source;
    var sh = ss.getActiveSheet();
    var key = sh.getName();
    var lastRow = sh.getLastRow();
              
    if (key.match(/[0-9]/)) {

        // Code block implementation

    }
}

javascript regex google-apps-script google-sheets

Answer 1

Answer №1

The Explanation:

This specific regular expression is designed to verify whether the string key contains both letters as well as numeric digits.

Therefore, when this particular expression is utilized like so:

if(key.match(/^(?=.*[A-Za-z])(?=.*[0-9])[A-Za-z0-9]+$/))

It will return a value of true in scenarios such as AB23423, ab23423, 23233ab, 24443AB, or any other similar combination like As23Abc.

The Solution:

 function autoConvert(e) {    
        var ss=e.source;
        var sh=ss.getActiveSheet();
        var key=sh.getName();
        var lastRow=sh.getLastRow();

       if(key.match(/^(?=.*[A-Za-z])(?=.*[0-9])[A-Za-z0-9]+$/)){
  
    //Place your code snippet here
  
  }
     
  }

Answer 2

The Explanation:

This specific regular expression is designed to verify whether the string key contains both letters as well as numeric digits.

Therefore, when this particular expression is utilized like so:

if(key.match(/^(?=.*[A-Za-z])(?=.*[0-9])[A-Za-z0-9]+$/))

It will return a value of true in scenarios such as AB23423, ab23423, 23233ab, 24443AB, or any other similar combination like As23Abc.

The Solution:

 function autoConvert(e) {    
        var ss=e.source;
        var sh=ss.getActiveSheet();
        var key=sh.getName();
        var lastRow=sh.getLastRow();

       if(key.match(/^(?=.*[A-Za-z])(?=.*[0-9])[A-Za-z0-9]+$/)){
  
    //Place your code snippet here
  
  }
     
  }

Verifying if a Google Apps Script sheet name or string contains a combination of letters and numbers using JavaScript

Answer №1

The Explanation:

The Solution:

Similar questions

Building a dynamic form in React: Fetching select data from an API, posting to another API, and automatically clearing fields upon submission

The concept of DIV layers and utilizing the jquery click function

Additional headers are included in the Access-Control-Request-Headers

Error: StalePageException occurred in the wicket framework

What is the reason my answer for the powerset problem is flawed? Both my recursive and iterative methods are attached for review

Can you explain the variance between "+" and "+"?

Utilizing Google Analytics within an Angular Single Page Application

What is the best way to implement a shared function across two classes?

Is scrollTo completely unresponsive?

Deactivate the button in the final <td> of a table generated using a loop

Tips for creating a flexible Cell component in react-big-calendar:

Transfer information from an array to a Vue function

Updating the state of Formik

Error in Syntax: Unforeseen symbol (Initial code)

Transferring data from an uploaded excel file to Python using ajax

Obtain the bounding box of an SVG element while it is not visible

Is it possible to change the color of multiple elements at once using Javascript?

Issue with JavaScript Replace not replacing second '<' character

Choose and Send pictures through a Form with JavaScript

Browser and contexmenu intersecting halfway