beginners

#36 — Match The First Part of The Cell Value

#36 — Match The First Part of The Cell Value

Problem description & analysis:An Excel worksheet has multiple columns of source data that contains empty cells, as the following range C3:D19 shows. It also contains data items, which are separated into two parts by “-”, used for comparisons, as range F3:F7 shows. Task: Compare each column of the source data with the first part of the data item, and after each column of data, list all matching data items, as shown below: Solution:Use SPL XLL to do this: =spl("=d=transpose@n(?1),transpose@n(d.(E@1(?2).select(d.~.pos(substr@l(~,$[-])))))",C3:D19,F3:F7) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation:transpose@n function transposes a sequence. E@1 convers a multilayer…
Read More
Starting from Scratch: My Web Development Journey

Starting from Scratch: My Web Development Journey

Image description HELLO, I'm Saumya Singh and I'm excited to begin my web development journey, learning from the ground up. HTML, CSS, and JavaScript, here I come! I'll share my progress, ask questions, and learn from others. Join me as I navigate the ups and downs of coding. I'm ready to embrace the challenges and celebrate the triumphs. Let's grow, learn, and build something amazing together! #webdevelopment #beginner #codingjourney Source link lol
Read More
top 5 tools

top 5 tools

As a Developer, there's so much to learn, and it's very important to focus on the things that actually matter! Many developers prefer building things from scratch, but sometimes the workload is so huge that using these tools can make the job easier. In this article, I'll share 5 tools that can make you super productive and better at doing what you do the best "Build Cool Stuff" Source link lol
Read More
Encapsulation in OOP

Encapsulation in OOP

Encapsulation is a fundamental concept in Object-Oriented Programming (OOP) that binds together the data and the methods that manipulate that data, keeping both safe from outside interference and misuse. In PHP, encapsulation is achieved by using classes and objects to wrap data (properties) and methods that operate on that data. This helps to: Hide internal implementation details Protect data from external interference Improve code organization and structure Enhance data security and integrity How to achieve encapsulation in OOP php? To achieve encapsulation in PHP, we can use: Access modifiers (public, protected, private) to control access to properties and methods Constructors…
Read More
Priming My Workspace

Priming My Workspace

Separation of concerns. In the tech world, that phrase generally refers to the design principle of separating a complex system into more manageable parts. However, ever since I started working from home, I have started seeing it in other places outside of my codebase. When I worked in an office, I found it really easy to keep my space clean and organized. In hindsight that was because that space was dedicated to my job only. It was easier to disconnect from that headspace once I was done with my work because the work was literally in a different location. But…
Read More
java

java

What is Java?Java is a programming language and a platform. Java is a high level, robust, object-oriented and secure programming language. Java was developed by Sun Microsystems (which is now the subsidiary of Oracle) in the year 1995. James Gosling is known as the father of Java. Before Java, its name was Oak. Since Oak was already a registered company, so James Gosling and his team changed the name from Oak to Java. Platform: Any hardware or software environment in which a program runs, is known as a platform. Since Java has a runtime environment (JRE) and API, it is…
Read More
React vs. Next.js: The Ultimate Guide for Modern Web Development in 2024

React vs. Next.js: The Ultimate Guide for Modern Web Development in 2024

In the fast-paced world of web development, choosing the right tools can make or break your project. Two titans stand out in the JavaScript ecosystem: React and Next.js. But which one should you choose for your next project? In this comprehensive guide, we'll explore the features, pros, cons, and ideal use cases for both React and Next.js, helping you make an informed decision for your web development needs in 2024. Table of Contents Introduction React: The Flexible UI Library Next.js: The React Framework for Production React vs. Next.js: A Feature Comparison When to Choose React When to Choose Next.js Code…
Read More
viewabilityConfigCallbackPairs

viewabilityConfigCallbackPairs

I have one question now is it limitation to React-Native orr.. it is not possible by any means Problem:I have nested flatList How to apply or get the ItemLayout orr viewabilityConfigCallbackPairs so that i can perform certain actions within that child renderItem/>const renderItem = ()=>{onScroll={() => {console.log('onScroll =>');}}onLayout={event => {console.log('onLayout =>', event.nativeEvent.layout);}}getItemLayout={(data, index) => {return {length: 100, offset: 100 * index, index};}}viewabilityConfigCallbackPairs={viewabilityConfigCallbackPairs.current}/> Source link lol
Read More
No widgets found. Go to Widget page and add the widget in Offcanvas Sidebar Widget Area.