Google Apps Scripts and Web Development Tutorials and Resources by Laurence Svekis
RegExp with search() methodThe search() method will return a value of the index within the string of the first occurrence that matches the pattern, if no match is found then the result will return a value of -1. You can use the i flag within the regular expression to match on the pattern regardless of … Read more
The replace() method returns a new version of the original string with the pattern matched values being replaced by the new string value. RegExp can be used to set the pattern to be matched, if the pattern is a string value only the first occurrence of the matched results will be replaced. Using a string … Read more
Google Apps Script Images and Files File variables 1How to create a Google Spreadsheet and give it a name, get its ID. 2How to Create a Folder and Get the ID of the Folder 2How to create a sheet and move the file into a specific folder 2How to select a file and move it … Read more
The match() method will return the resulting match of the string value from the regular expression pattern. Depending on if the g flag is used, which is the global flag the results will be returned without the g flag as the first pattern match result including the index value and the string, or with the … Read more
Regular Expressions provide a powerful way to extract information from text content. Regular Expressions or Regex can be used to search text and find matches on the search pattern. The returned results are the matches from the text on the search pattern provided. The search pattern can get fairly complex, this chapter is … Read more
Learn Google Apps Script How to interact with Google Workspace Sheets Data Source code is at https://github.com/lsvekis/Google-Apps-Script/blob/main/Youtube/Apps%20Script%20Sheets%20Common%20Question The code will cover many of the commonly asked questions I get about Apps Script. – How to update a row value – How to output a webapp with Google Apps Script – How to send data to … Read more
Use the promo code MAY-DEAL on any of my courses to get the best deal possible for the next 4 days only. More Courses https://www.udemy.com/u/lars51/ JavaScript Dynamic Web Pages AJAX 30 Projects APIs JSON https://www.udemy.com/course/ajax-json/?couponCode=MAY-DEAL Modern Web Design Beginners HTML CSS JavaScript 25+ Projects https://www.udemy.com/course/modern-web-design/?couponCode=MAY-DEAL JavaScript DOM Game Blackjack JavaScript Game from Scratch https://www.udemy.com/course/javascript-game-code/?couponCode=MAY-DEAL JavaScript … Read more
Use the Promo code MAY-BEST to get the best price possible on all my courses NOW!!! https://www.udemy.com/user/lars51/ Your chance to get these top performing courses for the best deal possible! For the next 4 days ONLY. Hurry….. *** Google Workspace and Google Services – Recommended just for you. *** Google Apps Script WebForm and Fetch … Read more
Regex Checking for Numbers in the input field Check for values that match a Regex pattern in the input field. Push a button and apply the match checker to return the results in the console. <!DOCTYPE html> <html> <head> <title>JavaScript Course</title> </head> <body> <div class=”main”> <input id=”nums” ><button>Submit</button> </div> <script> … Read more
Apps Script – Search Active Sheet to find matching text results of cells Use of the createTextFinder method to search a sheet object and return back the matching results. To get the first value use the method findNext() in the results which is an iterator. To convert all the matching results into an array object … Read more