Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering Unix : AWK Commands
Rating: 3.7 out of 5(26 ratings)
486 students

Mastering Unix : AWK Commands

Realtime data processing with many practical examples
Created byTesting World
Last updated 5/2017
English

What you'll learn

  • Ready to face interviews for advance file processing
  • Ready to process complex files using these commands

Course content

1 section23 lectures1h 45m total length
  • Introduction to AWK | Select Column Data4:59
  • Search text at the start of Line4:48

    Set script permissions with chmod 777 to grant read and write access for everyone, then check with ls. Run the script as ./filename or with sh filename.

  • AWK - Select columns from CSV file4:20

    Learn how awk selects columns from CSV files, enabling targeted data extraction. Explore viewing large files with paging using the more command, including spacebar navigation and quit controls.

  • AWK - Remove header row from result4:58

    Learn to remove the header row in awk by skipping the first line with NR and printing only the data rows.

  • AWK - Save Command Result to File3:02

    Save awk command results to a file using redirection, creating a new file or updating an existing one. Verify the saved output by viewing the file contents with cat.

  • AWK - Conditionally select data7:23

    Mastering Unix: awk commands teaches how to filter data with conditional expressions using a where clause, and print selected columns using dollar fields and separators.

  • AWK - Conditionally Select data with logical OR4:18
  • AWK - Conditionally Select data with logical AND3:11

    Master awk to conditionally filter data using logical and, returning records where the manager is Rohit and salary is 2000, while printing selected columns.

  • AWK - Conditionally Select data | Check Substring in record3:29

    Apply AWK to conditionally select records by substring anywhere in a row using regex, print entire rows or a specific column, and exclude matches with not operators.

  • AWK - Conditionally Select data | Check Substring in Column5:13

    this lecture demonstrates using awk to conditionally select records by a substring in a column, including exact matches, not matches, and substring checks in the second column (name column).

  • AWK : Search text at the start2:31

    Learn to use awk to find records that start with a specific text by matching the start of the line, print matching lines, and optionally display the filename.

  • AWK : Search text at the end3:45

    Mastering awk commands demonstrates matching text at the end of lines, printing full records with $0, and combining start and end conditions to filter results.

  • AWK : Condition check using IF4:21

    Learn how to use awk to perform conditional checks with if statements, filtering records by salary and column values, including greater than 30000 and ranges like 20000 to 30000.

  • AWK : Condition check using IF-ELSE2:50
  • AWK : Condition check using IF-ELSE IF -ELSE4:41

    Use awk to perform if-else-if-else conditions on salary thresholds (over 30000, over 20000), assigning 30, 20, or 10 percent, printing names, and skipping the header line.

  • AWK : Begin Block7:28

    use the awk begin block to initialize variables and display a header before processing records. filter records where column three equals 10000, double the salary, and print the full line.

  • AWK : End Block6:45

    Explore how awk uses the begin, action, and end blocks to process data, display records with a column separator, and filter where column 3 equals 10000.

  • AWK : While Loop4:52
  • AWK : For Loop6:46

    Use AWK's for loop to repeat tasks, set the field separator, and print $0, $1, and $2. Display each record in a full-length, multi-line format with ID and name.

  • AWK : Store comamnd Result into variable3:02
  • Find String Length4:02

    Explore string functions in awk to compute the length of a string, extract the second column, and display the last name with its length.

  • Split Files with complete Data5:16

    Use awk to split a data file into multiple files by a chosen column, such as designation or office code, creating outputs named from a base like enp.

  • Split File : Selective Data3:15

Requirements

  • You should have basic knowledge of Unix commands
  • Students should have basic knowledge of Ubuntu terminal

Description

      Pgawk is the profiling version of gawk.  It is identical in  every  way

       to  gawk,  except  that  programs run more slowly, and it automatically
       produces an execution profile in the file awkprof.out when  done.   See
       the --profile option, below.

       The  command  line  consists of options to gawk itself, the AWK program
       text (if not supplied via the -f or --file options), and values  to  be
       made available in the ARGC and ARGV pre-defined AWK variables.

       Here we are going to cover

       CSV file processing using AWK

      Data Filtering using AWK

      Data Management using AWK

      Update and Delete Data

      Monitor Data

      Select specific data

      Select data after processing

Who this course is for:

  • Developers working on File processing projects
  • Software Developers and Testers working on Big data applications