Sponsored Content
Top Forums Shell Programming and Scripting How to compare a field value of a same column? Post 302198970 by jaduks on Sunday 25th of May 2008 09:54:50 AM
Old 05-25-2008
One part of your query:

Code:
$ awk '{count[$2]++}END{for(j in count) print j,"("count[j]")"}' gobinath.txt
BAD (5)
GOOD (6)

//Jadu
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare files column to column based on keys

Here is my situation. I need to compare two tab separated files (diff is not useful since there could be known difference between files). I have found similar posts , but not fully matching.I was thinking of writing a shell script using cut and grep and while loop but after going thru posts it... (2 Replies)
Discussion started by: blackjack101
2 Replies

2. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ... (6 Replies)
Discussion started by: popesk
6 Replies

3. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

4. Shell Programming and Scripting

Compare Field in Current Line with Field in Previous

Hi Guys I have the following file Essentially, I am trying to find the right awk/sed syntax in order to produce the following 3 distinct files from the file above: Basically, I want to print the lines of the file as long as the second field of the current line is equal to the... (9 Replies)
Discussion started by: moutaye
9 Replies

5. Shell Programming and Scripting

Compare a common field in two files and append a column from File 1 in File2

Hi Friends, I am new to Shell Scripting and need your help in the below situation. - I have two files (File 1 and File 2) and the contents of the files are mentioned below. - "Application handle" is the common field in both the files. (NOTE :- PLEASE REFER TO THE ATTACHMENT "Compare files... (2 Replies)
Discussion started by: Santoshbn
2 Replies

6. Shell Programming and Scripting

Compare two files Field by field and output the result in another file

Hi Friends, Need Help. I have file1.txt as File1.txt |123|A|7267|Hyder|Cross|Sell|7801 |995|A|7051|2008|Lunar|New|Year|Promotion|7801 |996|A|7022|Q108|Targ|Prospect|&|SSCC|Savings|Promo|7801 |997|A|7182|Q1|Feb-Apr|08|Credit|ITA|PA|SBA|Campaign|7801 File2.txt... (7 Replies)
Discussion started by: i150371485
7 Replies

7. Shell Programming and Scripting

Plz Help. Compare 2 files field by field and get the output in another file.

Hi Freinds, I have 2 files . one is source.txt and second one is target.txt. I want to keep source.txt as baseline and compare target.txt. please find the data in 2 files and Expected output. Source.txt 1|HYD|NAG|TRA|34.5|1234 2|CHE|ESW|DES|36.5|134 3|BAN|MEH|TRA|33.5|234... (5 Replies)
Discussion started by: i150371485
5 Replies

8. UNIX for Dummies Questions & Answers

Compare data - Match first column and compare second

Hi guys, looking for some help with a way to compare data in two files but with some conditions. example, File 1 consists of site1,10.1.1.1 site2,20.2.2.2 site3,30.3.3.3 File 2 contains site1,l0.1.1.1 site2,50.1.1.1 site3,30.3.3.3 site4,40.1.1.1 I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies

9. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

10. UNIX for Beginners Questions & Answers

UNIX script to compare 3rd column value with first column and display

Hello Team, My source data (INput) is like below EPIC1 router EPIC2 Targetdefinition Exp1 Expres rtr1 Router SQL SrcQual Exp1 Expres rtr1 Router EPIC1 Targetdefinition My output like SQL SrcQual Exp1 Expres Exp1 Expres rtr1 Router rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies
AMGTAR(8)						  System Administration Commands						 AMGTAR(8)

NAME
amgtar - Amanda Application to interface with GNU Tar DESCRIPTION
Amgtar is an Amanda Application API script. It should not be run by users directly. It uses GNU Tar to backup and restore data. The diskdevice in the disklist (DLE) must be the directory to backup. PROPERTIES
This section lists the properties that control amgtar's functionality. See amanda-applications(7) for information on application properties and how they are configured. ATIME-PRESERVE If "YES" (the default), amgtar use the --atime-preserve=system option of gnutar to not update the atime of all files accessed; if "NO", gnutar will updates the atime for all files accessed. This property works only if you have gnutar 1.15.90 or newer, if not, you must set ATIME_PRESERVE to "NO". CHECK-DEVICE If "YES" (the default), amgtar checks that the device number doesn't change for each file. If "NO", changes in device number are ignored. To ignore device numbers, tar must support the --no-check-device option (gnutar 1.19.90 and newer). This option is needed for some filesystems and devices on which device numbers change frequently, such as LVM or FiberChannel. COMMAND-OPTIONS If set, theses options are passed asis to gtar. Each option must be a different value of the property. Some option can break how amanda do backup, use it with care. Use: property "COMMAND-OPTIONS" "--foo" "bar" Do not use: property "COMMAND-OPTIONS" "--foo bar" DIRECTORY If set, gnutar will backup from that directory instead of the diskdevice set by the DLE. On restore, the data is restore in that directory instead of the current working directory. GNUTAR-LISTDIR The directory where gnutar stores the database it uses to generate incremental dumps. The default is set when Amanda is built. GNUTAR-PATH The path to the gnutar binary. The default is set when Amanda is built. INCLUDE-LIST-GLOB A filename containing include glob expression for the restore command. EXCLUDE-LIST-GLOB A filename containing exclude glob expression for the restore command. ONE-FILE-SYSTEM If "YES" (the default), do not allow gnutar to cross filesystem boundaries. If "NO", gnutar will cross filesystem boundaries. This corresponds to the --one-filesystem option of gnutar. TAR-BLOCKSIZE Block size of Nx512 bytes (default N=20). This corresponds to the --blocking-factor option of gnutar. SPARSE If "YES" (the default), gnutar will store sparse files efficiently. If "NO", then the --sparse option is not given to gnutar, and it will not try to detect sparse files. NO-UNQUOTE If "NO" (the default), gnutar doesn't get the --no-unquote option and the diskname can't have some characters, eg. ''. If "YES", then the --no-unquote option is given to gnutar and the diskname can have any characters. This option is available only if you are using tar-1.16 or newer. ACLS Default "NO". If "YES", gnutar will preserve ACL extended attributes. This corresponds to the --acls gnutar option. Requires a GNU Tar with nonstandard extended attribute patches from the Fedora Project. SELINUX Default "NO". If "YES", gnutar will preserve SELinux extended attributes on Linux. This corresponds to the --selinux gnutar option. Requires a GNU Tar with nonstandard extended attribute patches from the Fedora Project. XATTRS Default "NO". If "YES", gnutar will preserve all extended attributes. This corresponds to the --xattrs gnutar option. If enabled, this option also implies the ACLS and SELINUX properties, regardless of their settings, as they are implemented as extended attributes. Requires a GNU Tar with nonstandard extended attribute patches from the Fedora Project. EXIT-HANDLING List which exit status of gtar are good or bad. eg. "1=GOOD 2=BAD", exit status of 1 will produce a good backup, exit status of 2 will give an error. NORMAL List all regex (POSIX Extended Regular Expression syntax) that are normal output from gtar. These output are in the "FAILED DUMP DETAILS" section of the email report if the dump result is STRANGE or FAILED. Default values: "^could not open conf file" "^Elapsed time:" "^Throughput" ": socket ignored$" ": File .* shrunk by [0-9][0-9]* bytes, padding with zeros" ": Cannot add file .*: No such file or directory$" ": Error exit delayed from previous errors" To treat one of these default patterns differently, specify it explicitly in a different property. IGNORE List all regex (POSIX Extended Regular Expression syntax) that amanda ignore. These output are never in the email report. Default values: ": Directory is new$" ": Directory has been renamed" To treat one of these default patterns differently, specify it explicitly in a different property. STRANGE List all regex (POSIX Extended Regular Expression syntax) that are strange output from gtar. All gtar output that doesn't match a normal or ignore regex are strange by default. The result of the dump is STRANGE if gtar produce a strange output. These output are in the "FAILED DUMP DETAILS" section of the email report. VERBOSE Default: "NO". If "YES", amgtar print more verbose debugging message and can leave temporary files in AMANDA_TMPDIR. INCLUDE AND EXCLUDE LISTS
This application supplies exclude lists via the GNU-tar --exclude-from option. This option accepts normal shell-style wildcard expressions, using * to match any number of characters and ? to match a single character. Character classes are represented with [..], which will match any of the characters in the brackets. Expressions can be "anchored" to the base directory of the DLE by prefixing them with "./". Without this prefix, they will match at any directory level. Expressions that begin or end with a "/" will not match anything: to completely exclude a directory, do not include the trailing slash. Example expressions: ./temp-files # exclude top-level directory entirely ./temp-files/ # BAD: does nothing /temp-files # BAD: does nothing ./temp-files/* # exclude directory contents; include directory temp-files # exclude anything named "temp-files" generated-* # exclude anything beginning with "generated-" *.iso # exclude ISO files proxy/local/cache # exclude "cache" in dir "local" in "proxy" Similarly, include expressions are supplied to GNU-tar's --files-from option. This option ordinarily does not accept any sort of wildcards, but amgtar "manually" applies glob pattern matching to include expressions with only one slash. The expressions must still begin with "./", so this effectively only allows expressions like "./[abc]*" or "./*.txt". EXAMPLE
define application-tool app_amgtar { plugin "amgtar" property "ATIME-PRESERVE" "NO" property "CHECK-DEVICE" "YES" property "GNUTAR-LISTDIR" "/path/to/listdir" property "GNUTAR-PATH" "/bin/tar" property "ONE-FILE-SYSTEM" "YES" property "TAR-BLOCKSIZE" "20" property "SPARSE" "YES" property "ACLS" "NO" property "SELINUX" "NO" property "XATTRS" "NO" property "EXIT-HANDLING" "1=GOOD 2=BAD" # change a default NORMAL regex to a STRANGE regex. property "STRANGE" ": socket ignored$" # add three new IGNORE regex property "IGNORE" ": Directory is new$" property append "IGNORE" ": Directory has been renamed" property append "IGNORE" "file changed as we read it$" } A dumptype using this application might look like: define dumptype amgtar_app_dtyp { global program "APPLICATION" application "app_amgtar" } Note that the program parameter must be set to "APPLCIATION" to use the application parameter. SEE ALSO
amanda(8), tar(1), amanda.conf(5), amanda-applications(7) The Amanda Wiki: : http://wiki.zmanda.com/ AUTHORS
Jean-Louis Martineau <martineau@zmanda.com> Zmanda, Inc. (http://www.zmanda.com) Dustin J. Mitchell <dustin@zmanda.com> Zmanda, Inc. (http://www.zmanda.com) Amanda 3.3.1 02/21/2012 AMGTAR(8)
All times are GMT -4. The time now is 04:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy