01-19-2011
Reading only first record from the multipe directories
Hi All,
I have a requirement, I had a parent directory Land under that we have sub directories
Yesterday,
Today and
Tommorrow
And we have a file test.txt under the above directories Yesterday, Today and Tommorrow
The data in the file test.txt under Yesterday folder is
Header|2011-12-01
DATA|TOTAL1
DATA|TOTAL2
EOF
The data in the file test.txt under Today folder is
Header|2011-13-01
DATA|TOTAL3
DATA|TOTAL4
EOF
The data in the file test.txt under Tommorrow folder is
Header|2011-14-01
DATA|TOTAL5
DATA|TOTAL6
EOF
I want to get only the 1st records after removing header records from the files like below
DATA|TOTAL1
DATA|TOTAL3
DATA|TOTAL5
I used below command
I used below command awk -F"|" 'BEGIN{IGNORECASE=1;} $1~/DATA/' Land/*/test.txt
I'm getting all the records and the data is as shown below
DATA|TOTAL1
DATA|TOTAL2
DATA|TOTAL3
DATA|TOTAL4
DATA|TOTAL5
DATA|TOTAL6
Thanks,
Raju
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, people.
I was searching script tutorials/examples and found this forum, and thought to ask for help, because there seems to be many wise people here.
(Try to bare with me, I'm a Windows user, so this stuff is somewhat strange to me, OK? :rolleyes: )
Anyways, I need to create a script that... (3 Replies)
Discussion started by: Gill Bates
3 Replies
2. UNIX for Dummies Questions & Answers
I have a file in following format
directory1=/out/log
purgedays1=4
extn1=log,out,txt
directory2=/clean/log
purgedays2=4
extn2=log,out
now i need need to create a script that reads this file and cleans all the files with the given extn from the given directory.
The catch here is that... (2 Replies)
Discussion started by: max_payne1234
2 Replies
3. Shell Programming and Scripting
Hi,
I am trying to create a while loop that will do the following:
INFILE= list of new records that need to be added after last previous record
while read record
do
find the last record processed
create list of new records output to a file
echo "$record">> $NEWFILE
done
... (9 Replies)
Discussion started by: shortyball24
9 Replies
4. Shell Programming and Scripting
Hi Guys,
I need to check whether the last column is RP, If so, then i have to second column and pass it to a select statement as sonid and fetch the value to a variable and run it. This has to be done till the last column is RW.
value Fatherid sonid topid ... (8 Replies)
Discussion started by: mac4rfree
8 Replies
5. Shell Programming and Scripting
I am trying to read a file in a shl script (only one record) and stored in a variable file_number
I got the following
read -u $BANNER_HOME/xxxxxxx/misc/EFTSQL.dat file_number
file_number2 = $file_number + 1
echo $file_number2 > $BANNER_HOME/xxxxxx/misc/EFTSQL.dat
EOF
It is not working... (2 Replies)
Discussion started by: rechever
2 Replies
6. Shell Programming and Scripting
Hi friends,
I have small query with reg to awk search pattern..
below is my sample file and code which i tried..
$ cat file.txt
xxx,yyyyy,messageID,sha
xxxx,errorcode,messageID,name
in the above sample file - let assume I know the errorcode(2nd record) using which I want to... (2 Replies)
Discussion started by: Shahul
2 Replies
7. Shell Programming and Scripting
Hi
Need urgent help (2 Replies)
Discussion started by: premp26
2 Replies
8. Shell Programming and Scripting
Hi all,
I have some directory structure as
$ls -ltr
drwxr-xr-x 1 mscprod us_msc 512 May 10 08:34 650
drwxr-xr-x 1 mscprod us_msc 512 May 10 08:51 652
drwxr-xr-x 1 mscprod us_msc 512 May 10 08:51 640
drwxr-xr-x 1 mscprod us_msc512 May 10 09:13 654
$ cd 650/
$ls
fileabc.root
and within... (7 Replies)
Discussion started by: emily
7 Replies
9. Shell Programming and Scripting
Hello
I'm making script for Dallas temperature sensors (DS1820).
When a sensor is connected, it shows up as a directory in /sys/bus/w1/devices
in format 10-xxxxxxx. Inside the directory is a file called w1_slave which holds the temperature in format t=xxxxx.
Each sensor has unique... (2 Replies)
Discussion started by: Klipeti
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
In a parent directory there are several files in the form
IDENTIFIER1x
IDENTIFIER1.yyy
IDENTIFIER1_Z, etc
IDENTIFIER2x
IDENTIFIER2.yyy
IDENTIFIER2_Z, etc
IDENTIFIER3x
IDENTIFIER3.yyy,
IDENTIFIER3_Z, etcIn the same parent directory there are corresponding directories named... (7 Replies)
Discussion started by: spirospap
7 Replies
LEARN ABOUT CENTOS
auvirt
AUVIRT(8) System Administration Utilities AUVIRT(8)
NAME
auvirt - a program that shows data related to virtual machines
SYNOPSIS
auvirt [ OPTIONS ]
DESCRIPTION
auvirt shows a list of guest sessions found in the audit logs. If a guest is specified, only the events related to that guest is consid-
ered. To specify a guest, both UUID or VM name can be given.
For each guest session the tool prints a record with the domain name, the user that started the guest, the time when the guest was started
and the time when the guest was stoped.
If the option "--all-events" is given a more detailed output is shown. In this mode other records are shown for guest's stops, resource
assignments, host shutdowns and AVC and anomaly events. The first field indicates the event type and can have the following values: start,
stop, res, avc, anom and down (for host shutdowns).
Resource assignments have the additional fields: resource type, reason and resource. And AVC records have the following additional fields:
operation, result, command and target.
By default, auvirt reads records from the system audit log file. But --stdin and --file options can be specified to change this behavior.
OPTIONS
--all-events
Show records for all virtualization related events.
--debug
Print debug messages to standard output.
-f, --file file
Read records from the given file instead from the system audit log file.
-h, --help
Print help message and exit.
--proof
Add after each event a line containing all the identifiers of the audit records used to calculate the event. Each identifier con-
sists of unix time, milliseconds and serial number.
--show-uuid
Add the guest's UUID to each record.
--stdin
Read records from the standard input instead from the system audit log file. This option cannot be specified with --file.
--summary
Print a summary with information about the events found. The summary contains the considered range of time, the number of guest
starts and stops, the number of resource assignments, the number of AVC and anomaly events, the number of host shutdowns and the
number of failed operations.
-te, --end [end-date] [end-time]
Search for events with time stamps equal to or before the given end time. The format of end time depends on your locale. If the date
is omitted, today is assumed. If the time is omitted, now is assumed. Use 24 hour clock time rather than AM or PM to specify time.
An example date using the en_US.utf8 locale is 09/03/2009. An example of time is 18:00:00. The date format accepted is influenced by
the LC_TIME environmental variable.
You may also use the word: now, recent, today, yesterday, this-week, week-ago, this-month, this-year. Today means starting now.
Recent is 10 minutes ago. Yesterday is 1 second after midnight the previous day. This-week means starting 1 second after midnight
on day 0 of the week determined by your locale (see localtime). This-month means 1 second after midnight on day 1 of the month.
This-year means the 1 second after midnight on the first day of the first month.
-ts, --start [start-date] [start-time]
Search for events with time stamps equal to or after the given end time. The format of end time depends on your locale. If the date
is omitted, today is assumed. If the time is omitted, midnight is assumed. Use 24 hour clock time rather than AM or PM to specify
time. An example date using the en_US.utf8 locale is 09/03/2009. An example of time is 18:00:00. The date format accepted is influ-
enced by the LC_TIME environmental variable.
You may also use the word: now, recent, today, yesterday, this-week, this-month, this-year. Today means starting at 1 second after
midnight. Recent is 10 minutes ago. Yesterday is 1 second after midnight the previous day. This-week means starting 1 second after
midnight on day 0 of the week determined by your locale (see localtime). This-month means 1 second after midnight on day 1 of the
month. This-year means the 1 second after midnight on the first day of the first month.
-u, --uuid UUID
Only show events related to the guest with the given UUID.
-v, --vm name
Only show events related to the guest with the given name.
EXAMPLES
To see all the records in this month for a guest
auvirt --start this-month --vm GuestVmName --all-events
SEE ALSO
aulast(8), ausearch(8), aureport(8).
AUTHOR
Marcelo Cerri
IBM Corp Dec 2011 AUVIRT(8)