teleren/devto huggingface dataset:
Magento 2 has finally been served
Tags: magento, ecommerce, webdev, migration
Published: 2020-10-15 12:04:53

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/nyx05pno13xnmty494a8.jpg)

Which means it’s time to consider your e-commerce store data migration from Magento 1 to Magento 2. If you are looking for the main reasons and benefits why you should do this, you are in the right place!

Improved functionality and powerful maintenance, which Magento 2 offers, will definitely take your business to the new level of development. Here are even more reasons:

- **Support termination**. The previous version will no longer be served, therefore new updates won’t come out anymore for Magento 1;
- **Security**. As mentioned above, since the old version is no longer refined, the customers’ information might be in danger.

For today’s time nearly half of digital stores, powered by Magento 1, chose platform migration. What benefits do they pursue?

- **Improved UX**. There is no need to waste time for account registration. New instant purchase option was added to avoid all those steps required to receive a purchase confirmation; 
- **Optimized mobile shopping**. Lion’s share of online deals is fulfilled with mobile apps. In Magento 2 mobile friendliness exists by default. The platform also enhanced page loading speed for mobile devices, which is pleasing;
- **Design**, which Magento 2 brings, is one more thing that helps to attract potential customers. From now on updated templates are able to fit screens of every device without any additional configurations;  
- **New feature AI-Powered Product Recommendations** is available for Magento 2. This extension’s aim is to ease buyers' search across the store range and to let merchants save time and shift the focus to solving other meaningful tasks.

