This video introduces the awk programming language.

This video will explain the different ways you can use AWK.

We know you w`ant to speed up your shell usage and in this vide we show you how to create a simple bash one-liner to create a complete subdirectory tree. Using BASH we can use simple syntax to create one-liner commands lines that are powerful

md ca/{root-ca,sub-ca}/{private,db,certs}

Extend this too, by setting the mode of both private directories

Make sure to subscribe to my channel for more videos on UNIX, Perl and SQL.
facebook: facebook.com/fuzicast
twitter: @fuzicast
youtube: youtube.com/yuejdesigner85

awk -F| BEGIN{ initialization } { code block } END{ finalization } — general syntax
default delimiter is space
VAR=«value» — define a variable
print VAR — print a variable
NF is number of fields
$NF is value of last field
print "$EXTERNAL_VAR" — double single $EXTERNAL_VAR single double
VAR~/pattern/ — pattern patching
VAR!~/pattern/ — does not match
FS returns value of field separator, same as -F
OFS returns output field separator
print $1,$2 is separated
NR returns line number
FILENAME returns current filename
awk -v var1=value1 — pre-assign values to variables in awk
awk -F, conditions { code block } filename — condition must be right before code block

cut — get columns from file
cut -d, -f1-2 filename — print 1st to 2nd columns
cut -c1-5 filename — print first 5 characters
cut -d, -f2- filename — print from 2nd column to last column
cut -d, -f1,4,5 filename — print 1st, 4th and 5th column
cut -d, -f-3 filename — print from 1st to 3rd column
cut -d, -f1,3-5 filename — print 1st, 3rd to 5th column

wc — word count
wc -l — line count
wc -c — print number of bytes
wc — print number of newline, word and bytes
wc -m — character count
wc -w — word count

last — check login history
last -10 — show last 10 logins
last -F — show full login information

If you are serious about gaining your Linux Essentials certification you can gain a heavily discounted price to my Linux Essentials course via this link:
www.udemy.com/learning-linux-essentials-taking-your-first-steps-in-linux/?couponCode=youtube-video
More videos like this online at www.theurbanpenguin.com
Topic 3.2 takes us into the realms of searching for files and data. We start with a little file redirection using the greater than symbols. then into piping using the vertical bar. Big area next looking at the tools such as find, cut, head, tail before we look at grep with regular expressions.

In this video we look at installing FreeBSD 12, the open UNIX operation system that widley available. FreeBSD is open source softeware that is released under a simple license In stalling this is simple but we exaplain each step and look at udating it after the installation. Later we can see how to upgrade to relase 12.1

Как реализовать в Excel выпадающий список, где можно быстро искать по первым введённым символам.
Скачать пример www.planetaexcel.ru/techniques/1/9645/
Заходите в гости ↓↓↓
Twitter twitter.com/planeta_excel
Facebook www.facebook.com/planetaexcel
Instagram www.instagram.com/planetaexcel/
Мои книги planetaexcel.ru/books/
Моя надстройка PLEX ( 150 новых функций для вашего Excel) planetaexcel.ru/plex/

Полное руководство по созданию аналитического отчета (дашборда) в Power BI.

Содержание урока:
0:01:20 — импорт данных.
0:08:16 — установка связей между таблицами в модели данных.
0:13:45 — трансформация данных. Создание вычисляемых столбцов.
0:28:20 — определение меры. Создание мер.
0:52:00 — DAX формула CALCULATE.
1:05:55 — визуализация данных.
1:33:35 — заключительные советы.

Скачать разархивированный Access и Excel файлы супермаркета Contoso: bit.ly/2TZJKls

Давайте дружить:
Facebook: bit.ly/2Bognmu

Теги:
#PowerBI
#дашборд #отчет
#руководство #урок
#аналитика

Excelda xodimlar ish haqini hisoblash

3 способа получить список файлов из заданной папки (и подпапок) в Microsoft Excel.

Скачать пример www.planetaexcel.ru/techniques/12/45/
Заходите в гости ↓↓↓
Twitter twitter.com/planeta_excel
Facebook www.facebook.com/planetaexcel
Instagram www.instagram.com/planetaexcel/
Мои книги planetaexcel.ru/books/
Моя надстройка PLEX ( 150 новых функций для вашего Excel) planetaexcel.ru/plex/