Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Use of awk and printf - help needed
Top Forums Shell Programming and Scripting Use of awk and printf - help needed Post 302749529 by Don Cragun on Friday 28th of December 2012 01:40:26 PM
Old 12-28-2012
The printf utility is not unique to bash; it is a standard utility present on any system that supports the common set of utilities defined by the POSIX standards and the Single UNIX Specification. But, if you're using awk to grab the 1st field out of your input file, you might as well just do all of the work in awk. If you just want to change the format of the first field in your file and print the updated line, you can use:
Code:
awk '
BEGIN { FS = OFS = "|"}
{       l=length($1)
        $1 = sprintf("%s-%s-%s %s:%s:%s", substr($1, l - 13, 4),
                substr($1, l - 9, 2), substr($1, l - 7, 2),
                substr($1, l - 5, 2), substr($1, l - 3, 2), substr($1, l - 1))
        print
}' infile 
exit

If you just want to print the dates and ignore the rest of the fields in in file, you can shorten this to:
Code:
awk -F '|' '{
        l=length($1)
        printf("%s-%s-%s %s:%s:%s", substr($1, l - 13, 4),
                substr($1, l - 9, 2), substr($1, l - 7, 2),
                substr($1, l - 5, 2), substr($1, l - 3, 2), substr($1, l - 1))
}' infile 
exit

This User Gave Thanks to Don Cragun For This Post:
LDHB2012
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

awk printf problem

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

AwK printf question

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

Awk printf problem

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

printf in awk

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

awk and printf

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

IF and awk/printf

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

AWK printf help

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

awk with printf

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

printf format with awk

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

awk printf dillemma

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 SUNOS

mailq

mailq(1)							   User Commands							  mailq(1)

NAME

       mailq - print the mail queue

SYNOPSIS

       /usr/bin/mailq [-Ac] [-q subarg] [-v]

DESCRIPTION

       The mailq utility displays a summary of the mail messages queued for future delivery.

       The  first line displayed for each mail message shows the internal identifier used on this host for the message, 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  of  the  display
       shows  the error message that caused this message to be retained in the queue. This line will not be displayed if the message is being pro-
       cessed for the first time.

       The mailq utility used to be identical to sendmail -bp. Now it checks for the authorization attribute, solaris.mail.mailq. If the check for
       the  invoking  user  succeeds,  sendmail  -bp  is executed with the remaining argument vector. Otherwise, an error message is printed. This
       authorization attribute is by default enabled for all users. It can be disabled by modifying the Basic Solaris User entry in prof_attr(4).

OPTIONS

       The following options are supported:

       -Ac	       Like sendmail(1M), this flag tells mailq to use submit.cf rather than sendmail.cf even  if  the	operation  mode  does  not
		       indicate  an  initial  mail submission. This will result in the client queue /var/spool/clientmqueue being displayed rather
		       than the default server queue /var/spool/mqueue.

       -qp[time]       Similar to -qtime, except that instead of periodically forking a child to process the queue, sendmail forks a  single  per-
		       sistent	child  for  each  queue  that alternates between processing the queue and sleeping. The sleep time is given as the
		       argument. The sleep time default is 1 second. The process will always sleep at least 5 seconds if the queue  was  empty	in
		       the previous queue run.

       -qf	       Processes saved	messages in the queue once and does not fork(), but runs in the foreground.

       -qG name        Processes jobs in the queue group called name only.

       -q[!]I substr   Limits processed jobs to those containing substr as a substring of the queue id, or not when ! is specified.

       -q[!]R substr   Limits processed jobs to those containing substr as a substring of one of the recipients, or not when ! is specified.

       -q[!]S substr   Limits processed jobs to those containing substr as a substring of the sender, or not when ! is specified.

       -v	       Prints  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 that indicate 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 is expanded from, if any.

EXIT STATUS

       0	Successful completion.

       >0	An error occurred.

FILES

       /etc/security/prof_attr	       local source for execution profile attributes

       /var/spool/mqueue	       default server queue

       /var/spool/clientmqueue	       client queue

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWsndmu 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       sendmail(1M), prof_attr(4), attributes(5)

SunOS 5.10							    10 Jul 2002 							  mailq(1)
All times are GMT -4. The time now is 04:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy