11-09-2007
When splitting fields with 'awk', the default field-separator is a pattern that matches whitespace. Commonly, data is arranged in columns separated by a special character like a comma or colon, so in those cases we must set the field separator.
awk -F:
Now that ":" is the separator, we can always take the 3rd column by using "$3". Unfortunately, in this case, one of the fields included a timestamp (and two extra colons!) so I used $5 to indicate where the name starts, even though HH:MM:SS is really one value.
The text between the slashes is a regex, so only matching lines (those with "RANDOM" in them) are considered. Then, $5 is split into array "a" using a blank space as a separator. Thus the first two elements, a[1] and a[2] must be the first/last name.
Sometimes 'cut' can be the better choice when the columns are of fixed width, but it didn't appear to be the case here. For instance, won't the date get wider by one byte after the 9th of the month? In those cases it's better to use something like 'awk' that can separate the fields based on a pattern.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Can anyone tell me if I can apply multiple cut on a single variable like below in a sh script:
tmp=`cut -c 1-4 $val`
tmp1=`cut -c 5-12 $val`
tmp2=`cut -c 13-18 $val`
If not, what is the other way to do this.
Thanks and Best Regards
Shoeb (17 Replies)
Discussion started by: shoeb_syed
17 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
I am new to Unix.I have a shell script whenere I wnat to find if a particular server is running and kill all the instances of it (running on different ports)
script filename to start the srever is say abcd
If i do ps -eaf | grep abc
I get all the instances of srever running .In the... (1 Reply)
Discussion started by: shradham
1 Replies
3. AIX
Hi All,
Can anyone tell me how to use cut command?I have tried but its not working...Please find the details below :
$ cat file1
SlNo. E_ID E_Name Age Dept
1 123 A 20 Electrical
2 124 B 20 Electronics
3 125 C 24 Computer
4 126 D 23 Mechanical
... (3 Replies)
Discussion started by: Puja Sharma
3 Replies
4. Shell Programming and Scripting
n2=user1 pts/3 2010-06-29 01
Now i want to split this string with space(' ') character.
After splitting output would be:
use1
pts/3
2010-06-29
01
I did:
nn=${n2} | cut -d ' ' -f2
echo ${nn}
It prints nothing.
I want the output:
pts/3 (2 Replies)
Discussion started by: cola
2 Replies
5. Shell Programming and Scripting
Hi
Can anyone what I am doing wrong while using cut command.
for f in *.log
do
logfilename=$f
Log "Log file Name: $logfilename"
logfile1=`basename $logfilename .log`
flength=${#logfile1}
Log "file length $flength"
from_length=$(($flength - 15))
Log "from... (2 Replies)
Discussion started by: dgmm
2 Replies
6. UNIX for Dummies Questions & Answers
hay
i am trying to get JUST the PID from the ps command.
my command line is:
ps -ef | grep "mintty" | cut -d' ' -f2
but i get an empty line. i assume that the delimiter is not just one space character, but can't figure out what should i do in order to do that.
i know i can use awk or cut... (8 Replies)
Discussion started by: ran ber
8 Replies
7. AIX
HI,
i have data in one variable like
out=/usr/sbin/filename and i want output like only
out=filename
how to do (5 Replies)
Discussion started by: sumanthupar
5 Replies
8. Shell Programming and Scripting
Hi All,
I am a beginner learning shell script, Would it be possible to use -c and -f in cut command together ?
Example :
/opt/oracle/work/Antony/Shell_Script> cat shortlist
2233|a.k. shukula |g.m. |sales2 |12/12/52 |6000
1006|chanchal singhvi ... (3 Replies)
Discussion started by: Antony Ankrose
3 Replies
9. UNIX for Beginners Questions & Answers
I'm a complete beginner in UNIX (and not a computer science student either), just undergoing a tutoring course. Trying to replicate the instructions on my own I directed output of the ls listing command (lists all files of my home directory ) to My_dir.tsv file (see the screenshot) to make use of... (9 Replies)
Discussion started by: scrutinizerix
9 Replies