Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Let us assume a situation where we want to calculate the tax you need to pay on your total income. This problem has two steps first we calculate your total income by adding income from all your sources of income and the second step is to multiply it with the percentage of the tax you want to pay. We can solve this whole problem in a single calculation with the help of below information. here first we add the two numbers and multiply using one formula. Adding Two Numbers in Excel and Then Multiplying in One Formula Let us see ... Read More
When we have two separate columns in an Excel sheet which are to be combined, you don't have to create a new column and enter the whole data again. In this tutorial, we will show you two different ways to combine text cells together into one cell. You can either used the Ampersand symbol (&) or the CONCAT function for this purpose. We will take a simple example to demonstrate how it is done. We will take to columns that would contain the "first name" and "last name" of a set of people. Then, we will create a new column ... Read More
Sometime we may want to place a textbox above each bar of a bar graph to provide additional information. Such textboxes help the users understand the graph quickly and analyse the data in a better way. Most of the time, we use such textboxes to highlight the highest and lowest points in a graph, for example, highest and lowest sales numbers. Read through this tutorial to find out how you can follow a simple process to add a textbox above each bar of a bar graph. Adding Text Box To a Chart In Excel Here we will first create a ... Read More
Overview When working with Bash scripts or Unix/Linux command line tools, we often write the same command lines over and over again. Often, these command lines are long and must be repeated multiple times. For instance, when logging into a remote server daily, copying a local folder to the remote server, or searching for hidden files or directories within a directory. You can create aliases using the alias command. In this guide, I will show you how to create an alias that accepts parameters on Linux. This is useful if you want to run a single command repeatedly without having ... Read More
Overview In this tutorial, we will learn how to find all links for a specific file on Linux. We will use the command lsof to list all files that are opened by any process and then grep to filter out only those files that have a link to our target file. What is a Link? A link in Unix/Linux systems is an association between two different files or directories. When you create a link, it creates a new name for the original file or directory. You can access the linked file through its alias instead of accessing the original file ... Read More
Overview We'll learn how to use Linux commands to get the number of occurrences of a specific character in an input file. We're assuming that you know some common Linux commands, including grep, awk, and tr. We'll also suppose that our input file tpoint.txt contains some dummy data − $ cat tpoint.txt "I Love Tpoint!!!" "Tpoint is great!!!" For the rest of the tutorial, we’ll be using tpoint.txt for demonstration purposes. Using the grep Command The grep command looks for a specific string in an input file. We’ll now look at the command to get the number of characters ... Read More
Overview Finding software’s installation directory is a very common operation. One common reason is for updating the PATH environment variable. For example, Java developers are often interested in finding the installation directory of Java. This article shows how to find the location of the JDK on Linux. The method described here works on both 32-bit and 64-bit versions of these operating systems. The JDK includes many tools that can be used by programmers. In this article we will look at some of them. We will start with the most basic tool: the java command. The Java Command The java command ... Read More
Overview To determine whether our file system uses SSD or HDD technology, we need to know which type of storage device is used by our operating system. There are many different aspects of Linux storage. There seem to be just as many tools available for reading and configuring our storage. We use words like “drive’, ‘volume’, and ‘mount point’ when we want to describe hard drives, optical discs, and USB sticks. But to understand the underlying technology, we only really care about two things − What physical disk or block device we are looking at (from df) The hardware ... Read More
Overview In this article, we will discuss about the concept of stale file handles and how to avoid it in your application. We will also see some examples on how to use fcntl() function to check if a file handle is valid or not. The code in this tutorial has been tested on Debian 10.10 (Buster) with GNU Bash 5.0.3. It is POSIX−compliant and should work in any such environment. What are Stale File Handles? A file handle can be considered as an integer value that represents the access rights for a particular file. The file system maintains a list ... Read More
Overview This article explains how to delete an environment variable from the system. An environment variable is a special kind of variable that can be used by all processes running on your machine. The name of this variable is EXPORTED_VARIABLE. You can use it to pass information between different programs or even between different users. For example, you might want to export the path to the directory where you store your music files so that other users can access them easily. Environment Variable The environment variables are stored as part of the process’s memory space and they are accessible through ... Read More