teleren/devto huggingface dataset:
A lesson about Continuous Deployment - 10 years in the making
Tags: agile, productivity
Published: 2020-10-22 08:48:36

~10 years ago [Joshua Kerievsky](https://twitter.com/JoshuaKerievsky) taught me a lesson that only yesterday I finally came to understand.

Or at least this is how I now understand his feedback.

# The lesson

You must do Continuous Deployment / Delivery. If you are not doing it, you are competing in the wrong league.

If you're not doing CD because the thing you are working on just isn't ready for it, you must be following a plan with the goal of being finally able to start doing CD.

If you are doing CD, your software is leaner, more flexible, well organized. Your processes are smooth and possibly automated. You have the minimum requirements for taking your chances in A-league.

# The anecdote

~2010 I was working at a company whose main product was a Java web framework with an Open Source core and some paid-for plugins.

I was the main frontend developer and also the DevOps guy.

We demoed the product to a potential investor, and Joshua followed up with an interview as a technical advisor to the investor.

This is how I remember it:

Joshua: So how do you guys distribute the product? Are you doing Continuous Deployment?

William: Well, the product is actually more of a lib, and it most certainly isn't a SaaS, so we c

Joshua: You should do CD. If you are not doing CD you are competing in the wrong league.

W: Let me rephrase, the product is

J: I got it the the first time :) but if you are not doing CD I think it's better - and he turned towards the investor - if we talk again when you are doing it.

Shortly after, hands were shaken, goodbyes were given, and off we went.

On our way out of the building, we brainstormed about the feedback we got, and we all agreed we didn't understand how it was even possible to continuously deploy a **lib**. Maybe he did mean Delivery instead of Deployment? But surely no one would ever abandon GitFlow! But then how...

One of the cofounders, who had been knowing Joshua for years, then told me: "I know, I don't understand it either. But if he said it, some day we most certainly will."

# "Some day" was yesterday

Yesterday I started a proposal to abandon GitFlow for some form of trunk-based development at my current company.

