Excel ConcatenationTLDR; Excel concatenation is a powerful tool for combining different text, number, or date values into a single string. The basic syntax of concatenation in Excel is to use the “&” operator to join two or more strings or values. We can also use the CONCATENATE function or the new… Read More »Combine Text, Numbers and Dates into a Single String with Excel Concatenation
Nested Loops for PerformanceTLDR; Nested loops are a programming construct providing increased complexity and ability to process multi-dimensional data, but at expense of slow performance and difficulty in debugging. To optimize, avoid too many nested loops, use early exit conditions, and use appropriate data structures. Debugging can be done with print statements, debugger,… Read More »Optimize & Debug Nested Loops for Performance
OperatorsBash is known for its flexibility, versatility, and ease of use. In this blog, we’ll explore the various bash operators and how they can be used. Prerequisites Before diving into the bash operators, it’s important to have a basic understanding of the following concepts: Bash Operators: An Overview Bash operators… Read More »Get a Grip on Arithmetic, File and String Operators
Bash FunctionsFunctions allow you to group a series of commands into a single unit that can be called with a single command, making it much easier to reuse complex or frequently used commands. Prerequisites Before diving into bash functions, it is important to have a basic understanding of the Linux shell,… Read More »Simplify Complex Operations with Bash Functions
Bash FunctionsAre you tired of constantly typing out long, repetitive commands in your terminal? Do you wish there was a way to simplify your workflow and increase your productivity? Look no further! In this blog, we’ll explore the power of functions in Bash and how you can use them to streamline… Read More »Streamline Your Workflow with Bash Functions
Single- or Double Quotes in BashIntroduction Are you curious about when to use single- or double quotes in bash? Do you need to know the requirements and dependencies for this to work? Look no further! In this blog, we’ll discuss the fundamentals of single- or double quotes in bash, provide examples and tips, and finish… Read More »Dispelling the Mystery of Single- or Double Quotes in Bash
Permanent Aliases in PowerShellAre you tired of having to re-create your aliases every time you open a new PowerShell terminal? Don’t worry, there is a solution! In this blog, we will explore how to create permanent aliases in PowerShell, even after reloading the terminal. What are Aliases? Aliases in PowerShell allow you to… Read More »Creating Permanent Aliases in PowerShell