I use the following script to calculate the number of entries in each $1= 1, 2, 3... consistent with the defined values for parameter A, B, C and D.
Code:
BEGIN {
r=5; #parameterA
x=9; #parameterB
solv2="TFE"; #parameterC
solv1="TIP3"; #parameterD
}
/CA 1/ #pattern for row to earch in. in order to skip header of the file
{if ( ($9*1 < r) && (( $7 ~ solv1 )||($7 ~ solv2)) ) a[$1]++;else a[$1]+=0;} #$9*1 to avoid wrong counting that occured sometimes
END{for (i in a)print i,a[i]}
So it is messing up the order and including parts of the header in the output and printing the whole inputfile at the beginning... I am confused
The input file looks like this
Code:
NAME DWT26R1_CA1_PEP1.DAT
FRAMES[PS] 5000
SKIPPED 500
STEP 50
PROCESSED 90
1 CA 1 98 1 2643 TFE F21 9.5831
1 CA 1 98 2 2654 TFE O1 6.25134
1 CA 1 98 3 2681 TFE O1 5.01697
1 CA 1 98 4 2751 TFE O1 6.45506
1 CA 1 98 15 5702 TFE O1 9.63541
1 CA 1 98 16 6096 TFE O1 4.69877
1 CA 1 98 17 6337 TFE O1 6.64662
1 CA 1 98 18 8167 TIP3 OH2 5.73264
2 CA 1 103 18 6096 TFE O1 6.27655
2 CA 1 103 19 6337 TFE O1 8.68132
2 CA 1 103 20 8167 TIP3 OH2 3.85201
2 CA 1 103 21 8178 TIP3 OH2 7.49269
2 CA 1 103 22 8481 TIP3 OH2 6.79798
2 CA 1 103 23 8591 TIP3 OH2 3.98057
2 CA 1 103 24 9917 TIP3 OH2 5.53047
.
.
.
Cheers,
Daniel
---------- Post updated at 06:18 AM ---------- Previous update was at 02:41 AM ----------
I managed to get the output in the correct order by changing the lor loop:
Code:
END {for ( i=1; i<100; i++) print i,a[i]}
However I have still have a question
I have several input files representing successive data sets. However the time step ($1) starts for each file with 1. I need to continue increasing that value instead of starting at 1 again with reading from a new file.
cheers,
daniel
Last edited by Daniel8472; 08-05-2010 at 04:58 AM..
Hi,
I need to extract the start time value (bold, red font) under the '<LogEvent ID="Timer Start">' tag (black bold) from a file with the following pattern. There are other LogEventIDs listed in the file as well, making it harder for me to extract out the specific start time that I need.
.
.... (7 Replies)
Hi , I am having a script which will start a process and appends the process related logs to a log file. The log file writes logs with every line starting with date in the format of: date +"%Y %b %d %H:%M:%S".
So, in the script, before I start the process, I am storing the date as DATE=`date +"%Y... (5 Replies)
Hi
I want to extract certain text between two line numbers like
23234234324 and
54446655567567
How do I do this with a simple sed or awk command?
Thank you.
---------- Post updated at 06:16 PM ---------- Previous update was at 05:55 PM ----------
found it:
sed -n '#1,#2p'... (1 Reply)
:confused: I have a tab delimited file that I need to extract data from and into a file with specific field specs. Each field has to be a certain amount of characters. So, the name field (from delimited file) might have only 15 characters but needs to be 25 (in new file) so I need to insert spaces... (5 Replies)
Hello People,
I have the following contents in an XML file
...........
...........
..........
...........
<Details = "Sample Details">
<Name>Bob</Name>
<Age>34</Age>
<Address>CA</Address>
<ContactNumber>1234</ContactNumber>
</Details>
...........
.............
.............. (4 Replies)
My input:
Data name: ABC001
Data length: 1000
Detail info
Data Direction Start_time End_time Length
1 forward 10 100 90
1 forward 15 200 185
2 reverse 50 500 450
Data name: XFG110
Data length: 100
Detail info
Data Direction Start_time End_time Length
1 forward 50 100 50 ... (11 Replies)
Hi,
I search all forum, but I can not find solutions of my problem :(
I have multiple files (5000 files), inside there is this data :
FILE 1:
1195.921 -898.995 0.750312E-02-0.497526E-02 0.195382E-05 0.609417E-05
-2021.287 1305.479-0.819754E-02 0.107572E-01 0.313018E-05 0.885066E-05
... (15 Replies)
hi I want to write a script which count the number of subdirectories in the current root directory that contain more than a specified number of files of a specific type. Is there an easy way to do this?
Thanks
Robert (2 Replies)
Hi All,
I'm stuck-up in finding a way to skip the delimiter which come within double quotes using awk or any other better option. can someone please help me out.
Below are the details:
Delimited: |
Sample data: 742433154|"SYN|THESIS MED CHEM PTY.... (2 Replies)
data.txt has several information like the below..
<SERVER>:WEB:MYDOM01:/tmp/cong/MYDOM01,/tmp/app/MYDOM01
<WEBER>:CANES:https-web01,https-web02:/web/apps/https-web01/config
<SERVER>:WEB:MYDOM07:/tmp/cong/MYDOM07,/tmp/app/MYDOM07... (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT OPENSOLARIS
prtdscp
prtdscp(1M) System Administration Commands prtdscp(1M)NAME
prtdscp - display DSCP IP addresses
SYNOPSIS
prtdscp [-v ]
prtdscp [-v ] -h
prtdscp [-v ] -d
prtdscp [-v ] -s
DESCRIPTION
prtdscp displays the IP addresses associated with a Domain to Service Processor Communications Protocol (DSCP) link. If no arguments are
specified, prtdscp displays the IP addresses on both ends of the DSCP link. The IP address of either the Service Processor or domain side
can be displayed separately by the use of the -s or -d options, respectively.
OPTIONS
The following options are supported:
-v Verbose mode. Print additional details about the program's internal progress to stderr.
-h Help. Print a brief synopsis of the program's usage and exit. All other command line arguments are ignored.
-d Display only the local domain's IP address.
-s Display only the remote Service Processor's IP address.
EXAMPLES
Example 1 Displaying both addresses
The following example displays both the local domain's IP address and the remote SP's IP address:
# prtdscp
Domain Address: 192.168.103.2
SP Address: 192.168.103.1
Example 2 Displaying the local IP address
The following example displays the local domain's IP address:
# prtdscp -d
192.168.103.2
Example 3 Displaying the remote IP address
The following example display the remote SP's IP address:
# prtdscp -s
192.168.103.1
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWdscpr.u, SUNWdscpu.u |
+-----------------------------+-----------------------------+
|Interface Stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO attributes(5)SunOS 5.11 25 Apr 2006 prtdscp(1M)
08-05-2010
