03-18-2003
Formatting using awk
Let's say I write a simple script that contains the following:
date | awk '{print $1}'
date | awk '{print $2}'
Of course, when I run the script the output will look similar to:
Tue
Mar
What if I want my ouput to be on one line as follows:
Tue Mar
What changes would I need to make to my script (#!/bin/csh)?
THanks
-cd
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I have a file in CSV format (2 columns ID and Number of Items):
AB1 ,,10
AB2 ,,20
AB2 ,, 30
AB3 ,, 10
AB4 ,, 20
AB4 ,, 30
AB4 ,, 40
AB5 ,, 50
AB6 ,, 10
AB7 ,, 20
AB7 ,, 30
AB7 ,, 40
......
This file is produced daily i would like to get it in the following format, so... (6 Replies)
Discussion started by: SAMZ
6 Replies
2. Shell Programming and Scripting
Hello,
I have got the following kine in my script
awk '{printf("%s,", $0);next}{printf("%s", $0)}' ORS="," a.txt > b.out
The contents of b looks somewaht like this:
QUEUE(QUEUE1.Q),CURDEPTH(0),QUEUE(QUEUE2.Q),CURDEPTH(0),QUEUE(QUEUE3.Q),CURDEPTH(0)
But my desired output is :... (10 Replies)
Discussion started by: King Nothing
10 Replies
3. Shell Programming and Scripting
# echo $PATH
/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
How would i write a script to display permission on each folders in $PATH variable below format.
drwxr-xr-x 2 0 root 4096 Nov 24 14:51 /usr/kerberos/sbin
drwxr-xr-x 2 0... (2 Replies)
Discussion started by: pinga123
2 Replies
4. Shell Programming and Scripting
Hi I have a file as given below:
<table border=1>
<TR><TH>Script Name</TH><TH>CVS Status</TH><TH>Script Location</TH></TR>
<TR><TD><CENTER>Work Area: /home/ustst/</CENTER></TD></TR>
<TR><TD><CENTER>admin_export.sh</CENTER></TD><TD><CENTER>Locally... (1 Reply)
Discussion started by: sudvishw
1 Replies
5. Shell Programming and Scripting
Dear all
I require help with AWK regarding this situation
Input is :
fn1 12345
fn1 23456
fn3 231513
fn1 22325
fn3 123125
Desired output is
fn1 12345 23456 22325
fn3 231513 123125 (5 Replies)
Discussion started by: Peasant
5 Replies
6. Shell Programming and Scripting
Hi all,
Below is my testfile:
COST,31-MAR-2011 01:01:04,31-MAR-2011 11:22:12,622
COST,21-MAR-2011 22:00:20,22-MAR-2011 11:07:23,788
FARE,23-MAR-2011 22:00:22,24-MAR-2011 10:10:46,731
FARE,02-MAR-2011 14:01:50,03-MAR-2011 08:30:54,1110
I need to append a number, for example 700, to the... (2 Replies)
Discussion started by: newbie_01
2 Replies
7. Shell Programming and Scripting
when i try this awk its giving out put as below.
awk '!(/^$/||/--/||/selected/||/^ *$/){print $1}' tmp.txt
output
=====
1
2010-08-03-12.31.26.126000
how excluede the 1st line ? i mean i want output only 2nd line i.e 2010-08-03-12.31.26.126000; (5 Replies)
Discussion started by: rocking77
5 Replies
8. Shell Programming and Scripting
Our vendor produces a report that I would like to format in a particular way.
Here is the sample output from their report:
# AA.INDEX 2 11 2 239 52 (7,2) 07 MAY 11 203.1 55
# ACCOUNT 2 89561 2 ... (4 Replies)
Discussion started by: thaller
4 Replies
9. UNIX for Dummies Questions & Answers
Hi all,
I'm writing a simple awk code:
awk 'BEGIN {FS="|"};{print "Type\tNumber\ttypes\tTotal";};{print $1, "\t", $2, "\t", $3, "\t", $4, "\t";}' db_query.txt
it gives me the result:
Type Number types Total
XXX 498.0 5100.0 5274.661
Type Number types Total... (7 Replies)
Discussion started by: messi777
7 Replies
10. Shell Programming and Scripting
i would like to format the 9 character with suffix as "0".
i tried below it doesn't work.
>a=12345
> echo $a | awk '{printf "%-09s\n",$1}'
>12345
required output is 123450000
can you guys help me out ? (7 Replies)
Discussion started by: expert
7 Replies
LEARN ABOUT DEBIAN
nqs2pbs
nqs2pbs(1B) PBS nqs2pbs(1B)
NAME
nqs2pbs - convert NQS job scripts to PBS
SYNOPSIS
nqs2pbs nqs_script [pbs_script]
DESCRIPTION
This utility converts a existing NQS job script to work with PBS and NQS. The existing script is copied and PBS directives, #PBS , are
inserted prior to each NQS directive #QSUB or #@$ , in the original script.
Certain NQS date specification and options are not supported by PBS. A warning message will be displayed indicating the problem and the
line of the script on which it occurred.
If any unrecognizable NQS directives are encountered, an error message is displayed. The new PBS script will be deleted if any errors
occur.
OPERANDS
nqs_script
Specifies the file name of the NQS script to convert. This file is not changed.
pbs_script
If specified, it is the name of the new PBS script. If not specified, the new file name is nqs_script.new .
NOTES
Converting NQS date specifications to the PBS form may result in a warning message and an incompleted converted date. PBS does not support
date specifications of "today", "tomorrow", or the name of the days of the week such as "Monday". If any of these are encountered in a
script, the PBS specification will contain only the time portion of the NQS specification, i.e. #PBS -a hhmm[.ss]. It is suggested that
you specify the execution time on the qsub command line rather than in the script.
Note that PBS will interpret a time specification without a date in the following way:
- If the time specified has not yet been reached, the job will become eligible to run at that time today.
- If the specified time has already passed when the job is submitted, the job will become eligible to run at that time tomorrow.
PBS does not support time zone identifiers. All times are taken as local time.
SEE ALSO
qsub(1B)
Local nqs2pbs(1B)