Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
XOR of all substrings of a given Binary String
A binary string is a string that contains only two different types of characters in it which are '0' and '1'. Substrings are strings that are formed by deleting some character from the given string from the beginning and from the ending (possibly zero or all). We are given a string and we have to get all the substrings of it and take XOR of it. XOR is a bitwise operator that gives the result − if both the bits are the same then it will return zero otherwise 1. Input string str = "10101" Output XOR of all ...
Read MoreMinimum cost to delete characters from String A to remove any subsequence as String B
We are given two strings string A and string B along with an array that represents the cost to delete the ith character of the given string A. We need to delete some characters of string A (possibly zero or none) with the minimum cost such that no subsequence of A represents string B. We are going to see three approaches to implementing the code that is the recursive approach; the recursive and memoization approach; and tabulation or iterative dp. Example Let's have a look at the following example − Input string a = "xanxd" string b = ...
Read MoreTransform string A into B by deleting characters from ends and reinserting at any position
Anagram of a string means a string contains exact same characters as another string with the order of characters may vary from the original string, so we called that both strings are anagram of each other. Here we have given the two strings first and second which are anagrams of each other. And our task is to minimize the count of operations to make the first string as second string. An operation is that we can delete an character from the begin or end of an first string and reinserting at any position. Sample Example Input First: "hello", Second: "ohlle" ...
Read MoreCount of possible distinct Binary strings after replacing 11 with 0
A binary string is a string that contains only two types of different characters zeroes and ones. We can replace a substring '11' of the given string with another string '0' and we have to find the number of different possible strings we can get from it. We are going to use dynamic programming to get the solution as other methods may take exponential time complexity. Sample Example Input string str = 11010 Output 2 Explanation We can replace the first two numbers with the zero and can get another string 0010 and the second string is the ...
Read MoreHow to Move Minus Sign from Right to Left/Back to Front in Excel?
Powerful spreadsheet software like Excel provides a variety of formatting choices to improve the way your data is presented. On occasion, you might need to move a negative sign inside a cell in order to obtain the correct formatting. This video will walk you through the essential procedures whether you want to relocate the minus sign to the left of a number or bring it back to the front. By the time you finish this article, you will be able to use minus signs in Excel to accomplish the desired formatting. Let's start now! Move Minus Sign from Right to ...
Read MoreHow to Move Last Word to Next Adjacent Cell?
Learning how to use Excel's robust features can dramatically improve your productivity and data organisation, whether you're a novice or a seasoned user. In this article, we'll walk you through each step of an effective technique to move the last word from one cell to the one next to it. We will presume that you are familiar with Microsoft Excel and its foundational ideas throughout this lesson. But don't worry if you're just getting started with the software! To help you understand each step clearly, we will give you clear instructions and illustrated examples. Move Last Word to Next Adjacent ...
Read MoreHow to Move Last Character to Front of a Cell or Another Column in Excel?
When working with data that needs rearranging or editing language, this straightforward yet effective technique can be immensely helpful. Moving the last character to the front can help you get the answers you want quickly and effectively, whether you want to change the format of your data or carry out special computations. In this article, we'll look at a number of approaches and formulas that let you complete this operation with ease. You will be well-equipped to manipulate your data after completing this session if you know how to bring the last character in a cell or column to ...
Read MoreHow to Move Highlighted Cells to Top in Excel?
Excel, the powerful spreadsheet software, is widely used for organizing and manipulating data in various industries and professions. When working with large datasets or complex worksheets, it's common to highlight specific cells that require special attention or categorization. However, once highlighted, these cells may get lost within the extensive spreadsheet, making it challenging to locate and analyse them efficiently. In this tutorial, we will guide you through a simple and effective technique in Excel to move highlighted cells to the top of your worksheet. This feature proves particularly valuable when you need to quickly isolate and work with specific data ...
Read MoreHow to Move Entire Row to the Bottom of Active Sheet Based on Cell Value in Excel?
This tutorial will show you how to rearrange rows in an Excel spreadsheet depending on predetermined criteria using a straightforward yet powerful technique. There are many situations where Excel data needs to be sorted or rearranged. To prioritise or separate specific rows from the rest of the data, for example, you could wish to place them to the bottom of the sheet. This tutorial's main goal is to accomplish this by selecting which rows to relocate based on a cell value. We'll assume you have a fundamental understanding of Excel and its features going into this course. By the conclusion, ...
Read MoreHow to Move Entire Row to Another Sheet Based on Cell Value in Excel?
If you routinely work with large datasets or need to efficiently organise your data, this lesson will show you how to automate the transfer of rows based on specific criteria. Excel is an effective tool for organising and analysing data, and by utilising its features and functionalities, we can automate time-consuming procedures to save effort and save time. For instance, it is commonly required to shift entire rows to another sheet depending on a cell value while filtering and categorising data. Move Entire Row to Another Sheet Based on Cell Value Here, we will first create a VBA module and ...
Read More