====== Using the "cut" Command with Spaces ====== The ''cut'' command is useful when you want to cut out a specific portion of text lines. You can do this by character position: $ ls -l /etc/hosts | cut -c 2-10 rw-r--r-- And you can do this by delimeter (separator symbol). For example, the file /etc/passwd consists of lines with multiple fields of data, separated by the colon (:) symbol. Here, I find the line for my account, and then cut out field 5 (the full name): $ grep chris /etc/passwd chris:x:1000:1000:Chris Tyler:/home/chris:/bin/bash $ grep chris /etc/passwd|cut -d: -f 5 Chris Tyler ===== The Problem with Spaces ===== A problem arises when there are multiple fields on a line, and those fields are separated by multiple spaces, such as in this example: $ w 13:52:48 up 10:25, 5 users, load average: 1.39, 1.36, 1.32 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT bylee6 pts/0 10.29.0.44 13:44 8.00s 0.26s 0.07s vim lab5c.py aliakbar pts/1 10.32.8.143 13:43 8.00s 0.11s 0.00s nano loop1.bash chris.ty pts/2 10.31.0.187 12:56 0.00s 0.22s 0.01s w hapancha pts/3 10.29.0.47 13:50 8.00s 0.11s 0.11s -bash rajveer- pts/4 10.29.0.222 13:50 32.00s 0.14s 0.14s -bash The number of spaces between the fields varies, so that the fields line up vertically; for example, there are three spaces between fields 1 and 2 on the "bylee6" line, but only one space between fields 1 and 2 on the "aliakbar" line. The ''cut'' command expects only one delimiter between fields, so this presents a problem. Notice that in the following output, the "bylee6" line is not cut properly because of the multiple spaces between field 1 and field 2: $ w|tail -n +3 |cut -d " " -f2 pts/1 pts/2 pts/3 pts/4 ===== A Solution: ''tr'' ===== The translate command (''tr'') is a useful too which can delete, squeeze, or substitute characters. The squeeze capability is useful here: the command ''tr -s " "'' will squeeze multiple consecutive spaces down to a single space. You can then reliably use the ''cut'' command the the delimiter option ''-d'' to select the desired field: $ w|tail -n +3 |tr -s " " bylee6 pts/0 10.29.0.44 13:44 8.00s 0.26s 0.07s vim lab5c.py aliakbar pts/1 10.32.8.143 13:43 8.00s 0.11s 0.00s nano loop1.bash chris.ty pts/2 10.31.0.187 12:56 0.00s 0.22s 0.01s w hapancha pts/3 10.29.0.47 13:50 8.00s 0.11s 0.11s -bash rajveer- pts/4 10.29.0.222 13:50 32.00s 0.14s 0.14s -bash $ w|tail -n +3 |tr -s " "|cut -d " " -f2 pts/0 pts/1 pts/2 pts/3 pts/4