12-28-2012
Quote:
Originally Posted by
LDHB2012
That's amazing.
It worked the first time around. I really appreciate your help on this.
If you could answer a qusetion... I'm having trouble finding a tutorial or information on the "l - 13" or "l - 9" portion of the code.
I read the man on awk for substr (which is vague and confusing) and I'm just curious how I can make myself fluent in this language without having to pull my hair out and ask a billion questions.... If you could give me some insight on that, I'd really appreciate it.
-David
Happy New Year!
---------- Post updated at 05:27 PM ---------- Previous update was at 05:12 PM ----------
I KIND OF understand what it's saying but not quite.
substr($1, l - 13, 4)
The above looks like it's starting the count, 4 from the end, 13 to the left, which goes over 2012.
substr($1, l - 9, 2)
The above starts the count 2 from the end, 9 to the left, which is right between the 2012 and 12, which seems perfect. Am I missing something here? (obviously I am.)
Hi David,
The awk command
l=length($1) sets l to the number of characters in the first field. In your example, this sets l to 35 because there are 35 characters in "20120727-files.files:20120727090044" (not counting the terminating null byte). The substr(
x,
s,
c) returns
c characters from the string
x starting with the
sth character in the string. So,
substr($1, l - 13, 4) returns 4 characters from
20120727-files.files:20120727090044 starting with the 22nd character (i.e., "2012"). When a count isn't given (as in
substr($1,l - 1)), substr() will return the remainder of the string from the given starting point. This is all done because I assume that the
files.files portion of your input lines may vary in length, but we know that the timestamp is always the last 14 characters in the string.
This User Gave Thanks to Don Cragun For This Post:
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi Friends,
Can anyone guide me how to compute sum of column4 from the below file x using awk command? when i do using awk I'm getting sum 7482350198352648.000000 which is not accurate.
$ cat x
56,232,dfgjkhdfj,,56,anand
56,22,dfgjkhdfj,7482347823453123.97834 ,56,Khan
56,23,dfgjkhdfj, ... (6 Replies)
Discussion started by: krishna
6 Replies
2. UNIX for Dummies Questions & Answers
Hi,
Does anyone know a easy way to printf $3,$4, ... all the way to the last field in the file? I will need to modify $1 and $2 and then printf modified $1 and $2 and the rest of the fields(which are not changed).
I know I can use NF as the total number of field.
Do I use a for next statement to... (4 Replies)
Discussion started by: whatisthis
4 Replies
3. Shell Programming and Scripting
Hi,
I've got a basic problem using printf statement in awk.
I want to write float values with always 8 characters width.
Examples :
1.345678
12.45678
123.4567
1234.678
-23.5678
-2.45678
-23456.8
.....
I cannot find the right printf format %8.1f, %7.5f....
Can anyone help ?... (4 Replies)
Discussion started by: cazhot
4 Replies
4. Shell Programming and Scripting
Hi friends..
I am confused about awk printf option..
I have a comma separated file
88562848,21-JAN-08,2741079, -1188,-7433,TESTING
88558314,21-JAN-08,2741189, -1273,-7976,TESTING
and there is a line in my script ( written by someone else)
What is the use of command?
I guess... (10 Replies)
Discussion started by: clx
10 Replies
5. Shell Programming and Scripting
echo $bbsize
1.5
echo $fillpercent
.95
echo $bbsize | awk '{printf "%.2f\n",$0*$fillpercent}'
2.25
echo $bbsize | awk '{printf "%.2f\n",$0*.95}'
1.42
1.42 is what I'm expecting...
echo $blocksize
4096
echo $bbsize | awk '{printf "%.2f\n",$0*$blocksize}'
2.25
echo $bbsize |... (3 Replies)
Discussion started by: xgringo
3 Replies
6. Shell Programming and Scripting
Hi Friends,
Scripting newb here. So I'm trying to create a geektool script that uses awk and printf to output certain fields from top (namely command, cpu%, rsize, pid and time, in that order). After much trial and error, I've pretty much succeeded, with one exception. Any process whose name... (3 Replies)
Discussion started by: thom.mattson
3 Replies
7. Shell Programming and Scripting
Target file contains short text (never more than 1 line) and filenames.
The format is, e.g.,:
TEXT1
filename1
TEXT2
TEXT3
filename3dddd
filename3dddd
TEXT4
filename4
TEXT5
filename5dddd
filename5dddd
filename5
where dddd is a random 4-digit whole number.
Desired output: (4 Replies)
Discussion started by: uiop44
4 Replies
8. Shell Programming and Scripting
Hi,
I am using the following code to assign a count value to a variable. But I get nothing. Do you see anything wrong here.
I am new to all this.
$CTR=`remsh $m -l $MACHINES{$m} -n cat $output | grep -v sent | grep \"$input\" | sort -u | awk '{print $5}'`;
Upto sort - u it's... (2 Replies)
Discussion started by: nurani
2 Replies
9. Shell Programming and Scripting
Hello
Here is an easy one
Data file
12345 (tab) Some text (tab) 53.432
23456 (tab) Some longer text (tab) 933.422
34567 (tab) Some different text (tab) 29.309
I need to awk these three tab-delimited columns so that the first two are unchanged (unformatted) and the third shows two decimal... (1 Reply)
Discussion started by: palex
1 Replies
10. Shell Programming and Scripting
Please help me format this file:
Source file looks like this, there are three columns, separated by space. First column has varrying width:
1 248105240 W25_2013
10 248103710 W06_2013
100 248103710 W06_2013
1000 248103710 W06_2013
I need to transform the file into a fixed width per column.... (1 Reply)
Discussion started by: tamahomekarasu
1 Replies
LEARN ABOUT FREEBSD
mailq
MAILQ(1) General Commands Manual MAILQ(1)
NAME
mailq - print the mail queue
SYNOPSIS
mailq [-Ac] [-q...] [-v]
DESCRIPTION
Mailq prints a summary of the mail messages queued for future delivery.
The first line printed for each message shows the internal identifier used on this host for the message with a possible status character,
the size of the message in bytes, the date and time the message was accepted into the queue, and the envelope sender of the message. The
second line shows the error message that caused this message to be retained in the queue; it will not be present if the message is being
processed for the first time. The status characters are either * to indicate the job is being processed; X to indicate that the load is
too high to process the job; and - to indicate that the job is too young to process. The following lines show message recipients, one per
line.
Mailq is identical to ``sendmail -bp''.
The relevant options are as follows:
-Ac Show the mail submission queue specified in /etc/mail/submit.cf instead of the MTA queue specified in /etc/mail/sendmail.cf.
-qL Show the "lost" items in the mail queue instead of the normal queue items.
-qQ Show the quarantined items in the mail queue instead of the normal queue items.
-q[!]I substr
Limit processed jobs to those containing substr as a substring of the queue id or not when ! is specified.
-q[!]Q substr
Limit processed jobs to quarantined jobs containing substr as a substring of the quarantine reason or not when ! is specified.
-q[!]R substr
Limit processed jobs to those containing substr as a substring of one of the recipients or not when ! is specified.
-q[!]S substr
Limit processed jobs to those containing substr as a substring of the sender or not when ! is specified.
-v Print verbose information. This adds the priority of the message and a single character indicator (``+'' or blank) indicating
whether a warning message has been sent on the first line of the message. Additionally, extra lines may be intermixed with the
recipients indicating the ``controlling user'' information; this shows who will own any programs that are executed on behalf of this
message and the name of the alias this command expanded from, if any. Moreover, status messages for each recipient are printed if
available.
Several sendmail.cf options influence the behavior of the mailq utility: The number of items printed per queue group is restricted by
MaxQueueRunSize if that value is set. The status character * is not printed for some values of QueueSortOrder, e.g., filename, random,
modification, and none, unless a -q option is used to limit the processed jobs.
The mailq utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
sendmail(8)
HISTORY
The mailq command appeared in 4.0BSD.
$Date: 2013-11-22 20:51:55 $ MAILQ(1)