Here in this post we will see how we can create a find and replace function in Google apps script. This function will find a particular searched string or value and replace it with the desired value. Google Apps Script code : Let’ see how code for Find and Replace works in Google Apps Script. […]
Getting Spreadsheet creation and modification date using GAS
When you are working as an Analyst, your main part of the job is to create reports with important KPI which help business to understand in detail about how their business is performing. Also performing automation or creating automated reports are one more task. While working and automating Google Spreadsheet, you have come across a […]
Google Apps Script to search a string in Google Sheet [Part II]
In our last post we have seen how we can use Google Apps Script to search a string in Google Sheet and add n number of rows just after the row in which the string was found. But there is one issues : which is that it won’t loop over all the items that matches […]
Google Apps Script to search a string in a column in Google Sheet [Part 1]
Searching a string in a google sheet is easy when you search it manually using Ctrl+F and enter the string. But what if you want to automate the task and search the string to perform dependent task, the Google Apps Script is there for your rescue. I came across a situation where i have to […]
Loop over two list or array in Google Apps Script
If you loves working on Google suits, i am sure you work on Google Apps script which is based on JavaScript. While working on Google Apps Script (GAS) you have came across situation where you have two list or array and you want to loop over each item one by one. Here in this post […]
Regular Expression in Google Apps Script
I believe we all have used Regular Expression while working on different projects in different languages. Basically we Regular Expressions to match a pattern of characters. Here in this post we will see how you can define Regular Expression in Google Apps Script. Importance of Regular Expression(RegEx) and why you should learn: RegEx helps you […]