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
Palindrome by swapping only one character
In a C++ environment, the palindrome is a process where a set or string remains same from the intial stage of the process to termination of that same particular process. Assume, we have a string denoted as the str[]. And the task is to check the string will be paindrome or not after performing the swapping process with only one character for once. Here is a general example of the swapping process − Input : ARBRDD Output : true Explanation: Swap the value A(1st index present in the list) with the R. Input : INDBAN Output : true Explanation: ...
Read MorePrint reverse string after removing vowels
The reverse() is a pre-installed and predefined header file, which is used to define as a template in a process in a C++ environment. The method is able to reverse the elements from last to first manner in a range for any value container. For this process the time complexity is O(n). Lets assume, we have a string or a sentance declared as str[] with some data elements and now the task is to perform reverse process after removing the vowels from that string to get the final outcome. Here is some general examples of the process method − ...
Read MoreProgram to reverse a string (Iterative and Recursive)
The reverse() is a pre-installed and predefined header file, which is used to define as a template in a process in a C++ environment. The method is able to reverse the elements from last to first manner in a range for any value container. For this process the time complexity is O(n). Lets assume, we have a string declared as str[] with some data elements and now the task is to perform reverse process on this string to get the final outcome. Here is a general example of the process − Input string is here : S = "ARBRDD" ...
Read MoreCount palindromic characteristics of a String
In a C++ environment, the palindrome is a characteristics where we get the same value after getting the result. Assume, there is a string denoted as S and the length is N. Now we need to run an operation on that string to find the palindromic characteristic is the number of k-palindromes in a given range. Here is a general example of the process − Input for the process : abba Output by the process : 6 1 0 0 Explanation of the method: "6" 1-palindromes numbers operation = "a", "b", "b", "a", "bb", "abba". "1" 2-palindromes numbers operation ...
Read MoreHow to quickly list all hyperlinks in Excel?
Hyperlinks enable easy access to external resources such as websites, documents, emails, or even specific locations within other worksheets or workbooks. By simply clicking on a hyperlink placed within an Excel cell or object (like shape), users can instantly open relevant files without wasting time manually searching their computer directories or browser bookmarks. This quick access ensures seamless integration with other applications while maintaining workflow efficiency. While many are familiar with hyperlinks in web pages, they can bring tremendous benefits when used within an Excel workbook too. Quickly Restoring all Hyperlinks Using “Replace Option” Step 1 To expedite the process ...
Read MoreHow to quickly insert unique sequence numbers in Excel?
Introduction Unique sequence numbers provide a simple yet effective way to track and identify individual entries within a dataset or database. By assigning each record a distinct number, it becomes effortless to locate specific information during analysis or filtering processes. This feature significantly improves data management by reducing time spent searching through vast amounts of information manually. We can set up macros or formulas that automatically generate the next unique sequence number for new entries, preventing human errors in the numbering process and ensuring consistency across updates. Quickly Inserting Unique Sequence Numbers Using “AutoFill” Feature Step 1 Excel's built-in AutoFill ...
Read MoreHow to create the Venn diagram in Excel?
Introduction Microsoft Excel is an efficient tool that is used to create interactive charts that more precisely visualize the data. Professionals are said to utilize charts as a tool for graphically communicating ideas or sharing data. Among them, the Venn diagram facilitates the relationships between the defined data in the given range or items that consist of three circles by default, each of which specifies the column data. In this article, we will learn how to insert the basic Venn ...
Read MoreHow to create a User Defined Function to determine the type of triangle in Excel?
Introduction Manually identifying the type of triangle among the massive datasets is challenging, time-consuming, and susceptible to errors. VBA is one of the prominent applications in Excel where users can customize the functions and resolve complex tasks efficiently. In this article, we will develop the user-defined function in the VBA to identify the triangle’s type. Key Points to Remember Before Writing the User-defined Function Equilateral triangles are those whose all ...
Read MoreSTOCKHISTORY function in Excel 365
Introduction Excel is a powerful tool for organizing and analyzing data, but manually searching through the history of financial data from different resources can be time-consuming. In this article, we will gain deep insights into the StockHistory function that is available only in Microsoft 365 and returns the array describing the stock history of financial data along with the specific dates that users specified in a range. The benefits of the StockHistory function include time savings, flexibility, comparative analysis, and ...
Read MoreHow to count the number of items through Spin Button in Excel?
Introduction Excel is not limited solely; it empowers efficient collaboration when dealing with large volumes of interconnected data. By utilizing Form Controls and Active X controls functionality, several team members can link the cell reference, and populate the calculation through these interactive controls which ensures the integrity of the entire dataset. Better user interfaces, greater versatility, and improved application structure are also possible. Users may quickly add text boxes, a drop-down menu, a spin button, and ...
Read More