Sponsored Content
Top Forums UNIX for Beginners Questions & Answers awk for matching fields between files with repeated records Post 303041190 by jvoot on Sunday 17th of November 2019 04:22:18 PM
Old 11-17-2019
Thanks so much RavinderSingh13. An early quick test seems to reveal that that did the trick!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

AWK ??-print for fields within records in a file

Hello all, Would appreciate if someone can help me out on the following requirement. INPUT FILE: -------------------------- TPS REPORT abc def ghi jkl mon pqr stu vrs lll END OF TPS REPORT TPS REPORT field1 field2 field3 field4 field5 field6 (8 Replies)
Discussion started by: hyennah
8 Replies

2. Shell Programming and Scripting

AWK Matching Fields and Combining Files

Hello! I am writing a program to run through two large lists of data (~300,000 rows), find where rows in one file match another, and combine them based on matching fields. Due to the large file sizes, I'm guessing AWK will be the most efficient way to do this. Overall, the input and output I'm... (5 Replies)
Discussion started by: Michelangelo
5 Replies

3. Shell Programming and Scripting

Averaging all fields while counting repeated records

Hi every one; I have a 31500-line text file upon which two following tasks are to be performed: 1: Rearranging the file 2: Taking the average of each column (considering number of zeros) and output the result into a new file This is the code I've come up with: awk '(NR%3150<3150)... (0 Replies)
Discussion started by: nxp
0 Replies

4. Shell Programming and Scripting

awk pattern matching name in records

Hi, I'm very new to these forums. I was wondering if someone could help an AWK beginner with a pattern matching an actor to his appearance in movies, which would be stored as records. Let's say we have a database of 4 movies (each movie a record with name, studio + year, and actor fields with... (2 Replies)
Discussion started by: Jill Ceke
2 Replies

5. UNIX for Dummies Questions & Answers

Make all records with the same number of fields (awk)

Hi, input: AA|BB|CC DD|EE FF what I am trying to get: AA|BB|CC DD|EE| FF|| I tried to create first an UDF for printing repeats, but I think I have an issue with my END section or my array: function repeat(str, n, rep, i) { for(i=1 ;i<n;i++) rep=rep str return rep } ... (6 Replies)
Discussion started by: beca123456
6 Replies

6. UNIX for Beginners Questions & Answers

Awk: matching multiple fields between 2 files

Hi, I have 2 tab-delimited input files as follows. file1.tab: green A apple red B apple file2.tab: apple - A;Z Objective: Return $1 of file1 if, . $1 of file2 matches $3 of file1 and, . any single element (separated by ";") in $3 of file2 is present in $2 of file1 In order to... (3 Replies)
Discussion started by: beca123456
3 Replies

7. Shell Programming and Scripting

awk to print fields that match using conditions and a default value for non-matching in two files

Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2... (6 Replies)
Discussion started by: cmccabe
6 Replies

8. UNIX for Beginners Questions & Answers

Continued trouble matching fields in different files and selective field printing ([g]awk)

I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help. I have data as follows: File1 PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
Discussion started by: jvoot
7 Replies

9. UNIX for Beginners Questions & Answers

Matching fields between two files, repeated records

In two previous posts (here) and (here), I received help from forum members comparing multiple fields across two files and selectively printing portions of each as output based upon would-be matches using awk. I had been fairly comfortable populating awk arrays with fields and using awk's special... (3 Replies)
Discussion started by: jvoot
3 Replies

10. UNIX for Beginners Questions & Answers

Awk: group multiple fields from different records

Hi, My input looks like that: A|123|qwer A|456|tyui A|456|wsxe B|789|dfgh Using awk, I am trying to get: A|123;456|qwer;tyui;wsxe B|789|dfgh For records with same $1, group all the $2 in a field (without replicates), and all the $3 in a field (without replicates). What I have tried:... (6 Replies)
Discussion started by: beca123456
6 Replies
ONEAC(8)							    NUT Manual								  ONEAC(8)

NAME
oneac - Driver for Oneac UPS equipment NOTE
This man page only documents the hardware-specific features of the oneac driver. For information about the core driver, see nutupsdrv(8). SUPPORTED HARDWARE
This driver supports various Oneac UPS families: o EG (late 80s, early 90s, plug-in serial interface card) o ON (early and mid-90s, plug-in serial interface card) o OZ (mid-90s on, DB-25 std., interface slot) o OB (early 2000's on, big cabinet, DB-25 std., interface slot) If your UPS is equipped with the Basic Interface card, use the genericups(8) driver. EXTRA ARGUMENTS
This driver supports the following optional settings in the ups.conf(5) file: testtime=num Change battery test time from the 2 minute default. offdelay=num Change shutdown delay time from 0 second default. INSTANT COMMANDS
This driver supports the following Instant Commands. (See upscmd(8)) All UPS units shutdown.return Turn off the load possibly after a delay and return when power is back. shutdown.stop Stop a shutdown in progress. shutdown.reboot Shut down the load briefly while rebooting the UPS. test.failure.start Starts a 15 second long simulation of an input power failure. test.battery.start.quick Start a "quick" battery test. The default time is 2 minutes. This time can be set in the ups.conf file. See testime above. test.battery.stop Stops a battery test that is in progress. All ON UPS units reset.input.minmax Reset the minimum and maximum input line voltage values seen since the last reset or power on. Newer ON UPS units test.panel.start Start testing the UPS panel. test.battery.start.deep Start a "deep" battery test. This test runs the UPS until the low battery point and then returns to the AC line. reset.input.minmax Reset the minimum and maximum input line voltage values seen since the last reset or power on. beeper.enable Enable UPS beeper/buzzer. beeper.disable Disable UPS beeper/buzzer. beeper.mute Mutes the UPS beeper/buzzer for the current alarm condition(s). WRITABLE VARIABLES
See upsrw(8) to see what variables are writable for the UPS. Note If your UPS supports writing battery.runtime.low, the new set value is to be entered in minutes (up to 99) but the reported value is reported in seconds (set value * 60). Note If your UPS supports input.transfer.low and input.transfer.high, those values are used to create an allowable output range. The UPS will do what it can to keep the output voltage value within the defined range (for example: tap change or switch to inverter). AUTHOR
Bill Elliot <bill@wreassoc.com>, Eric Lawson <elawson@inficad.com> SEE ALSO
The core driver: nutupsdrv(8) Internet resources: The NUT (Network UPS Tools) home page: http://www.networkupstools.org/ Network UPS Tools 05/21/2012 ONEAC(8)
All times are GMT -4. The time now is 02:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy