🖥️join

➡️This is a command-line reference manual for commands and command combinations that you don’t use often enough to remember it. This cheatsheet explains the join command with important options and switches using examples.

▁ ▂ ▃ ▄ ꧁ 🔴☠ COMMANDLINE-KUNGFU WITH CHEATSHEETS ☠🔴꧂▅ ▃ ▂ ▁

#                     ██╗ ██████╗ ██╗███╗   ██╗
#                     ██║██╔═══██╗██║████╗  ██║
#                     ██║██║   ██║██║██╔██╗ ██║
#                ██   ██║██║   ██║██║██║╚██╗██║
#                ╚█████╔╝╚██████╔╝██║██║ ╚████║
#                 ╚════╝  ╚═════╝ ╚═╝╚═╝  ╚═══╝
                     

join -o 1.1,2.2 -1 1 -2 1 -t: file1 file2
# Merge two files together based on the first column in each. Print file1.col1:file2.col2.

join -a2 -j2 <(cat -n old|sort -k2) <(cat -n new|sort -k2)|awk 'NF==3{print$3,-$3+$2,$1;next}{print$2,"-",$1}'|sort -n 
# show rank change

#==============================##==============================#
# CMD JOIN						       #
#==============================##==============================#
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

  █║▌│║█║▌★ KALI ★ PARROT ★ DEBIAN 🔴 PENTESTING ★ HACKING ★ █║▌│║█║▌

              ██╗ ██╗ ██████╗  ██████╗ ██╗  ██╗███████╗██████╗
             ████████╗██╔══██╗██╔═══██╗╚██╗██╔╝██╔════╝██╔══██╗
             ╚██╔═██╔╝██║  ██║██║   ██║ ╚███╔╝ █████╗  ██║  ██║
             ████████╗██║  ██║██║   ██║ ██╔██╗ ██╔══╝  ██║  ██║
             ╚██╔═██╔╝██████╔╝╚██████╔╝██╔╝ ██╗███████╗██████╔╝
              ╚═╝ ╚═╝ ╚═════╝  ╚═════╝ ╚═╝  ╚═╝╚══════╝╚═════╝

               █║▌│║█║▌ WITH COMMANDLINE-KUNGFU POWER █║▌│║█║▌

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░