I have a very large file with more than 500,000 lines of dated events.
The first field contains the date/time in the following format:
20120727-files.files:20120727090044
where the first 8 numbers represent yyyymmdd. The last set of numbers represent yyyy/mm/dd/hh:mm:ss
I would like to change the value of the first field to:
YYYY-MM-DD HH:MM:SS
I have no clue how to do this. I started with displaying the first field only to simplify things.
I've tried to find a cheatsheet for printf but couldn't find anything good. Is printf universal to many languages? Or is printf in bash unique to all....?
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)
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)
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)
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)
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)
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)
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)
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)
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 ULTRIX
fprintf
printf(3int)printf(3int)Name
printf, fprintf, sprintf - print formatted output
Syntax
#include <stdio.h>
int printf ( format [, arg ] ... )
char *format;
int fprintf ( stream, format [, arg ] ... )
FILE *stream;
char *format;
int sprintf ( s, format [, arg ] ... )
char *s, *format;
Description
The international functions and are similar to the standard I/O functions. The difference is that the international functions allow you to
use the %digit$ conversion character in place of the % character you use in the standard I/O functions. The digit is a decimal digit n from
1 to 9. The international functions apply conversions to the n th argument in the argument list, rather than to the next unused argument.
You can use the % conversion character in the international functions. However, you cannot mix the % conversion character with the %digit$
conversion character in a single call.
You can indicate a field width or precision by an asterisk (*) instead of a digit string in format strings containing the % conversion
character. If you use an asterisk, you can supply an integer arg that specifies the field width or precision. In format strings containing
the %digit$ conversion character, you can indicate field width or precision by the sequence *digit$. You use a decimal digit from 1 to 9
to indicate which argument contains an integer that specifies the field width or precision.
The conversion characters and their meanings are identical to
You must use each digit argument at least once.
In all cases, the radix character uses is defined by the last successful call to category If category has not been called successfully or
if the radix character is undefined, the radix character defaults to a period (.).
International Environment
LC_NUMERIC If this environment is set and valid, uses the international language database named in the definition to determine radix
character rules.
LANG If this environment variable is set and valid uses the international language database named in the definition to determine
collation and character classification rules. If is defined, its definition supercedes the definition of LANG.
Examples
The following example illustrates using an argument to specify field width:
printf ("%1$d:%2$.*3$d:%4$.*3$d
",
hour, min, precision, sec);
The format string *3$ indicates that the third argument, which is named precision, contains the integer field width specification.
To print the language independent date and time format use the following statement:
printf (format, weekday, month, day, hour, min);
For American use, format could be a pointer to the following string:
"%1$s, %2$s %3$d, %4$d:%5$.2d
"
This string gives the following date format:
Sunday, July 3, 10:02
For use in a German environment, format could be a pointer to the following string:
"%1$s, %3$d. %2$s, %4$d:%5$.2d
"
This string gives the following date format:
Sonntag, 3. Juli, 10:02
Return Values
and return zero for success and EOF for failure. The subroutine returns its first argument for success and EOF for failure.
In the System V and POSIX environments, and return the number of characters transmitted for success. The function ignores the null termi-
nator ( ) when calculating the number of characters transmitted. If an output error occurs, these routines return a negative value.
See Alsointro(3int), setlocale(3), scanf(3int), printf(3s), putc(3s), scanf(3s), stdio(3s)
Guide to Developing International Software
printf(3int)