Sponsored Content
Top Forums Shell Programming and Scripting Script to find string based on pattern and search for its corresponding rows in column Post 303037335 by as7951 on Tuesday 30th of July 2019 02:00:36 AM
Old 07-30-2019
Hi Chubler_XL,

Thank you very much..
Really appreciate your help.
Got the expected output.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows??

Hi friends I have 100 files in my directory. Each file look like this.. Temp1 Temp2 Temp3 MAS 1 2 3 MAS 4 5 6 MAS 7 8 9 Delhi 10 11 12 Delhi 13 14 15 Delhi 16 17 ... (4 Replies)
Discussion started by: ks_reddy
4 Replies

2. Shell Programming and Scripting

Script to find the average of a given column and also for specified number of rows?

Hi Friends, In continuation to my earlier post https://www.unix.com/shell-programming-scripting/99166-script-find-average-given-column-also-specified-number-rows.html I am extending my problem as follows. Input: Column1 Column2 MAS 1 MAS 4 ... (2 Replies)
Discussion started by: ks_reddy
2 Replies

3. Shell Programming and Scripting

Print a pattern between the xml tags based on a search pattern

Hi all, I am trying to extract the values ( text between the xml tags) based on the Order Number. here is the sample input <?xml version="1.0" encoding="UTF-8"?> <NJCustomer> <Header> <MessageIdentifier>Y504173382</MessageIdentifier> ... (13 Replies)
Discussion started by: oky
13 Replies

4. Shell Programming and Scripting

need to remove duplicates based on key in first column and pattern in last column

Given a file such as this I need to remove the duplicates. 00060011 PAUL BOWSTEIN ad_waq3_921_20100826_010517.txt 00060011 PAUL BOWSTEIN ad_waq3_921_20100827_010528.txt 0624-01 RUT CORPORATION ad_sade3_10_20100827_010528.txt 0624-01 RUT CORPORATION ... (13 Replies)
Discussion started by: script_op2a
13 Replies

5. Shell Programming and Scripting

bash script to find date based on search string for continuesly updating file

Hi All, I am very new to UNIX and I have tried this for a longtime now and unable to crack it.... There is a file that is continuously updating. I need to search for the string and find the date @ which it updated every day..... eg: String is "work started" The log entry is as below: ... (1 Reply)
Discussion started by: Nithz
1 Replies

6. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

7. Shell Programming and Scripting

Find and copy files based on todays date and search for a particular string

Hi All, I am new to shell srcipting. Problem : I need to write a script which copy the log files from /prod/logs directory based on todays date like (Jul 17) and place it to /home/hzjnr0 directory and then search the copied logfiles for the string "@ending successfully on Thu Jul 17". If... (2 Replies)
Discussion started by: mail.chiranjit
2 Replies

8. UNIX for Dummies Questions & Answers

merging rows into new file based on rows and first column

I have 2 files, file01= 7 columns, row unknown (but few) file02= 7 columns, row unknown (but many) now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there e.g. file 01 James|0|50|25|10|50|30... (1 Reply)
Discussion started by: A-V
1 Replies

9. Shell Programming and Scripting

How can I use find command to search string/pattern in a file recursively?

Hi, How can I use find command to search string/pattern in a file recursively? What I tried: find . -type f -exec cat {} | grep "make" \; Output: grep: find: ;: No such file or directory missing argument to `-exec' And this: find . -type f -exec cat {} \; -exec grep "make" {} \;... (12 Replies)
Discussion started by: cola
12 Replies

10. UNIX for Beginners Questions & Answers

Merging rows based on same ID in First column.

Hellow, I have a tab-delimited file with 3 columns : BINPACKER.13259.1.p2 SSF48239 BINPACKER.13259.1.p2 PF13243 BINPACKER.13259.1.p2 G3DSA:1.50.10.20 BINPACKER.13259.2.p2 SSF48239 BINPACKER.13259.2.p2 PF13243 BINPACKER.13259.2.p2 G3DSA:1.50.10.20... (7 Replies)
Discussion started by: anjaliANJALI
7 Replies
CFETOOLCHECK(8) 					User Contributed Perl Documentation					   CFETOOLCHECK(8)

NAME
cfetoolcheck - Check a new value against the averages currently in the database SYNOPSIS
cfetool check name --value|-V value [--path|-p directory name] [--time|-t seconds] [--daily|-d] [--weekly|-w] [--yearly|-y] [--his- tograms|-H] [--verbose|-v] [--help|-h] DESCRIPTION
Takes a new value and checks it against the averages currently in the database specified by name, located at the path specified by the -p argument, or the current working directory if the -p argument is omitted. The value will be associated with the current time, unless the -t option is given. The output indicates how much higher or lower the new value is compared to the averages in the database, in terms of the number of standard deviations. The -d, -w and -y options specify the databases to check the new value against. If all three options are omitted, only the weekly database will be accessed. OPTIONS
--value|-v value Specifies the new value to check against the database averages. --path|-p directory name The directory in which the database specified by name can be found. --time|-t The time the value was collected, in seconds since epoch (January 1st, 1970). If this argument is omitted, the current time will be used. --daily|-d Check the new value against the daily averages database. --weekly|-w Check the new value against the weekly averages database. --yearly|-y Check the new value against the yearly averages database. --histograms|-H Check which histogram bucket the new value would fall into. The histogram is divided into 64 buckets, which represent distances from the mean value. Bucket 64 represents two standard deviations above the expected value, and bucket 0 represents two standard deviations below the expected value. --verbose|-v Print details of the command's execution to the standard output stream. --help|-h Print a short help message and then exit. OUTPUT
Before exiting, "cfetool check" will print one line to the standard output stream, in the following format: yrly=ynum,bkt=ybkt;wkly=wnum,bkt=wbkt;dly=dnum,bkt=dbkt ybkt, wbkt and dbkt represent the histogram bucket the given value falls into, and will be 0 for databases that are not being checked against, and if there is no histogram file or the -H option was not specified. ynum, wnum and dnum will be either the number 0 if the corresponding database was not updated, or a code indicating the state of the given statistic, as compared to an average of equivalent earlier times, as specified below: code high|low|normal meaning ------------------------------------------------------------- -2 - no sigma variation ------------------------------------------------------------- -4 low within noise threshold, and within -5 normal 2 standard deviations from -6 high expected value ------------------------------------------------------------- -14 low microanomaly: within noise -15 normal threshold, but 2 or more standard -16 high deviations from expected value ------------------------------------------------------------- -24 low normal; within 1 standard deviation -25 normal from the expected value -26 high ------------------------------------------------------------- -34 low dev1; more than 1 standard -35 normal deviation from the expected -36 high value ------------------------------------------------------------ -44 low dev2; more than 2 standard -45 normal deviations from the expected -46 high value ------------------------------------------------------------- -54 low anomaly; more than 3 standard -55 normal deviations from the expected -56 high value Where "low" indicates that the current value is below both the expected value for the current time position, and the global average value. "high" indicates that the current value is above those values. "normal" indicates that the current value is within the range of expected values. "cfetool check" also exits with a code corresponding to the above table. If more than one database is being checked against, the most nega- tive result from all checks is returned, and the individual results must be obtained from the standard output stream, as described above. EXAMPLE
% cfetool check temperature --path /my/path --value 20 --histograms yrly=0,bkt=0;wkly=-6,bkt=51;dly=0,bkt=0 Checks the value 20 against the weekly temperature database and histogram files located in /my/path/ using the current time. The output indicates that the new value given was within cfetool's noise threshold, and also within 2 standard deviations of the previous average stored in the weekly database. AUTHORS
The code and documentation were contributed by Stanford Linear Accelerator Center, a department of Stanford University. This documentation was written by Elizabeth Cassell <e_a_c@mailsnare.net> and Alf Wachsmann <alfw@slac.stanford.edu> COPYRIGHT AND DISCLAIMER
Copyright 2004 Alf Wachsmann <alfw@slac.stanford.edu> and Elizabeth Cassell <e_a_c@mailsnare.net> All rights reserved. perl v5.8.4 2004-09-21 CFETOOLCHECK(8)
All times are GMT -4. The time now is 01:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy