I remember using the filter() method once to remove empty slots in an Array in JavaScript. An empty array slot might look like this … const arr = [1, , 3, 4, , 6]; and to remove these slots you ...
We often use the !important property in CSS to ignore rules or styles applied to an element and instead apply rules that has !important property. You can further override the !important rules using ...
In JavaScript, you can use the .getElementsByTagName() method to get all the LI elements in UL. In-addition, you can use the .querySelectorAll() method also to get all the li. I have shared few ...
In jQuery, you can use the .clone() method to clone a textbox or an input field on your web page. You can clone the textbox with or without the values. Since, these cloned fields are dynamically ...
You can use Excel as a database, as long as your requirements are limited. Create multiple sheets in your workbook, store various type data in the sheets and work with the data as and when required ...
In SQL Server, you can use the DATEADD() function to get last 3 months (or n months) records. I have used this function in one of my previous posts where I have shown how easily you can get previous ...
If you have worked with SQL, then I am sure you must have come across the LIKE statement to search a specified pattern in a table. The LIKE in SQL uses a % (percent) sign to fetch a pattern of values. ...
I am sharing three simple methods here, which shows how to pull or read data, as it is, from another Excel workbook, in your computer or from a remote computer. While pulling or extracting the data, ...
In Excel, you can use the “EDate()” method to automatically add one month from the previous date or increment the previous date by one month. ...
You can use the join() method in JavaScript to remove commas from an array. The comma delimiter in an array works as the separator. For example, let arr = ["alpha", "bravo", "charli"]. The join ...
I remember using the filter() method once to remove empty slots in an Array in JavaScript. An empty array slot might look like this … const arr = [1, , 3, 4, , 6]; and to remove these slots you ...August 1, 2020Continue Reading →
In jQuery, you can use the .clone() method to clone a textbox or an input field on your web page. You can clone the textbox with or without the values. Since, these cloned fields are dynamically ...July 22, 2020Continue Reading →
You can use Excel as a database, as long as your requirements are limited. Create multiple sheets in your workbook, store various type data in the sheets and work with the data as and when required ...July 8, 2020Continue Reading →
In SQL Server, you can use the DATEADD() function to get last 3 months (or n months) records. I have used this function in one of my previous posts where I have shown how easily you can get previous ...July 1, 2020Continue Reading →
