Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The Passport is a node package, or library which we can install in any nodeJs project. The Passport provides the functionality for authentication in the app. Also, it provides different encryption strategies to encrypt user information, such as a password. For example, what if Facebook or Google employees could see the password of their users? It is against user privacy. So, in such cases, we can use the Passport, which encrypts the password and stores it in the database. We should know the decryption algorithm and secret key to decrypt the password. Also, the Passport allows us to establish the ... Read More
This tutorial will cover page redirection, introduced in the ES6 version of JavaScript. Page redirection is a way to send web page visitors to another URL from the current URL. We can redirect users to either the different web pages of the same website or another website or server. In JavaScript, a window is a global object which contains the location object. We can use the different methods of the location objects for the page redirection in ES6, which is all we learn below. Using the window.location Object’s href Attribute Value The location object of the window global object contains ... Read More
We will learn non−boolean value coercion to a Boolean one in JavaScript. For beginners, coercion word is new in JavaScript. So, let’s clarify what coercion. Coercion is converting the variable of one data type to another data type. As we all know, JavaScript is not a type−strict language. So, we don’t need to define the types of the variable. Sometimes, JavaScript automatically coerces the variables and gives unpredictable results in the output. There are two types of coercion in JavaScript. One is implicit coercion, and another is explicit coercion. We will learn both coercion one by one in this tutorial. ... Read More
In this article, we will learn how to compare two adjacent strings in excel for identifying differences or similarities. Two methods have been explained in this article as mentioned below. Compare two strings for similarities using a formula. Compare and highlight two strings for similarities or differences using VBA Code. Compare Two Strings for Similarities using a Formula Step 1 − A sample data has been taken as shown below to compare the strings of two columns. Step 2 − Now, enter the following formula in Match Result column and drag the same till the last row to which ... Read More
If you want to compare two or more columns to find duplicate values, it can be done using a formula mentioned in this article. Many times, we come across a data set where values are entered repeatedly and required to be filtered. Let’s see how this can be achieved. Compare Two or More Columns Using a Formula Step 1 − We have taken sample data as shown below having two columns with some duplicate values. Step 2 − In the column C, we will identify the duplicate and unique values using the below formula. IF(ISERROR(MATCH(B3, $A$3−$A$10000, 0)), "Unique", ... Read More
To compare the values of two or more cells there are multiple formulas that can be used. For example, MATCH, If(A=B), EXACT, COUNTIF, etc. Here we will be learning the following two functions to find the exact match or where the formula will compare the strings without considering the case of strings. EXACT − To find the exact match. COUNTIF − To find similar values. Compare Multiple Cells for Equal Values Step 1 − Following is the sample data that we have taken for comparing the strings/cell values in a datasheet. Step 2 − Here, we have ... Read More
If we want to compare a date in an excel sheet with all other dates available in the sheet, then manually doing this activity will be very tedious and time taking. For this activity, we can use a formula that may give the comparison in one shot. Let’s learn how to use this formula to compare the dates. Compare Dates to Check if a Date is Greater than Another Date Step 1 − Below is the sample data that we have taken for comparing the dates. In the first column, we have taken the dates with which comparison needs to ... Read More
It usually happens with huge data that we might get multiple workbooks having worksheets of same name. Due to this we need to check all the similar sheets to get any specific value related to that sheet name. In this article, we will learn how to merge the worksheets having same name. By using the following method, we can combine the worksheets of same name into a master worksheet. Combine worksheets of same name into one worksheet using Copy and Paste command Step 1 − Here we have taken the sample data in two separate workbooks having sheets with same ... Read More
The product of two numbers is the result you get when you multiply them together. So 15 is the product of 3 and 5 and 22 is the product of 2 and 11 and so on. A Recursion is where a function calls itself by direct or indirect means. Every recursive function has a base case or base condition which is the final executable statement in recursion and halts further calls. Example-1: Golang Program Code to Find The Product of Two Numbers Using Recursion by Using The Direct Recursion Method Syntax Syntax for direct recursion func recursion() { ... Read More
In this tutorial program, we will learn how to display the factors of a given number in the Go programming language. A factor of a number is defined as the algebraic expression that divides any given number evenly, with its remainder being zero. All composite numbers will have more than two factors, that include 1 and the number itself also. For example: by multiplying 3 and 7, we get 21. We say 3 and 7 are factors of 21. Below is a demonstration of the same − Input Suppose our input is = 15 Output The factors of 15 ... Read More