teleren/devto huggingface dataset:
How to fix your automation broken by Terraform output formatting change in 0.14
Tags: terraform
Published: 2020-12-16 10:43:34

If you move to [Terraform 0.14](https://www.terraform.io/) from previous version and you are a user of the `terraform output` feature in your CI. You probably will be surprised because working automation isn't anymore.

In Terraform 0.14, the formatting of `terraform output` is modified to match the formatting of `terraform show`. Like it's explained in the [upgrade guide] (https://www.terraform.io/upgrade-guides/0-14.html#terraform-output-formatting).

For example, to get the name of a kubernetes cluster in Gke
```
output "kubernetes_cluster_name" {
  value       = google_container_cluster.primary.name
  description = "GKE Cluster Name"
}
```

In Terraform 0.13.5
```
Λ\: terraform output kubernetes_cluster_name
dev-cluster
```

In Terraform 0.14.2
```
Λ\: terraform output kubernetes_cluster_name
"dev-cluster"
```

Not a big difference, but quoted and unquoted string aren't the same value in automation. 

For example, a shell script
```sh
CLUSTER_NAME=`terraform output kubernetes_cluster_name`
gcloud config configurations create ${CLUSTER_NAME}
gcloud auth activate-service-account ...
gcloud container clusters get-credentials ... ${CLUSTER_NAME}
```

And of course, quoted string in an error message isn't as anormal as it is in this case ^^

```
ERROR: (gcloud.config.configurations.create) Invalid name ["dev-cluster"] for a configuration.  Except for special cases (NONE), configuration names start with a lower case letter and contain only lower case letters a-z, digits 0-9, and hyphens '-'.
```

The [upgrade guide] (https://www.terraform.io/upgrade-guides/0-14.html#terraform-output-formatting) give some information :
> We consider the console output of Terraform human readable;
> [...]
> If you rely on `terraform output` in automation, please use `terraform output -json`

In my test, I can't see any difference just with `-json`.

```
Λ\: terraform output -json kubernetes_cluster_name
"dev-cluster"
```

The answer to how to use it in automation and get unquoted value is more deeper in [the documentation of the output command](https://www.terraform.io/docs/commands/output.html#use-in-automation).

```
Λ\: terraform output -json kubernetes_cluster_name | jq -r .
dev-cluster
```

And here we are! 

Thanks [jq](https://github.com/stedolan/jq) to be there 😁

We can find some other alternative, like using `tr -d '"'` 
```
terraform output -json kubernetes_cluster_name | tr -d '"'
dev-cluster
```
But this will delete every `"` from the output, not only the surround one. 

I will prefer using `jq` to digest a json input.
Deep merge Objects in Javascript with Mergerino
Tags: javascript
Published: 2020-12-16 10:37:09

To merge objects in JS, you can use Object.assign.
The problem with is that it only accomplishes 'shallow merge'.

It does not take in account nested properties.

In my scripts I use Mergerino to get things done.

You can test it here : [Merge](https://flems.io/#0=N4IgzgpgNhDGAuEAmIBcIAW94AcyoHoCBXAOxwGsBzAOlgHsBbAxiAJyvYEtT6ABAAw0ALDQEEkXMPBbtObHvRoQwAVhqMeNAFZgQAGhAAzLjD2oA2qFIBDVmhA0sjKAZANSiTw5ABffdZ2EA46eoYeXvAOHtIABKwcELEAvPFy3LwAOqTZMfCxxJBsKbHA2bGxtqyosQDkACI2AG5cSLX65bE4GPSkEDUAjABMQwDMwqoAbADsABwdpBVQ9LA28Fy9NWWLFbGwXPAAnjW1AMJ2SBCk7Z0VDGTwbMd1AKoA0rWdvtm+ANy5vTixBwSDWKhK2yWKzWG1IW1uewOz1qAGVNPAMCZoG0vj9-qQYvQYDRllQABQAeQARto4PAaDYwGAuFRSGTgP4CkV9AUQWCwABKAX4gGkMBEiAk+jkhKcMmFdg84GgxCCgVuSAwBCw8wgAbTVCjAZ+AIgKrBdB0JluCJXKLoPwAXUMUB4FHMVjNQQcsoy9DcxDYrnQWFw+CIZEotAYzF9Cl4ghEYgkUhkccUyjUGi0ujcRxwFvAsAUOCivmdXvs6AAsnIeFQ-EA)

```js
const merge = mergerino

const user = {
  name: 'David',
  phone: 122345678,
  location: {
    city: 'Camden',
    country: 'UK'
  }
};
const updates = {
  location: {
    city: 'Smithfield'
  }
};
console.log(Object.assign({}, user, updates));

console.log(merge(user, updates))
```
How to get live currency rate(s) in command line
Tags: cli, commandline, currency, rate
Published: 2020-12-16 10:30:23

You need curl and jq packages:
```
sudo apt install curl jq
```

You can do this using floatrates.com API. It's updated daily at midnight. 

For USDPLN:
```
curl http://www.floatrates.com/daily/usd.json | jq .pln
```

..or for USDEUR:
```
curl http://www.floatrates.com/daily/usd.json | jq .eur
```

...and for EURUSD:
```
curl http://www.floatrates.com/daily/eur.json | jq .usd
```

and so on.
Color Game - A DO Hackathon Submission
Tags: dohackathon, javascript
Published: 2020-12-16 10:25:48

## What I built

This is a fun color game that I made using **JavaScript**. This project was made thanks to [this Bootstrap course](https://www.udemy.com/course/the-web-developer-bootcamp/). 

### Category Submission: 

Random Roulette

### App Link

https://game.boyan.ga/

### Screenshots

![color game](https://dev-to-uploads.s3.amazonaws.com/i/ag4rmx95xxra2qbc9wmt.png)

### Description
 
This is a little project I made. It is a simple JavaScript **RGB color game**. The games' goal is that you have to find the correct color. It shows a random color using RGB color code, and the player has to guess which color it is. The game has two difficulties - Easy, and Hard.

### Link to Source Code

https://github.com/bo-iliev/color-game

### Permissive License

MIT License

https://github.com/bo-iliev/color-game/blob/main/LICENSE

## Background

This project is mostly an exercise. I built it because it really helped me practice my JavaScript skills and it was super fun to do! I am still learning how to properly write code and create amazing stuff with it, and this game really helped me get up to speed.

### How I built it 

I built it thanks to [this](https://www.udemy.com/course/the-web-developer-bootcamp/) course. It was built on the Sublime Text Editor.
What is the Career & Salary of ASP.Net MVC professionals
Tags: dotnet, computerscience, career, tutorial
Published: 2020-12-16 10:11:11

An early career ASP.NET Developer with 1-4 years of experience earns an average total compensation of Rs.351,154 based on 88 salaries. A mid-career ASP.NET Developer with 5-9 years of experience earns an average total compensation of Rs.677,893 based on 13 salaries.

The . Net team has put a lot effort on this framework. I have been using this framework for over a year now and let me say, they have done a great job. In my personal opinion, I think investing time and resources into learning Asp.Net Core MVC, is well worth it.

Companies Pay For Your Knowledge

Actually in Programming Salary Always depends on Your Experience , How much work you have done , What type of work you have done , Your Creativity , Your Problem Solving Power , Your Quick Decision Making , Your Code Quality and many more

All IN All Salary Range Varies on Above Categories. It Ranges as below

Salaries Depends on You Location or region or place or city or state or country . So below are some Assumptions -

SALARIES IN USA

Average salary -

Junior Asp MVC Developer Salary In USA - $62,000 to 680000 / year

Senior Asp MVC Developer Salary In USA - $80000 to 140,000 / year

Salary In Core Aries of Technology -

Junior Asp MVC Developer Salary In USA - $92,000 / year

Senior Asp MVC Developer Salary In USA - $ 140,000 / year

SALARIES IN INDIA ( From Market Survey )

Fresher Salary - Start From Rs 7,000 -10,000 Per month

1 Year Experience - Rs 12,000 To 17,000 Per Month

2 year Experience - Rs 19,000 To 25,000 Per Month

3- 5 Year Experience - Max 50,000 Per Month

Above Salaries are only a minimum estimates But In India salary majorly depends on your companies financial status and stability. if company is rich you salary possibly will be good as compared to other companies for same position that’s simple.

For Better Suggestions Meet the Experts : https://nareshit.com/asp-net-mvc-online-training/
Top tools help graphic design  
Published: 2020-12-16 09:40:19

**Photopea**
If you are a designer Photoshop is a required tool but some people have no system in computers so they do not install Photoshop. So i mention photopea tool is same as Photoshop but not require install direct open in web browser. 

[photopea](https://www.photopea.com/)

**Stock Photos**
If you are graphic designer so most important part is picture so better picture create great design some best website they provide free stock we given list below .

[Unsplash](https://unsplash.com/)
[pexels](https://www.pexels.com/)
[freestocks](https://freestocks.org/)
[pixabay](https://pixabay.com/)

**Font**
Font is the architecture of all pictures which type font they use more attract in our social profile and interact with our customer. We give a list of websites that provide variation fonts.
[1001fonts](https://www.1001fonts.com/)
[fontfabric](https://www.fontfabric.com/free-fonts/)
[weird font](https://www.abtextgenerator.com/weird-text/)

**Colour tool**
If you know the colour combination so they feel like they are infographic, picture whatever they live. Below tool help with your colour combination.
[colordrop](https://colordrop.io/)
[coolors](https://coolors.co/)

**Icon**
Icon is a body part of a graphic. They give an attractive look of a picture so this website provides a free icon. 
[pixsellz](https://icons.pixsellz.io/)
[gumroad](https://gumroad.com/l/freeicons/)
Statistics Homework Help
Tags: statisticshomeworkhelp
Published: 2020-12-16 09:32:22

While taking my statistics course at the university I had a huge challenge with SPSS. I wouldn’t say that I was a slow learner but I found it hard to capture all SPSS concepts. After my undergraduate, I decided to major in SPSS so that I can help other students facing such a challenge. Over the last 3 years, I have now been offering Statistics Homework help through my online platform. I offer free online tutoring service for all students looking for help. Hire me for Statistics Assignment Help at cheap prices. Visit:https://www.statisticshomeworkhelper.com/
Excel Formulas to Find the Nth Smallest Value from a Range!!
Tags: excelformula, excelformulas
Published: 2020-12-16 11:01:08

---
title: Excel Formulas to Find the Nth Smallest Value from a Range!!
published: true
date: 2020-12-16 09:31:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-nth-smallest-value/
---

To find the highest or smallest value in a range may be simple for most Excel users, but how about finding or returning the second or N<sup>th</sup> highest or smallest value from a range?

Here this tutorial is going to tell you the formula to quickly return the **N<sup>th</sup> smallest value** in Excel. 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)

[![Formulas to find the Nth smallest value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-Nth-smallest-value.png)](https://geekexcel.com/excel-formulas-find-nth-smallest-value/formulas-to-find-the-nth-smallest-value/#main)<figcaption id="caption-attachment-19794">Formulas to find the Nth smallest value</figcaption>
## Generic Formula:

- Use the below formulas to find the N<sup>th</sup> smallest value.

**=[SMALL](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)(range, N)**

## Syntax Explanations:

- **SMALL** – This function returns the N<sup>th</sup> smallest value from the given range of data. Read more on the **[SMALL function](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)**.
- **Range** – It represents the input values from the given worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **N** – It represents the N<sup>th</sup> largest values.

## Example:

- For example, we have a list of values, that contains names in **Column B** and marks list in **Column C**.
- Now we need to find the first 3 smallest values from the list.
- We will define the name for the input range as **Mark.**
- Then, enter the given formula in the formula bar section.
- After that, it will show the result in **Cell F3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-57.png)<figcaption id="caption-attachment-19792">Example</figcaption>

## Conclusion:

In this way, we learned how to **find the Nth smallest value in Excel**.  Hope you like this tutorial. If you have any other **ideas** or **question,** do share with us here in the **comments** section below. Thank you. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Find the Nth Largest Value with Criteria!!](https://geekexcel.com/excel-formulas-nth-largest-value-with-criteria/)**
- **[Excel Formulas to Find the Name of Nth Largest Value with Criteria!!](https://geekexcel.com/excel-formulas-find-name-of-nth-largest-value-with-criteria/)**
Excel Formulas to Find the Smaller of Two Values!!
Tags: excelformula, excelformulas
Published: 2020-12-16 11:01:46

---
title: Excel Formulas to Find the Smaller of Two Values!!
published: true
date: 2020-12-16 09:29:20 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-the-smaller-of-two-values/
---

Sometimes, you may need to compare two cell values and return the larger or smaller one. In this article, I will introduce some simple formulas for you to extract the **smaller value from two cells** in Excel. 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)

[!["Formulas](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-smaller-of-two-values.png)](https://geekexcel.com/excel-formulas-find-the-smaller-of-two-values/formulas-to-find-the-smaller-of-two-values/#main)
## Generic Formula:

- The below formula will help to find the smallest of two values.

**=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(value1,value2)**

## Syntax Explanations:

- **MIN** – In Excel, the **[MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)** will return the smallest numeric value from the range of input values.
- **Value** – It represents the input values from the given worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Sample:

- Now, we are going to see how to find the smaller value.
- Refer to the below screenshot.
- First, we will give the input values in **Column B** and **Column C**.
- Then, enter the given formula in the formula bar section.
- Finally, it displays the result in **cell E3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-59.png)<figcaption id="caption-attachment-19806">Example</figcaption>

## Summary:

So yeah guys, this is how you can find the **smaller number from two values in Excel**. I hope it helps you. Please share your **query** below in the **comment** box. We will assist you. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Get the Minimum Value with Criteria!!](https://geekexcel.com/excel-formulas-minimum-value-with-criteria/)**
- **[Excel Formulas to Find the Maximum Value with Multiple Criteria!!](https://geekexcel.com/excel-formulas-maximum-value-with-multiple-criteria/)**
- [**Formulas to Get the Maximum Value Based on Criteria!!**](https://geekexcel.com/excel-formulas-maximum-value-criteria/)
Setup Canon MG7720 wireless printer 
Tags: canonmg7720printer
Published: 2020-12-16 09:27:57

Outrageously Easy, around 20 minutes complete, perusing VERY gradually and cautiously the quickstart direct and simply adhering to straightforward guidelines to set it up remotely to my home course
<a href="http://ijstartcanon-setup.com/blog/setup-canon-mg7720-printer-wireless/"> Setup Canon MG7720 wireless printer </a>
Setup my 1st DO App
Tags: dohackathon, beginners
Published: 2020-12-16 09:20:28

I m here to record DO setup for DO Hackathon.

![Sourced from Giphy](https://media.giphy.com/media/8rFgzA7aBR0aomiOMj/source.gif)

Now begin~~

1st create an app from DO show below
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/q3rh0gljwt3jf7n2na4p.png)

Select my 1st app in github
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/q7np514qnj2swexqu3eb.png)
** Make sure already connected with github

Config the region and branch
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/md3wzmbt9crgcx038dkl.png)
I m following the standard one

Setup my deployment information
- current I m using the default setting
- DO app platform allow to add env variables
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/bxh9qdirml7igzl2imyu.png)

After select the server plan then start deploy
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dndmuwghw1wlunk4goyo.png)
~
~
~
![Sourced from Giphy](https://media.giphy.com/media/xf20D8HzvTQzu/giphy.gif)
~
~
~
![Finally~ 😊](https://dev-to-uploads.s3.amazonaws.com/i/5v3thvp5ybbegqhfuyt0.png)

Ok my first react app deployment done

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/gg05i4eipdu3k9q3wvqh.png)
Tips on taking care of your laptop
Published: 2020-12-16 09:16:00

Taking care of your laptop prolongs the life-span, saves cost and optimizes performances of it. Here are some tips on how to maintain the good conditions of your laptop.

#### Keep food away from your laptop:

Avoid eating over or placing food on your laptop. The food crumbs might fall in between your keys and in addition make it dirty and unkempt.

#### Keep liquids away from your laptop:

  The solution to spilled liquid over your laptop is a simple rule: Keep all liquid away from your system. Whether it is your coffee, tea, food drinks or water. Even if you are careful, someone else might not be too careful as you are.

#### Keep your laptop in a cool and dust-free environment

#### Endeavor to clean your keyboard from dust at least one in a year.
 You can give a Computer Professional or do it yourself if you are knowledgeable enough to do it.

#### Always try to keep the laptop in a flat surface:
 
  This ensures that the heat generated are dispersed without being directed back into the unit and spoiling the circuitry.

#### Always endeavor to use the laptop in a well-ventilated environment.

#### Protect the screen from direct sunlight.

#### Getting a laptop bag: Many damages and issues arise from rough-handling while moving it from one location to another.

#### Avoid placing heavy items on your laptop like books, plastics as they might damage it.

#### Always make sure to plug accessories to their proper slots.

#### Always disconnect from power by pulling on the plug and not the power plug as this might cause it to break off or even damage the power cord or source.
Before You Set 2021 Goals
Tags: job, career, codenewbie, beginners
Published: 2020-12-16 09:03:06

---
title: Before You Set 2021 Goals
published: true
description: How to deal with goals setting
tags: job, career, codenewbie, beginners
---
Wait a minute! 

We are at the period where everybody sets goals and as usual, a lot of people are setting goals already.

# Before You Set Your 2021 Goals...

First, evaluate your habits or the situations that prevented you from achieving your past goals.

For example, if your main goal was to get a job, ask yourself these questions:

What habits deprived me of getting a job in 2020?

### Possible Answers: 

Maybe I didn't reach out to people and companies.

- Why didn't I reach out?
 
i. I was afraid of rejection.

ii. I was scared my skills were not qualified.

iii. I was afraid my course of study were not relevant.

iv. I was afraid my communication skills were poor.

v. I depended too much on my family and their promises of getting me a job.

### Step 2: 

I reached out but didn't get any job interview.

Question:

Why didn't I get any job interview?

Answers:

i. Maybe my CV was not relevant to the jobs' requirements.

ii. Maybe my CV has some errors.

iii. Maybe I didn't have required experience.

iv. Maybe I was not qualified in terms of skills needed.

v. Maybe I applied for few job vacancies (less than ten).

### Step 3:

Question:

I got several job interviews but couldn't get any job offer.

why didn't I get any job offer?

### Possible Answers:

i. Maybe I didn't do well during the interviews.

ii. Maybe I couldn't showcase my skills during the interviews.

iii. Maybe something was wrong with my communication and presentation skills.

iv. Maybe I didn't meet interviewers' expectation.

v. Maybe I knew little about the companies.

vi. Maybe I lack great connects.

Now, your focus should be on providing solutions to all of the problems you identified.

It is hard if not impossibble to achieve your goals without getting all those small things right on a daily, weekly and monthly basis.

# Achievable Goals are always Related.

Let's use some goals as examples:

1. Get a job that pays $200,000/annually.

2. Network a lot by interacting with people online and offline.

3. Start your own side business.

4. Rent or Buy a house .

It is obvious that achieving one goal will help in achieving others.

# Always Expect Unexpected:

Many people think they will achieve their goals easily but it is not like that in the real world.

Most things will not work as planned that is why you need to be strongly determined to achieve any reasonable things in the real world.

What are the things that help you in achieving your goals?


# One more thing

Are you having difficulties to learn and understand JavaScript and build projects with it? ***JavaScript for a Total Novice*** teaches JavaScript and Project Making Fundamentals with simple illustrations and examples that make everything so easy. You can now handle any difficult projects without fear.

Don't trust me, get a free preview to judge by yourself: https://bit.ly/3o3TMyg