Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Match the amount fields in the source file vs trigger file Post 302584388 by jayan_jay on Friday 23rd of December 2011 03:07:40 AM
Old 12-23-2011
Ugly way .. Anyway got the result .. Smilie
Code:
a=$(nawk -F: '/amount fields:/{print "cut -d, -f"$2" < SALES"}' SALES_ParmFile|sh|
    nawk -F, '{for(i=1;i<=NF;i++)A[i]+=$i}END{for(i in A)printf A[i]" ";print ""}'| tr ' ' '\n'|grep '.'|sort -n|xargs)
 
b=$(nawk -F: '/amount fields:/{gsub(/,/," ",$2);gsub(/ /,"|SALES_AMOUNT",$2);print "egrep \""$2"\" SALES_TRIGGER"}' SALES_ParmFile|sh|
      awk -F: '{print $2|"sort -n|xargs"}')
 
[ "$a" == "$b" ] && echo "Matches" || echo "Not Matches"

Result may vary if input file changes ..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Trimmng leading 0's from amount fields

Hi I need to remove leading zeros if that filed is amount filed and trimmimg leading and trailing spaces U | U|1999-01-01|000004384|000002192|0000000000000000.0000|0000000000000000.0000| U|XXX|0000000000000685.5800| FIXED |U Tried with this... (2 Replies)
Discussion started by: mohan705
2 Replies

2. Shell Programming and Scripting

The script wont trigger it. Thief Catcher program (open source)

me and my team working on a project called Stealth Hunter, Summarize about our project: Stealth Hunter is a thief catcher, It will silently take a snapshot of user using a stolen notebook or pc with webcam and send the information via email. how it work is: The scripts will triggered by the... (0 Replies)
Discussion started by: Kiraichi
0 Replies

3. Shell Programming and Scripting

Source trigger in Unix shell

Hi All, Is ther any way to write the script with source trigger ? To trigger the script on particular time we have crontab. Similarly in a path, when a file comes particular script has to run. Thanks:) (7 Replies)
Discussion started by: jesu
7 Replies

4. Shell Programming and Scripting

awk help: Match data fields from 2 files & output results from both into 1 file

I need to take 2 input files and create 1 output based on matches from each file. I am looking to match field #1 in both files (Userid) and create an output file that will be a combination of fields from both file1 and file2 if there are any differences in the fields 2,3,4,5,or 6. Below is an... (5 Replies)
Discussion started by: ambroze
5 Replies

5. Programming

MYSQL - trigger to track changes to fields on update

So I have a php web application that allows updating of records. I would like to track the changes of only the fields that have changed. There are plenty of how to's that involve recreating the original row in a separate table with an additional time/date stamp column but I think this is a big... (1 Reply)
Discussion started by: barrydocks
1 Replies

6. UNIX for Beginners Questions & Answers

How to count lines of CSV file where 2 fields match variables?

I'm trying to use awk to count the occurrences of two matching fields of a CSV file. For instance, for data that looks like this... Joe,Blue,Yes,No,High Mike,Blue,Yes,Yes,Low Joe,Red,No,No,Low Joe,Red,Yes,Yes,Low I've been trying to use code like this... countvar=`awk ' $2~/$color/... (4 Replies)
Discussion started by: nmoore2843
4 Replies

7. UNIX for Beginners Questions & Answers

Match Fields between two files, print portions of each file together when matched in ([g]awk)'

I've written an awk script to compare two fields in two different files and then print portions of each file on the same line when matched. It works reasonably well, but every now and again, I notice some errors and cannot seem to figure out what the issue may be and am turning to you for help. ... (2 Replies)
Discussion started by: jvoot
2 Replies

8. Shell Programming and Scripting

awk move select fields to match file prefix in two directories

In the awk below I am trying to use the file1 as a match to file2. In file2 the contents of $5,&6,and $7 (always tab-delimited) and are copied to the output under the header Quality metrics. The below executes but the output is empty. I have added comments to help and show my thinking. Thank you... (0 Replies)
Discussion started by: cmccabe
0 Replies

9. Shell Programming and Scripting

awk to update file based on match in 3 fields

Trying to use awk to store the value of $5 in file1 in array x. That array x is then used to search $4 of file1 to find aa match (I use x to skip the header in file1). Since $4 can have multiple strings in it seperated by a , (comma), I split them and iterate througn each split looking for a match.... (2 Replies)
Discussion started by: cmccabe
2 Replies

10. Shell Programming and Scripting

Matching two fields in two csv files, create new file and append match

I am trying to parse two csv files and make a match in one column then print the entire file to a new file and append an additional column that gives description from the match to the new file. If a match is not made, I would like to add "NA" to the end of the file Command that Ive been using... (6 Replies)
Discussion started by: dis0wned
6 Replies
vxmemstat(1M)															     vxmemstat(1M)

NAME
vxmemstat - display memory statistics for Veritas Volume Manager SYNOPSIS
vxmemstat [-e] [-i interval [-t count]] DESCRIPTION
The vxmemstat utility prints memory statistics information. This information can be system-wide, or it can be specific to a Veritas Volume Replicator object. OPTIONS
-e Prints extended memory statistics. -i interval Prints memory statistics every interval seconds. -t count Prints the local system time every count intervals. The time interval is specified using the -i interval option. OUTPUT FORMAT
The statistics are prefaced by a timestamp showing the current local time on the system. Statistics are printed as a one-line output record for each memory pool. The records are preceded by two header lines. The output line consists of blank-separated fields. All numeric fields are in units of kilobytes. The following fields are displayed on each line: Pool Name of the memory pool. Memory consumers allocate memory from different pools for different purposes. DG Name of the disk group in which the RVG is present. Min Size Minimum amount of memory always reserved for use by consumers of the pool. As consumers require more memory, additional memory is allocated to the pool for distribution to them. Max Size Maximum amount of memory that can be allocated to the pool. This is equal to the value assigned to the maximum pool size system tunable that corresponds to the pool. In Use Amount of memory (out of that allocated) currently being used by consumers of the memory pool. Allocated Amount of memory currently allocated to the memory pool. The amount of memory allocated to a pool ranges between the minimum and the maximum pool size. The amount of allocated memory increases as more memory is needed and decreases as it is relinquished. Max Used Maximum amount of memory used by consumers from this pool since system startup. This field is not shown if the -e option is specified. Max Pool Used Maximum amount of memory used by consumers from this pool at any time since the last reboot. The value shows the maximum usage even if usage by the pool has varied over this time period. This field is shown if the -e option is specified. Waiting Indicates if any I/O is waiting to allocate memory from this pool. This usually indicates that the corresponding tunable for the maximum size of this pool needs to be increased. This field is not shown if the -e option is specified. Waiters The number of requests that are waiting to allocate memory from this pool. This field is shown if the -e option is specified. EXIT CODES
The vxmemstat utility exits with a non-zero status if the attempted operation fails. A non-zero exit code is not a complete indicator of the problems encountered, but rather denotes the first condition that prevented further execution of the utility. See vxintro(1M) for a list of standard exit codes. EXAMPLES
To display statistics every 5 seconds and time stamp the output every alternate interval, use the command: vxmemstat -i 5 -t 2 SEE ALSO
vxintro(1M), vxstat(1M) VxVM 5.0.31.1 24 Mar 2008 vxmemstat(1M)
All times are GMT -4. The time now is 04:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy