Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Reading only first record from the multipe directories Post 302489167 by somu_june on Wednesday 19th of January 2011 04:35:02 PM
Old 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

Need help with complicated script (reading directories, extracting data)

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

Clean directories by reading from file

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

While loop reading a record

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

problem in reading a record from the file

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

Reading a file (one record) in a SHL script

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

Reading input record from inside nawk

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

Parsing issue while reading excel having 3000 record

Hi Need urgent help (2 Replies)
Discussion started by: premp26
2 Replies

8. Shell Programming and Scripting

reading filename in nested directories

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

Reading multiple directories and file from them

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

Move multipe files to corresponding directories

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
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)
All times are GMT -4. The time now is 07:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy