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
STRSPN(3) 1 STRSPN(3)
strspn - Finds the length of the initial segment of a string consisting entirely of characters contained within a given mask.
SYNOPSIS
int strspn (string $subject, string $mask, [int $start], [int $length])
DESCRIPTION
Finds the length of the initial segment of $subject that contains only characters from $mask.
If $start and $length are omitted, then all of $subject will be examined. If they are included, then the effect will be the same as call-
ing strspn(substr($subject, $start, $length), $mask) (see "substr" for more information).
The line of code:
<?php
$var = strspn("42 is the answer to the 128th question.", "1234567890");
?>
2 to $var, because the string "42" is the initial segment of $subject that consists only of characters contained within "1234567890".
PARAMETERS
o $subject
- The string to examine.
o $mask
- The list of allowable characters.
o $start
- The position in $subject to start searching. If $start is given and is non-negative, then strspn(3) will begin examining $sub-
ject at the $start'th position. For instance, in the string ' abcdef', the character at position 0 is ' a', the character at posi-
tion 2 is ' c', and so forth. If $start is given and is negative, then strspn(3) will begin examining $subject at the $start'th
position from the end of $subject.
o $length
- The length of the segment from $subject to examine. If $length is given and is non-negative, then $subject will be examined for
$length characters after the starting position. If $length is given and is negative, then $subject will be examined from the
starting position up to $length characters from the end of $subject.
RETURN VALUES
Returns the length of the initial segment of $subject which consists entirely of characters in $mask.
EXAMPLES
Example #1
strspn(3) example
<?php
// subject does not start with any characters from mask
var_dump(strspn("foo", "o"));
// examine two characters from subject starting at offset 1
var_dump(strspn("foo", "o", 1, 2));
// examine one character from subject starting at offset 1
var_dump(strspn("foo", "o", 1, 1));
?>
The above example will output:
int(0)
int(2)
int(1)
NOTES
Note
This function is binary-safe.
SEE ALSO
strcspn(3).
PHP Documentation Group STRSPN(3)