Sponsored Content
Top Forums Shell Programming and Scripting Finding multiple column values and match in a fixed length file Post 302438584 by dr.house on Tuesday 20th of July 2010 06:27:36 AM
Old 07-20-2010
Code:
awk -F '|' 'NFS=OFS="|" {if ($3=="P" && $6=="UE" && $8=="85") {print $0}}' data.file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing column of variable length anf fixed width file

Hi, I have two input files. File1: ID Name Place 1-234~name1~Newyork 1-34~name2~Boston 1-2345~name3~Hungary File1 is a variable length file where each column is seperated by delimitter "~". File2: ID Country 1-34<<11 SPACES>>USA<<7 spaces>> 1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies

2. Shell Programming and Scripting

print a file with one column having fixed character length

Hi guys, I have tried to find a solution for this problem but couln't. If anyone of you have an Idea do help me. INPUT_FILE with three columns shown to be separated by - sign A5BNK723NVI - 1 - 294 A7QZM0VIT - 251 - 537 A7NU3411V - 245 - 527 I want an output file in which First column... (2 Replies)
Discussion started by: smriti_shridhar
2 Replies

3. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

4. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

5. UNIX for Dummies Questions & Answers

Fixed length file extracting values in columns

How do I extract values in a few columns in a row of a fixed length file? If there are 8 columns and I need to extract values of 2nd,4th and 6 th columns, how do i do that? I used cut command, this I used only for one column. How do I do it more than one column? The below command will give... (1 Reply)
Discussion started by: princetd001
1 Replies

6. UNIX for Dummies Questions & Answers

Count on grep for more than two values in a row of fixed length file

I want to get count on number of records in a few folders by running grep command for more than two columns in a row of fixed length file. suppose if i have a fixed length file has 5 columns and I want to see the record counts for country =can and province = bc and time stamp <= 12 feb 2013... (14 Replies)
Discussion started by: princetd001
14 Replies

7. Shell Programming and Scripting

awk Print New Column For Every Two Lines and Match On Multiple Column Values to print another column

Hi, My input files is like this axis1 0 1 10 axis2 0 1 5 axis1 1 2 -4 axis2 2 3 -3 axis1 3 4 5 axis2 3 4 -1 axis1 4 5 -6 axis2 4 5 1 Now, these are my following tasks 1. Print a first column for every two rows that has the same value followed by a string. 2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies

8. Shell Programming and Scripting

Match value in column and append file with new values

Hi, I need help to match two files based on two columns. file_1 ID AA An Ca Ele Pro Su Ot Tra g13950 No No Yes No Yes Yes Yes Yes g05760 Yes No No No No Yes Yes Yes g12640 No No No No No No No No k17720 No Yes No No No No No Yes g05640 Yes Yes Yes No No Yes Yes Yes file_2 ... (8 Replies)
Discussion started by: redse171
8 Replies

9. Shell Programming and Scripting

Break one long string into multiple fixed length lines

This is actually a KSH under Unix System Services (Z/OS), but hoping I can get a standard AIX/KSH solution to work... I have a very large, single line file in Windows, that we download via FTP, with the "SITE WRAP" option, into a Z/OS file with an LRECL of 200. This essentially breaks the single... (4 Replies)
Discussion started by: bubbawuzhere
4 Replies

10. Shell Programming and Scripting

UNIX command -Filter rows in fixed width file based on column values

Hi All, I am trying to select the rows in a fixed width file based on values in the columns. I want to select only the rows if column position 3-4 has the value AB I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that... (2 Replies)
Discussion started by: ashok.k
2 Replies
nfsstat(8)						      System Manager's Manual							nfsstat(8)

NAME
nfsstat - list NFS statistics SYNOPSIS
nfsstat [OPTION]... DESCRIPTION
The nfsstat displays statistics kept about NFS client and server activity. OPTIONS
-s, --server Print only server-side statistics. The default is to print both server and client statistics. -c, --client Print only client-side statistics. -n, --nfs Print only NFS statistics. The default is to print both NFS and RPC information. -2 Print only NFS v2 statistics. The default is to only print information about the versions of NFS that have non-zero counts. -3 Print only NFS v3 statistics. The default is to only print information about the versions of NFS that have non-zero counts. -4 Print only NFS v4 statistics. The default is to only print information about the versions of NFS that have non-zero counts. -m, --mounts Print information about each of the mounted NFS file systems. If this option is used, all other options are ignored. -r, --rpc Print only RPC statistics. -o facility Display statistics for the specified facility, which must be one of: nfs NFS protocol information, split up by RPC call. rpc General RPC information. net Network layer statistics, such as the number of received packets, number of TCP connections, etc. fh Usage information on the server's file handle cache, including the total number of lookups, and the number of hits and misses. rc Usage information on the server's request reply cache, including the total number of lookups, and the number of hits and misses. all Display all of the above facilities. -v, --verbose This is equivalent to -o all. -l, --list Print information in list form. -S, --since file Instead of printing current statistics, nfsstat imports statistics from file and displays the difference between those and the cur- rent statistics. Valid input files may be in the form of /proc/net/rpc/nfs (raw client stats), /proc/net/rpc/nfsd (raw server stats), or saved output from nfsstat itself (client and/or server stats). Any statistics missing from a saved nfsstat output file are treated as zeroes. -Z[interval], --sleep=[interval] Instead of printing current statistics and immediately exiting, nfsstat takes a snapshot of the current statistics and pauses until it receives SIGINT (typically from Ctrl-C), at which point it takes another snapshot and displays the difference between the two. If interval is specified, nfsstat will print the number of NFS calls made since the previous report. Stats will be printed repeat- edly every interval seconds. EXAMPLES
nfsstat -o all -234 Show all information about all versions of NFS. nfsstat --verbose -234 Same as above. nfsstat -o all Show all information about active versions of NFS. nfsstat --nfs --server -3 Show statistics for NFS version 3 server. nfsstat -m Show information about mounted NFS filesystems. DISPLAY
The Flags output from the -m option is the same as the flags give to the mount command. FILES
/proc/net/rpc/nfsd procfs-based interface to kernel NFS server statistics. /proc/net/rpc/nfs procfs-based interface to kernel NFS client statistics. /proc/mounts procfs-based interface to the mounted filesystems. SEE ALSO
rpc.nfsd(8). nfs(5). BUGS
The default output has been changed. To get the old default output you must run nfsstat --auto -2. The function of the -v and -a options have changed. The -a option is now reserved for future use. The -v does what the -a option used to do, and the new -[234] options replace the -v option. The Display section should be more complete. Further bugs can be found or reported at http://nfs.sf.net/. AUTHOR
Olaf Kirch, <okir@suse.de> 7 Aug 2007 nfsstat(8)
All times are GMT -4. The time now is 06:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy