How to Check Grammar in Text Using a Simple JavaScript Code?I am sharing a simple JavaScript code snippet here that performs basic grammar checking using the LanguageTool API.javascript
How to Build a Simple Chat Application Using jQuery's text() Method for Dynamic Messaging?A simple chat application using jQuery's text() method enables dynamic messaging by efficiently updating text-based content without modifying HTML structure.jquery
Mastering Word Counting for Writers: The Ultimate Guide to Using The Word Counter ToolIn the world of writing, whether for academic papers, blogs, novels, or business communications, precision matters. This is where The Word Counter tool comes in as an indispensable resource.ai
10 Common performance issues in JavaScript that you should avoidThis guide highlights the most prevalent JavaScript performance pitfalls and provides insights on how to avoid them.JavaScript
Practical Uses of an HTML Minifier: Optimize Code for Better PerformanceHTML Minifier tools play a vital role in optimizing web performance by reducing the size of HTML files without compromising functionality.HTML
How you can fetch real-time stock quotes directly into your Excel worksheet using VBA, updated every few seconds.If you are still actively involved in stock market investments and use Excel to manage your portfolio, here’s a handy exampleExcel
SQL Server - How does COALESCE compare to the ISNULL function?Both COALESCE and ISNULL are SQL functions used to handle null values, but they differ in their purpose and functionality.SQL SERVER
Merge and Combine Cells in Excel Without Losing Data: A Step-by-Step VBA GuideIn this article, I have share a simple VBA macro to merge and combine cells in Excel without losing any data.Excel
How to get a Random word from a list of words in Python?I am sharing a simple code snippet in Python here in this article that shows how to get a random word from a list of given words.Python
How to Count Total Number of Words in Excel cells and Ranges using a Formula?Here in this article, I am going to share a simple formula to count the total number of words in cells.Excel
How to Retrieve Last 5 Minutes of Data in SQL Server: 3 Efficient Query ExamplesIn this article I am going to show you 3 different SQL Queries to get the last 5 minutes data in SQl Server.SQL SERVER
How to get (or retrieve) the last character of a string using Array.from() method in JavaScript? I'll show you how you can use the "Array.from()" method to retrieve the last character from a given string.JavaScript
Extract File Names from File Paths in Excel using this simple macroSharing a simple macro in Excel that extract filenames from filepaths.Excel
How to Automatically Add One Month from Previous Date in ExcelIn Excel, you can use the EDate() method to automatically add one month from the previous date or increment the previous date by one month.Excel
How to Find Employees Who were Hired in the Last n Months in SQL ServerHere's a simple SQL query to find employees who were hired in the last n monthsSQL Server
How to use Excel TEXTJOIN() function in a formula to remove parentheses and the text within them?In this article, I will introduce a more advanced formula to remove parentheses and the text within them.EXCEL
Fetch data from an XML file using URL in Python using this simple method.Here in this article I am going to show you how to fetch and process data from an XML file in Python. I am using VS-Code to run (execute) the example.Python
How to Generate Random Words using JavaScript?In this article I am sharing a simple JavaScript code snippet to gererate random English words. The words are defined in an array.JS
How to Split a string into Multiple Lines on a Web page using JavaScriptI've have shared three different methods to split a string into multiple lines using JavaScriptJS
How to capture Image from Webcam and add it to an HTML table?The examples here demonstrate how easily you can capture an image from your webcam and add it to a table using JavaScript.JS
How to use Power Query in Excel to connect SQL Server and import data into your worksheet?In this article I am showing how to user Power Query to connect SQL Server database and retrieve data into Excel worksheet.Excel
How to use filter() to find words in an array that starts with a letter?Shared few examples here that shows how to use the filter() function in JavaScript to find words that starts with a letter.JS
How to Embed YouTube Video in HTML without IFrameIn this article I have explained with examples how to embed YouTube videos in a web page without iframe.GOOGLE
HTML rel='noopener noreferrer' Tag. What does it mean?The rel="noopener noreferrer" is used to enhance security and privacy when opening links in a browsers tab or a new window.HTML
How to Use JavaScript Data Attributes to Fetch Data from a JSON FileIn this article I am sharing an example showing how to use JavaScript to access data attributes of an element and fetch related information from a remote JSON file.JS
VBA Tutorial: How to read multiple excel files and merge data into separate worksheets in a single file?Here in this article I’ll show you how to read multiple excel files or workbooks and merge the data accross multiple worksheet in a single file using VBAExcel (VBA)
Asp.Net Web Service - How to return a String Response to an Ajax call instead of XML?In this article I am going to show you how to configure an Asp.Net web service to return a string response instead of xml.Asp.Net (C#)
How to use Highcharts API to create dynamic and animated charts with data from external JSON file?Highcharts is a pure JavaScript library, which provides easy to use methods and properties to create interactive and animated charts for your websites and web applications.Charts
How to create a "simple" Data Entry Form in Excel without VBA?Do you know Excel provides a special form, a built-in feature, for data entry? Let's find out.Excel
Dynamically create UserForm controls and Save data in SQL Server databaseIn this tutorial, I’ll show you how to create and add ActiveX Controls dynamically in a UserForm and save all the data (extracted from the controls) in an SQL Server table.Excel (VBA)
How to create an autocomplete search using JSON and pure JavaScript - No Widgets, No LibrariesThe example here shows how to create a simple AutoComplete textbox feature using data from an Array and using the includes() method.JavaScript
How to remove duplicates from an array quickly and efficiently without running a loop in JavaScript?There two simple built-in methods that you can use together in JavaScript, to quickly and efficiently remove duplicates from an array without running a loop.JS
Windows Forms App - How to export data to an Excel worksheet with AutoFormat feature using C#You must be aware of the AutoFormat feature in Excel: it allow users to format a worksheet (or a particular range) with various formatting options. Here in this article, I’ll show you how to export data to an Excel sheet in a Windows Forms application using C# and apply AutoFormat feature dynamically to the worksheet. In-addition, I’ll also show you how to populate a WinForms CheckedListBox control using data extracted from a database.WinForms (C#)
How to use ternary operator within the map() function - JavaScriptThe ternary operator in JavaScript is a conditional operator. It is used as an alternative to if...else statement. But do you know you can use the ternary operator within the .map() function. Yes you can and I'll show you how.JavaScript
SQL Server DATENAME() Function - Get the name of distinct Months in words from a date column I have shared fews examples in this article showing how to get distinct months, in words, from a date column using DATENAME() function in SQL Server. The DATENAME() is an SQL Server built-in function that returns a specified part (a datepart) of a specified date. SQL Server
How to show images from an array using JavaScript - The Easy Way There are few simple methods in JavaScript that you can use to extract images from an array and display it. The method that I am going to share in this article uses the .map() function. JavaScript
Web Scraping using Pure JavaScript - Two different methods Web scraping (or known as Screen Scraping) is process of extracting data like HTML codes etc. from websites or web pages. The extracted data is often used for analysis or to simply display the extracted contents on other web pages. Here in this article I am going to show you two different web scraping methods using pure JavaScript. JavaScript
What is Nullish coalescing operator "??" and how to use it effectively in JavaScript? Nullish coalescing operator ?? is a logical operator that returns right-hand side value (operand) if left-hand side value (operand) is "null" or "undefined". Let's understand this operator with two simple examples. JavaScript
How to get sum of array elements without using loops or recursion One of the easiest way to get the sum of array values without looping is to use the .reduce() method. The method reduces array elements into a single value. Most importantly, it reduces the size of the script, since you don't need to loop through each element or do any recursion. JavaScript
Copilot Notebook - AI tool from Microsoft for longer text prompts I recently came across this brand new AI tool from Microsoft called Copilot Notebook. Its a new feature of Copilot, the AI assistant we all have been using for some time now. I'll tell you why you should also try Notebook. You dont' want to miss the 2nd feature. AI
Extract text within parentheses in Excel using RegEx In this article, I am going to show you how to use RegEx (regular expressions) in Excel to extract text within parentheses using a custom regular expression function in VBA. Excel
What is the formula in Excel to count how many times a particular word occured in a range? You can use the COUNTIF() function in Excel to count number of occurrences of a particular word in a range.Let us assume, I have a list of different types of birds in the 2nd column in my Excel worksheet. I want to know how many times a bird of type "Dove" or "Sparrow" is entered in the list. Check the formula. excel
How to open and read contents of a text file in Python Python offer two built-in methods that you can use to read contents in a text file. The methods are read() and readline(). Python can handle different types of files like a .txt file, a csv file or Excel worksheets etc. But in this article I am going to show you how to "open" a .txt file in Python and read its content as it is. python
Excel formula to remove first four characters Let us assume, I have some data in my Excel worksheet. From one particular column, I want to extract values after removing the first four characters. I am going to show you three different formulas using three Excel built-in functions to do this. Excel