To know more about when it is better to plan the migration process of your store and how to migrate from Magento 1 to Magento 2, please visit [this article.](https://dinarys.com/blog/magento-1-to-magento-2-migration-the-reasons-the-benefits-and-the-migration-tutorial)
Formulas for Extracting Substring Between Two Texts in Excel 365!!
Tags: excelformula, excelformulas
Published: 2020-10-15 12:03:04

---
title: Formulas for Extracting Substring Between Two Texts in Excel 365!!
published: true
date: 2020-10-15 12:00:36 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-extracting-substring-between-two-texts-in-excel-365/
---

## Formulas for Extracting Substring Between Two Texts in Excel:

In this article, we will guide you to learn how to use Formulas for Extracting Substring Between Two Texts in Excel Office 365. 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 extract Substring Between Two Texts in Excel Office 365, use the below formula.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(A2,[SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(“KDT”,A2)+[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(“KDT”),SEARCH(“version”,A2)-SEARCH(“KDT”,A2)-LEN(“KDT”)),””)**

### Example:

- In the below screenshot, we entered the input texts in **Column A**.
- Then, enter the given formula as shown below.
- After applying the formula, it displays the result in the Selected **Column B**.

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

## Explanations for Syntax:

- **IFERROR** -In Excel, the IFERROR Function is used to display the custom result when the formula generates an error and it will show the standard results when no error detected. For more details about the [**IFERROR Function**](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/).
- **MID** – The main purpose of the**[MID Function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)** is to extract the numbers or characters in a given string.
- **SEARCH** – This function will locate the character between two text strings and returns the location on the one text string inside another. Read more on the [**SEARCH Function**](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/).
- **LEN** – The Excel [**LEN Function**](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/) is used to return the length of the text string as a number. It also counts the characters.

## Bottom Line:

In this article, we guided you to know the details about the **Formulas to Extract Substring between Two Texts in Excel Office 365**. If you have any **queries,** kindly share it in the below **comment** box. Thank you for visiting **[Geek Excel](https://geekexcel.com/)!!**
Daily Developer Jokes - Thursday, Oct 15, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-10-15 12:00:16

---
title: "Daily Developer Jokes - Thursday, Oct 15, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Thursday%2C%20Oct%2015%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e125970d9ec2.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ What is a pirate's favorite programming language?

___A:___ You'd think it was R, but a pirate's first love is Objectively C.
 -->
"Hello World"
Published: 2020-10-15 04:20:38

I am sitting here at my desk, in week five of my fourteen week bootcamp, blown away at how fast everything is moving. It is an amazing and terrifying feeling knowing that I am almost half-way done. After finishing our first capstone project, my instructor started our lecture out, the next day, by saying six words that have been stuck in my head ever since, "You are all officially Java developers”. It’s crazy to me how far I have come in a mere five weeks. As cliché as it sounds, it feels like just yesterday I was writing those famous words "Hello World". I realize now that “yesterday" was actually five weeks ago and in that time, "Hello World" has come to mean so much more to me than what it sounded at first. In just a few weeks I will be re-entering the world as a software developer, with a new job and new life. For so long I never believed I could do this and there is no better feeling than proving myself wrong. I am officially a bi-racial, female Java developer and I am beyond excited to continue learning, growing, and proving my old-self wrong.
How to Unmerge Cells and Fill Down Values in Excel Office 365?
Tags: kutoolsexceltutorial, stepstounmergecellsa, kutools
Published: 2020-10-16 11:55:54

---
title: How to Unmerge Cells and Fill Down Values in Excel Office 365?
published: true
date: 2020-10-15 11:55:05 UTC
tags: KutoolsExcelTutorial,StepstoUnmergeCellsa,Kutools
canonical_url: https://geekexcel.com/how-to-unmerge-cells-and-fill-down-values-in-excel-office-365/
---

In this article, we are going to see how to **Unmerge Cells and Fill Down Values in Excel Office 365** using **Kutools** with an 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.


## Unmerge Cell and Fill Down Value:

If you want to unmerge the merged cell in the worksheet and fill down the values, follow the below steps.

- First, you need to **select the range** that you want to unmerge cells and auto-fill the remaining cells with duplicate values.

[![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-12.png)](https://geekexcel.com/?attachment_id=15753#main)<figcaption id="caption-attachment-15753">Example data</figcaption>

- On the **Kutools Tab, select** the **Merge**  **& Split** option, **choose** the **Unmerge Cells & Fill Value** option from the drop-down menu.

![Choose the Unmerge Cells and Fill Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Choose-the-Unmerge-Cells-and-Fill-Values-option.png)<figcaption id="caption-attachment-15755">Choose the Unmerge Cells and Fill Value option</figcaption>

- Now, you can see that all merged cells have been unmerged and fill down the remaining cells as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-29.png)<figcaption id="caption-attachment-15756">Output</figcaption>

### Note:

- If you want to merge adjacent cells in columns with the same data or values, refer to the below article.
- [Merge Adjacent Cells in Columns with the Same Data](https://geekexcel.com/merge-adjacent-cells-in-columns-with-same-data-value-in-excel/)

## Verdict:

In the above article, you can easily understand the steps to **Unmerge Cells and Fill Down Values in Excel Office 365** using **Kutools** with an example. Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Toggle All Hidden Columns to be Visible or Invisible in Excel](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)
- [Prevent Duplicate Entries in a Column](https://geekexcel.com/how-to-prevent-duplicate-entries-in-a-column-in-excel-office-365/)
YouTube Video | Modern ES6 - Chapter 15 - Sets and WeakSets
Tags: javascript, webdev, showdev, youtube
Published: 2020-10-15 11:51:51

In Chapter 15, we are going to learn about Sets and WeakSets.

{% youtube 4dd1yr2_PRs %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
YouTube Video | Modern ES6 - Chapter 14 - Maps and WeakMaps
Tags: javascript, webdev, showdev, youtube
Published: 2020-10-15 11:50:39

In Chapter 14, we are going to learn about Maps and WeakMaps.

{% youtube XWs4k1oSOJY %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
YouTube Video | Modern ES6 - Chapter 13 - Promises and Async await
Tags: youtube, webdev, showdev, javascript
Published: 2020-10-15 11:49:03

In Chapter 13, we are going to learn about Promises and async-await.

{% youtube uZlOQjulVfc %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
YouTube Video | Modern ES6 - Chapter 12 - Iterators and Generators
Tags: youtube, webdev, javascript, showdev
Published: 2020-10-15 11:47:24

In Chapter 12, we are going to learn about a complex topics in ES6 - Iterators and Generators.

{% youtube ZN4m75fg7LA %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
YouTube Video | Modern ES6 - Chapter 11 - Symbols
Tags: javascript, youtube, webdev, showdev
Published: 2020-10-15 11:45:51

In Chapter 11, we are going to learn about the new primitive data type in ES6 - Symbols.
{% youtube vzvuDtoCE7A %}

Please do like it and [Subscribe](https://www.youtube.com/channel/UCRf7mazcufqZxd2pR3oQJuQ?sub_confirmation=1) to my channel for more videos.
Lotus Notes a la herramienta de Outlook para convertir NSF a PST con correo electrónico, contactos, calendario
Published: 2020-10-15 11:43:37

Lotus Notes to Outlook Converter es una aplicación de reubicación de correo electrónico confiable y segura para enviar sobres de buzón postal de Lotus Notes a Outlook. Seleccione el de GainTools <a href="https://www.gaintools.com/nsf/pst/">NSF a PST conversión software</a> comprender el funcionamiento de la aplicación y los aspectos más destacados antes de comprar el permiso de liberación de la utilidad.

Lotus Notes a Outlook se ha convertido en una tarea de cambio típica en la actualidad. Ambas son aplicaciones de correo electrónico conocidas y ampliamente utilizadas para la información comercial, comenzando con un lugar y luego con el siguiente.

Además, Lotus Notes se puede utilizar con diferentes bases de información y aplicaciones de Domino. Guarda todos los mensajes, contactos y otros datos en un registro .nsf.

El punto de vista, por otro lado, también habló como administrador de información personal. Es un aspecto de Microsoft Office Suite. La mayor parte de 1,000,000 de la población usa la aplicación Outlook para enviar / obtener información comenzando con un lugar y luego en el siguiente. Ayuda a supervisar mensajes, libretas de direcciones, horarios, asignaciones, registros, archivos, diarios y diferentes cosas en el disco duro. Asimismo, hace un organizador PST solitario para almacenar la base de información conectada, por ejemplo, contactos, mensajes, horarios, etc.

<b>Fin:</b>

Dos técnicas para enviar organizadores de Lotus Notes a Outlook con mensajes, contactos y horarios. La estrategia manual es aceptable para ejecutar, sin embargo, hay muchas desventajas relacionadas con ella. El arreglo externo es una metodología inmediata y segura cuando se compara con la estrategia manual para la transformación de Lotus Notes a Outlook. Experimente el funcionamiento del producto descargando la demostración gratuita del instrumento que permite intercambiar 10 NSF iniciales a PST sin costo.
Best and Free OLM to PST Converter Software to Convert and Export OLM to PST
Tags: olmtopst, olmtopstconverter, migrateolmtopst
Published: 2020-10-15 11:43:03

Here I'll suggest you this Outlook OLM to PST Converter software which comes with so many advanced and unique feature like- batch conversion option, save attachments, preview facility and so many. With its user friendly graphical interface Both user technical or non technical can easily understand and with with software without any hassle. All users both technical or non technical can easily use this software without any technical skill and it maintain the data integrity during conversion. Download this free trial version enables you to convert OLM emails to pst files and will show you the converted emails in preview items. 

Use this discount coupon ( MANNAT15DIS ) to Get 15% Discount on Checkout Page.

Read more:- https://www.emailsoftwares.com/olm-to-pst-converter.html
What is an OLM to PST Converter Software
Tags: olmtopst, convertolmtopst, migrateolmtopst, olmtopstconversion
Published: 2020-10-15 11:41:58

To convert your Mac OLM to PST format i want to recommend you this advanced OLM to PST converter software which is an intelligent software that can easily convert Mac Outlook OLM files into Outlook PST. After scanning process, It will save your scanned file which can be used in future for re scanning. Technical or non technical both can easily use this software without any technical skill. It has enhanced easy to use user friendly interface to make this software fast and simple. 

Use this discount coupon ( SYSWIN20OFF ) to Get 20% Discount on Checkout Page.

Visit it free demo version to more info:- http://www.olm-to-pst.recoverydeletedfiles.com/
Hacktoberfest -a opportunity to shine
Tags: hacktoberfest
Published: 2020-10-15 11:41:00

## What I Learned From Hacktoberfest

<!-- What did you learn that can help others contribute to the project you worked on? What did you learn that can help the users of that project?! -->
* First i learn about github.
* Then basic terminologies like pull request and push request.
* They offer you t-shirts on 4 pull requests that's the best part(FREE).
* I am very eager to participate in next year's event.
Convert OLM to PST in Outlook by using OLM to PST Conversion Software
Tags: olmtopst, olmtopstconverter, convertolmtopst
Published: 2020-10-15 11:36:55

If you use manual process to convert OLM data into PST format is little bit risky. Manual method is very lengthy process which take lots of time to process and technical person can enable to run this process. then There is no better method to move Mac Outlook OLM to PST by using this OLM to PST converter software which can easily convert multiple OLM files to PST format With all attachments and also to converts OLM files to various file types such as EMLX, MSG, PST, MBOX, EML, HTML, and PDF. All users both technical or non technical both can easily use this software without any technical skill and provide free demo version, with which you can easily check its all feature and functions in same panel. It allow you to export and save 25 items per folder.

Use this discount coupon ( SYSWIN20OFF ) to Get 20% Discount on Checkout Page.

Visit here to know more:- https://www.recoverfilesdata.com/olm-pst-converter.html
HTML5 Tags at a glance
Tags: html, 100daysofcode, codenewbie, webdev
Published: 2020-10-15 11:34:00

Let us have a look at common HTML5 tags.


### Document Outline

```html
<!DOCTYPE>         <!-- Version of (X)HTML -->
<html>                <!--HTML Document-->
<head>               <!--page information -->
<body>               <!-- Page Contents -->
``` 

### Page Information


```html
<base/>       <!-- Base URL -->
<meta/>       <!-- Meta data -->
<title>          <!--Title -->
<link/>         <!-- Relevant resource -->
<style>        <!-- Style resource -->
<script>       <!-- script resources --> 
``` 

### Links

```html
<a href="">                   <!-- Page link -->
<a href="mailto:">        <!-- Email link -->
<a name="name">        <!-- Anchor -->
<a href="#name">        <!-- Link to a anchor -->
``` 

### Document Structure

```html
<h1><h6>       <!-- Headings -->
<div>               <!-- Page section or a division -->
<span>            <!-- Inline section -->
<p>                  <!-- Paragraph -->
<br/>                <!--Line break -->
<hr/>                <!-- Horizontal line -->
``` 

### Forms

```html
<form>        <!-- form -->
<fieldset>    <!--collection of fields -->
<legend>     <!-- Form legend -->
<label>         <!-- Label for Input -->
<input />      <!-- Input fields-->
<select>       <!-- Drop-down box -->
<optgroup>  <!--Group of options -->
<option>     <!--Drop down options -->
<textarea>   <!--Large text Input -->
<button>       <!-- A button  -->

``` 

### Tables

```html
<table>              <!-- Table -->
<caption>          <!-- For Caption -->
<thread>           <!--Thread -->
<tbody>            <!-- Table body -->
<tfoot>              <!-- Table foot -->
<colgroup>      <!-- Column Group -->
<col/>                <!-- column -->
<tr>                   <!-- table row-->
<th>                   <!-- Header Cell -->
<td>                  <!-- Table cell -->
``` 

### Lists 

```html
<ol>       <!-- Ordered List -->
<ul>       <!-- UnOrdered List -->
<li>        <!-- List Item -->
<dl>       <!-- Definition List -->
<dt>      <!-- Definition term -->
<dd>     <!-- Term description -->
``` 

Okay, I think I almost covered all common HTML Tags we often use. If I miss one in case ?, Please DO let me know!

Thanks for the read.

> Lets connect on  [Twitter](https://twitter.com/saiteja0413) 

Happy Coding :)
Meet Silq- The First Intuitive High-Level Language for Quantum Computers
Tags: ai, quantum, computing, programming
Published: 2020-10-15 11:29:30

Sometime in the 1970s, the computing world hit its first major breakthrough - Dennis Ritchie and Ken Thompson at AT&T Bell Laboratories founded the Holy Grail of C programming. It took another 50 years for programmers to achieve a milestone of similar force - a language that brought a comparable level of simplicity and functions to quantum computing.

Introducing Silq - “A new high-level programming language for quantum computing with a strong static type system”- the first and only one of its kind!

A Look at the 21st Century’s Big Bang

Martin Vechev, associate professor of computer science at ETH Switzerland, says it all began when his team of researchers wanted to “solve a core problem in quantum computing.” Expressing his predicament, he said:

“We looked at various problems in quantum computing but what kept coming up as a fundamental issue is that we looked at the programs and how they are expressed — and you see that this is not ideal, this is not optimal.”

The existing languages, including Microsoft’s Q# and IBM’s Qiskit, were failing to meet the high-level properties criteria required for the project. So while they did not begin with a programming end-result in their minds, necessity paved their way to it.

"Silq is the first quantum programming language that is not designed primarily around the construction and functionality of the hardware, but on the mindset of the programmers when they want to solve a problem — without requiring them to understand every detail of the computer architecture and implementation." – Benjamin Bichsel

Before we begin to analyze the programming goldmine Silq, let’s tap on a few basics:

Quantum Computing

Classical computers have been working on a series of zeros and ones. Known as the future of computing, quantum computing works in qubits, which could be ones, zeros, or both.

Read more - https://www.artiba.org/blog/meet-silq-the-first-intuitive-high-level-language-for-quantum-computers
Completed the Hacktoberfest-2020
Tags: hacktoberfest
Published: 2020-10-15 11:16:44

![Completed Hacktoberfest-2020](https://dev-to-uploads.s3.amazonaws.com/i/apj7msafx7njuicq8jxf.png)
## What I Learned From Hacktoberfest-2020
It introduced me to the world of open-source community and it was really fun!
My first Hacktoberfest
Tags: hacktoberfest
Published: 2020-10-15 11:14:17

## What I Learned From Hacktoberfest

This is my first Hacktoberfest, and I am so proud already have 5 accepted and 4 in review PR-s. For the first time I contributed to a community project, made my first MacOS app and fixed all the bugs I was aware off in my projects.
This is an amazing experience, that I will try to continoue through the whole year until next Hacktoberfest!
You can find me on GitHub: https://github.com/JRubics
My first Hacktoberfest!
Tags: hacktoberfest
Published: 2020-10-15 11:08:55

## What I Learned From Hacktoberfest

Namaste World! This is Rajdeep from India and this is my experience at Hacktoberfest 2020:
I am a computer applications student and I tried to participate in last year's Hacktober too but I could not, unfortunately.
Luckily this year I participated and also made 4 successful pull requests of which 2 got merged also and I just ordered my shirt :D 
Oh, I'm so happy right now!!! 

Learned a thing or two about git, opensource, branches, project maintenance, and how it all works, found some really cool people on the official discord of Hacktoberfest2020, and it has been a great experience altogether.
Thank you Digital Ocean and all the sponsors of the event, see you next year hopefully :)
Happy Learning everyone!!!!