A couple hours later, I stumbled upon [this post by Joshua](https://medium.com/@JoshuaKerievsky/your-sacred-software-scroll-experiencing-technical-debt-d0562bb93a5e) about technical debt.

The topic is slightly unrelated, but seeing who the author was made me think about that day of years ago and it finally clicked.

In the current status of the software development industry, you must be doing Continuous Development / Delivery, **and if you don't, you must be willing to do it**. Meaning that you must be following some well-thought plan that will finally enable you to do it.

Or you will be competing in some B-league. And it's fine, but you should at least be aware of the circumstances you find yourself in.
Formulas to Lookup a Value and Return a Different Cell From the Table!!
Tags: excelformula, excelformulas
Published: 2020-10-22 12:14:32

---
title: Formulas to Lookup a Value and Return a Different Cell From the Table!!
published: true
date: 2020-10-22 08:45:02 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-lookup-a-value-and-return-a-different-cell-from-the-table/
---

Here, we will guide you to learn the Functions and  **Formulas to Lookup a Value and a Return a different cell from the table in Excel Office 365**. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Formula Syntax:

- To **[Lookup a value and return a Different cell from the table](https://geekexcel.com/how-to-lookup-a-value-and-return-a-different-cell-from-the-table-in-excel/)**, use the below formula.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)([$D$3](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/),$A$1:$B$10,[COLUMN](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)($B$1:$B$10)-COLUMN($A$1:$B$10)+1,0)**

### Example:

- Let’s consider the following table to look up a value and returns into the different cell.
- First, you need to enter the inputs as shown below.
- Then, enter the given formula in the selected field.
- After applying the formula, you can get the results as shown in the image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-4.png)

## Explanations for Syntax:

- **VLOOKUP** – This function will lookup data in a range or table by row. Read more on **[VLOOKUP Function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **COLUMN** – In Excel, the main purpose of this function is to return the column number for reference. Read more on [**COLUMN Function**](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/).
- **Absolute Reference ($)** -The**[Absolute reference](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)** function in Excel is an actual fixed location in the worksheet. It won’t be changed when copied to a new location.
- **Plus operator (+)** – This symbol will help to add the values.
- **Minus Operator (-)** – This symbol is used for separating two numbers or values.
- **Division (/)** – The main purpose of this operator is to divide the values or numbers.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – This symbol will help to group the elements.

## Verdict:

In this short tutorial, we described the basic syntax, formula explanation with a suitable example. Use these **formulas to Lookup a value and return it to a different cell from the table** in Excel Office 365. If you have any **suggestions,** leave it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**
Excel Formulas to Reverse Order of Characters in a Cell with Functions!!
Tags: excelformula, excelformulas
Published: 2020-10-22 12:14:41

---
title: Excel Formulas to Reverse Order of Characters in a Cell with Functions!!
published: true
date: 2020-10-22 08:43:13 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-reverse-order-of-characters-in-a-cell-with-functions/
---

Here we will discuss the Functions and **Formulas to Reverse Order of Characters in a Cell in Excel Office 365**. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Formula Syntax:

- The below Formula is used to **[Reverse the order of characters in a cell](https://geekexcel.com/reverse-order-of-characters-in-a-cell-with-functions-in-excel-office-365/)** with an Excel function.

**=REVERSETEXT(A2,”,”)**

### Example:

- Let’s consider the below table to reverse the order of characters in a cell.
- First, you need to enter the input names as shown in **Column A**.
- Then, enter the given formula in the formula bar section.
- After that, you can get the results in the selected column as shown in the image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-3.png)

## Explanations for Syntax:

- **REVERSETEXT** – This function will reverse the order of the given text string. It is available only on Excel **Kutools** Functions.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – This is used for grouping the elements.

## Verdict:

In this short tutorial, we explained the functions and formulas used in Excel Office. You can also learn the **formulas to reverse the order of text string in a cell** with a suitable example. If you have any **queries,** leave in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- **[Formula to Find the Most Common or Frequently used Values In Excel!!](https://geekexcel.com/formula-to-find-the-most-common-or-frequently-used-values-in-excel/)**
- **[Formula to Find Position of Nth Occurrence of a Character in Text String!!](https://geekexcel.com/formula-to-find-position-of-nth-occurrence-of-a-character-in-text-string/)**
- **[Excel Formula to SUM Absolute Value in a Range ~ A Simple Guide!!](https://geekexcel.com/excel-formula-to-sum-absolute-value-in-a-range-simple-guide/)**
- **[Formulas for Counting the Number of Words in a Cell or Range in Excel!!](https://geekexcel.com/formulas-for-counting-the-number-of-words-in-a-cell-or-range-in-excel/)**
Formulas to Extract Numbers From Mixed Text String with Function!!
Tags: excelformula, excelformulas
Published: 2020-10-22 12:14:50

---
title: Formulas to Extract Numbers From Mixed Text String with Function!!
published: true
date: 2020-10-22 08:41:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-extract-numbers-from-mixed-text-string-with-function/
---

In this short tutorial, we will guide you to learn the simple **Formulas to Extract Numbers From Mixed Text String with Function in Excel Office 365** with its function explanations. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Formula Syntax:

- Use the below Formula to **[Extract the number from mixed text string with function](https://geekexcel.com/extract-numbers-from-mixed-text-string-with-function-in-excel-365/)**.

**=EXTRACTNUMBERS(B2)**

### Example:

- The below table shows how to extract the number from the mixed text in a function.
- If you have the input ranges like **Column A** , you need to enter the given formula.
- After applying the formula, it will display the output as shown below.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-4.png)

## Syntax Explanations:

- **EXTRACTNUMBERS** – It is one of the Excel function which is available only in **Kutools.** The main purpose of this function is to separate the numbers from a mixed text.
- **Parenthesis ()** – This is used for grouping the elements.

## Closure:

From this article, you can easily understand the function to separate the numbers from mixed text strings and numbers. You can also learn the **formulas to extract numbers from the mixed text strings with function in Excel Office 365**. If you have any **doubts,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- **[Formula to Count Number of Weekends/Weekdays/Specific Day of Week!!](https://geekexcel.com/formula-to-count-number-of-weekends-weekdays-specific-day-of-week/)**
- **[Excel Formulas to Add Hours/Minutes/Seconds to a Datetime!!](https://geekexcel.com/excel-formulas-to-add-hours-minutes-seconds-to-a-datetime/)**
- **[Formulas for Counting the Number of Bold Cells in a Range In Excel!!](https://geekexcel.com/formulas-for-counting-the-number-of-bold-cells-in-a-range-in-excel/)**
- **[Formulas to Sum Bold Values or Numbers Only ~ Simple Method!!](https://geekexcel.com/formulas-to-sum-bold-values-or-numbers-only-simple-method/)**
Excel Formula to Count the Occurrences of a Character in a String!!
Tags: excelformula, excelformulas
Published: 2020-10-22 12:15:01

---
title: Excel Formula to Count the Occurrences of a Character in a String!!
published: true
date: 2020-10-22 08:39:56 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-to-count-the-occurrences-of-a-character-in-a-string/
---

In this article, we will guide you to know the simple and useful functions of Excel Office 365. This page will describe the **Formula to Count the Occurrences of a Character in a String** with its suitable example. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Formula Syntax:

- To **[Count the Occurrences of a Character in a String](https://geekexcel.com/count-the-occurrences-of-a-character-in-a-string-in-excel-office-365/)** in Excel Office, use the below formula.

**=COUNTCHAR(B2,”e”)**

### Example:

- In the below table, we will explain how to use the formula to count the occurrences of a character.
- First, you need to give the input as shown below.
- Then, enter the given formula in the selected formula bar section.
- After that, you can get the output as shown in the image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-10.png)

## Explanations for Syntax:

- **COUNTCHAR** – In Excel, the **COUNTCHAR Function** can quickly count the number of times the character appears in a text string. This function available on **Kutools** function in Excel
- **Comma**  **(,)** – It is a separator which helps to separate a list of values.
- **Parenthesis**  **()** – This is used for grouping the elements.

## Summary:

From this article, we explained the information on the function and **formula used to count the occurrences of a character from a string in Excel Office 365**. Kindly, drop your **feedback** in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- **[Excel Formula to SUM Absolute Value in a Range ~ A Simple Guide!!](https://geekexcel.com/excel-formula-to-sum-absolute-value-in-a-range-simple-guide/)**
- **[Excel Formula for Finding Vlookup Value Between Two Numbers!!](https://geekexcel.com/excel-formula-for-finding-vlookup-value-between-two-numbers/)**
- **[Formula to find Vlookup & Return Matching Values from Multiple worksheet](https://geekexcel.com/formula-to-find-vlookup-return-matching-values-from-multiple-worksheet/)**
- **[Formulas for Finding Largest Value Smaller than a Specified Number!!](https://geekexcel.com/formulas-for-finding-largest-value-smaller-than-a-specified-number/)**
Testing React createPortal with Testing Library
Tags: testing, react, jest
Published: 2020-10-22 08:33:01

I have a component that uses `ReactDOM.createPortal` and appends it to a DOM node that is passed as a prop. However, I couldn't find a good example of testing it using Testing Library.

I've created a [CodeSandbox](https://codesandbox.io/s/reactdomcreateportal-testing-x1icz) with some extended tests if you want to follow along using an interactive example.

```jsx
// App.js
import React, { useEffect, useState } from 'react'
import ReactDOM from 'react-dom'

const App = ({ root }) => {
  const [container] = useState(document.createElement('div'))

  useEffect(() => {
    root.appendChild(container)

    return () => {
      root.removeChild(container)
    }
  }, [container, root])

  return ReactDOM.createPortal(<div>Portal content</div>, container)
}

export default App
```

The component receives a DOM node, `root`, through props. The portal component is then appended to `root` inside `useEffect`.

At first, I thought that I could use `screen.getByText` to get the text "Portal content", but since the content is mounted to `root` I can't use the `screen` queries.

```jsx
// App.test.js
import { render, within } from '@testing-library/react'
import React from 'react'
import App from './App'
import '@testing-library/jest-dom/extend-expect'

test('appends the element when the component is mounted', () => {
  const root = document.createElement('div')

  render(<App root={root} />)

  const { getByText } = within(root)

  expect(root).toContainElement(getByText(/portal content/i))
})
```

After some searching, I found `within` – also called `getQueriesForElement` – in the [Testing Library docs](https://testing-library.com/docs/dom-testing-library/api-helpers#within-and-getqueriesforelement-apis) which seemed to fit this case perfectly. Passing `root` to `within` gives me all the queries that I'm used to from `screen`.

Using `toContainElement` from `jest-dom/extend-expect` I can then write an assertion that is similar to how I would normally write it.

```jsx
// Our example
expect(root).toContainElement(getByText(/portal content/i))

// How I would normally test it
expect(screen.getByText(/portal content/i)).toBeInTheDocument()
```
Gmail Backup Expert – Backup Software for Google Mails Gmail
Tags: gmailbackup, backupgmaildata
Published: 2020-10-22 07:46:12

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/6gg331lfek5f1nixa4w4.png)

Get this amazing solution Regaintechnologies Gmail Backup tool that provides you backup of Gmail data without any data loss risk. This software easily Provides backup of your Gmail data file with all mailbox items like: emails, contacts, events, Google docs, spreadsheets, images, videos, and more. You can see the preview of all your emails items before the backup. This software compatible with all the versions of Windows OS.

Get this software free trial version from here: https://www.regaintechnologies.com/gmail-backup.html
Gmail Backup Expert – Backup Software for Google Mails Gmail
Tags: gmailbackup, backupgmaildata
Published: 2020-10-22 07:45:52


Get this amazing solution Regaintechnologies Gmail Backup tool that provides you backup of Gmail data without any data loss risk. This software easily Provides backup of your Gmail data file with all mailbox items like: emails, contacts, events, Google docs, spreadsheets, images, videos, and more. You can see the preview of all your emails items before the backup. This software compatible with all the versions of Windows OS.

Get this software free trial version from here: https://www.regaintechnologies.com/gmail-backup.html
My Story Of Hactoberfest
Tags: hacktoberfest, opensource, story
Published: 2020-10-22 07:42:33


Guys,
Before the month of October I don't knew how to use a git and make a pr even !
But then I meet Nikhil Anand who helped me For my first pr and he mentored me thanks Nikhil Anand bhaiya !

Thanks to the Crio.Do ,Code for Cause for introducing me to Hactoberfest !

Really guys the feeling is inexpressible it can't be explained in words !
This is my first Hactoberfest and hope to participate in future too !

In last I wanted to say thanks to Ekta Mishra Som webster Nikhil Anand and Amogh Desai  for giving me directions !

Thanks DigitalOcean Intel Corporation DEV Community for the fantastic fabulous opportunity for learning and contributing to open source !


![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ybhxx6wyov4wx9gk275u.png)
How to manage sub views for an array data - craftkit best practice
Tags: craftkit, javascript, shadowdom, webdev
Published: 2020-10-22 07:34:35

Sometimes, your sub-views has listed view created by array data. 

In such case, you have two choice to create view for them. One is make loop in the template, one is break down to simple view. 

Here is a comparison of sample product list:

```javascript 
var products = [
	{ name: 'Apple', price: 10 },
	{ name: 'Orange', price: 13 },
	{ name: 'Strawberry', price: 20 },
	{ name: 'Pear', price: 9 }
];
``` 

## Loop pattern

```javascript 
class ProductList extends Craft.UI.View {
	constructor(options){
		super(options);
		this.data = { products:options.products };
		this.views = {};
	}
	template(componentId){
		return `
			<div id="root" class="root">
				${ this.data.products.map( (product,idx) => `
					<div id="idx" class="product">
						${product.name} : ${product.price}
					</div>
				`).join('')}
			</div>
		`;
	}
}
``` 

## Factorize pattern

```javascript 
class Product extends Craft.UI.View {
	constructor(options){
		super(options);
		this.data = options;
		this.views = {};
	}
	template(componentId){
		return `
			<div id="root" class="root">
				${this.data.name} : ${this.data.price}
			</div>
		`;
	}
}

class ProductList extends Craft.UI.View {
	constructor(options){
		super(options);
		this.data = { products:options.products };
		this.views = { products:[] };
	}
	viewDidLoad(callback){
		this.data.products.forEach( p => {
			let view = new Product(p);
			this.appendView(view);
			this.views.products.push(view);
		});
	}
}
``` 

Write looping block directly in the template method is shorter than Factorise pattern. But when you control product view after appended it, you have to write something like this:

```javascript 
var target = this.shadow.getElementById('1');
target.root.style.color = 'red';
``` 

Or, you have to get the idx from the product map. This is only useful for a quick program and simple list. 

Therefore, the best practice of managing sub-views for an array data is Factorise pattern.

Always, this brings good results and ease to maintain.

🛺 Try CraftKit Playground:
https://github.com/craftkit/craftkit-playground
How to manage sub-views - craftkit best practice
Published: 2020-10-22 07:30:56

When you make complex user interface, your view has many sub-views under it. In such case, you can hold many sub-view's instance in your class directly. 

But the best practice of managing sub-views is to set them into `this.views`.

This is the same practice as `this.data` management. 

Craft.UI.View and its super-class Craft.Core.Component has many field by default. Those fields are designed to not conflict with user land usage. But sometimes it might be occurred.

To prevent field confliction, you are recommended to set your sub-views in `this.views`.

```javascript 
class Header extends Craft.UI.View {
	constructor(options){
		super(options);
		this.views = {};
	}
	viewDidLoad(callback){
		let title = new Title();
		this.appendSubView(title);
		this.views.title = title;
		
		let backbtn = new BackBtn();
		this.appendSubView(backbtn);
		this.views.backbtn = backbtn;
		
		if( callback ){ callback(); }
	}
	updateTitleText(text){
		this.views.title.setText(text);
	}
}
``` 

see also: [craftkit best practice - How to hold instance data in your view](https://dev.to/craftkitjs/craftkit-best-practice-how-to-hold-instance-data-in-your-view-4lci)

🛺 Try CraftKit Playground:
https://github.com/craftkit/craftkit-playground
Keyboards - Does backlighting matter?
Tags: discuss, watercooler
Published: 2020-10-22 07:29:43

Simple discussion - do you feel that keyboards need to be backlit, and why?

Do you currently have a backlit keyboard, and would you swap with the alternative?

---
Cover photo by [Jay Zhang](https://unsplash.com/@jay_zhang?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText) on [Unsplash](https://unsplash.com/s/photos/keyboard?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText)