EN

Site Language

English

Content Language

English Polski Deutsch Português

Log in
Join

[Edit]

EN

Bash - extract specific column from result

2 contributors

7 contributions

0 discussions

9 points

Created by:

577

In this short article, we would like to show how to extract a specific column from some text or program result.

Quick solution:

cat /path/to/my/file | awk '{print $1}'

# or

some-command | awk '{print $1}'

Practical example

In the below example, awk command extracts the first column ($1) from ls -al command result, without taking the first row into account (NR>1).

$ ls -al | awk 'NR>1 {print $1}'
drwxr-xr-x
drwxr-xr-x
lrwxrwxrwx
drwxr-xr-x
drwxrwxr-x
drwxr-xr-x
drwxr-xr-x
drwxr-xr-x
lrwxrwxrwx
lrwxrwxrwx
lrwxrwxrwx
lrwxrwxrwx
drwx------
drwxr-xr-x
drwxr-xr-x
drwxr-xr-x
dr-xr-xr-x
drwx------
drwxr-xr-x
lrwxrwxrwx
drwxr-xr-x
drwxr-xr-x
-rw-------
dr-xr-xr-x
drwxrwxrwt
drwxr-xr-x
drwxr-xr-x

Direct ls -al result:

$ ls -al
total 2097248
drwxr-xr-x  20 root root       4096 paź 12 13:04 .
drwxr-xr-x  20 root root       4096 paź 12 13:04 ..
lrwxrwxrwx   1 root root          7 paź 12 13:03 bin -> usr/bin
drwxr-xr-x   4 root root       4096 lut 10 10:18 boot
drwxrwxr-x   2 root root       4096 paź 12 13:04 cdrom
drwxr-xr-x  22 root root       5080 lut 10 09:20 dev
drwxr-xr-x 142 root root      12288 lut 10 10:18 etc
drwxr-xr-x   3 root root       4096 paź 12 13:06 home
lrwxrwxrwx   1 root root          7 paź 12 13:03 lib -> usr/lib
lrwxrwxrwx   1 root root          9 paź 12 13:03 lib32 -> usr/lib32
lrwxrwxrwx   1 root root          9 paź 12 13:03 lib64 -> usr/lib64
lrwxrwxrwx   1 root root         10 paź 12 13:03 libx32 -> usr/libx32
drwx------   2 root root      16384 paź 12 13:03 lost+found
drwxr-xr-x   3 root root       4096 paź 12 14:51 media
drwxr-xr-x   2 root root       4096 lip 31  2020 mnt
drwxr-xr-x   5 root root       4096 sty 19 12:31 opt
dr-xr-xr-x 469 root root          0 lut 10 09:19 proc
drwx------   9 root root       4096 sty 22 10:31 root
drwxr-xr-x  39 root root       1120 lut 10 10:21 run
lrwxrwxrwx   1 root root          8 paź 12 13:03 sbin -> usr/sbin
drwxr-xr-x  21 root root       4096 sty 21 09:41 snap
drwxr-xr-x   2 root root       4096 lip 31  2020 srv
-rw-------   1 root root 2147483648 paź 12 13:03 swapfile
dr-xr-xr-x  13 root root          0 lut 10 09:19 sys
drwxrwxrwt  33 root root      12288 lut 10 10:23 tmp
drwxr-xr-x  14 root root       4096 lip 31  2020 usr
drwxr-xr-x  14 root root       4096 lip 31  2020 var

Alternative titles

Bash - extract specific column from file

Donate to Dirask

Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!

Direct link

Join to our subscribers to be up to date with content, news and offers.

Bash

Bash - add user to exiting group in Linux

Bash - batch export from svg to properly sized png file

Bash - calculate md5 sum in terminal

Bash - check array size

Bash - check file data

Bash - check if command is supported

Bash - check if file exists

Bash - check if string is empty

Bash - check tomcat version

Bash - command alias

Bash - compress files with tar command in Linux

Bash - compress svg file

Bash - condition to permit script execution only under Linux

Bash - convert *.pem files to *.p12 file (cert.pem and key.pem to keystore.p12)

Bash - convert png to base64 data url

Bash - convert svg to base64 data url

Bash - copy directory recursively

Bash - correct header - create simple bin sh shell script with .sh

Bash - count lines in a document

Bash - create array

Bash - create new file under linux command

Bash - create symbolic link in Linux

Bash - current timestamp

Bash - cut examples

Bash - detect operating system

Bash - download public *.pem certificate from https connection

Bash - extract *.tar.gz file in Linux

Bash - extract specific column from result

Bash - find file name by containing text

Bash - follow log file changes

Bash - for loop in range

Bash - for loop with counter

Bash - format ls command date & time

Bash - forward SIGTERM to child processes

Bash - get all array elements

Bash - get current script directory path

Bash - how to pass arguments to function

Bash - how to use command line arguments in script

Bash - how to use function (create / call function)

Bash - install linux bash for windows

Bash - iterate through array values

Bash - list current user groups in Linux

Bash - list specific user groups in Linux

Bash - list system users in Linux

Bash - move directory recursively

Bash - own /custom command alias

Bash - pass variables from one script to second one

Bash - read *.p12 keystore info

Bash - read variable with default value

Bash - redirect command errors to file

Bash - redirect command outputs to file

Bash - remove directory

Bash - remove new line characters from file with tr command

Bash - repeat a character N times

Bash - repeat a command N times

Bash - reset modification date of any file

Bash - return values from functions

Bash - scan open ports with netcat / nc in Debian Linux

Bash - shell sh script with do not close terminal (like windows bat pause)

Bash - sort lines

Bash - start / stop server script for Spring Boot Application

Bash - text to lower case

Bash - text to upper case

Bash - while loop

Bash - write simple calculator

Windows - open file using Bash script

Native Advertising

🚀

Get your tech brand or product in front of software developers.

For more information Contact us

Dirask - we help you to

solve coding problems.

Ask question.

❤️💻 🙂

Join