Match a line in File 1 with Column in File 2 and print whole line in file 2 when matched Post: 302528551

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk+Grep Input file needs to match a column and print the entire line

I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this). For example, i have a input file1.txt: cat inputfile1.txt 218299910417 1172051195 1172070231 1172073514 1183135117 1183135118 1183135119 1281440202 ...

2. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ...

3. Shell Programming and Scripting

read file line by line print column wise

I have a .csv file which is seperated with (;) inputfile --------- ZZZZ;AAAA;BBB;CCCC;DDD;EEE; YYYY;BBBB;CCC;DDDD;EEE;FFF; ... ... reading file line by line till end of file. while reading each line output format should be . i need to print only specific columns let say 5th...

4. Shell Programming and Scripting

Match multiple patterns in a file and then print their respective next line

Dear all, I need to search multiple patterns and then I need to print their respective next lines. For an example, in the below table, I will look for 3 different patterns : 1) # ATC_Codes: 2) # Generic_Name: 3) # Drug_Target_1_Gene_Name: #BEGIN_DRUGCARD DB00001 # AHFS_Codes:...

5. Shell Programming and Scripting

Regex: print matched line and exact pattern match

Hi experts, I have a file with regexes which is used for automatic searches on several files (40+ GB). To do some postprocessing with the grep result I need the matching line as well as the match itself. I know that the latter could be achieved with grep's -o option. But I'm not aware of a...

6. Shell Programming and Scripting

Input file needs to match a column and print the entire line

I have a file with class c IP addresses that I need to match to a column and print the matching lines of another file. I started playing with grep -if file01.out file02.out but I am stuck as to how to match it to a column and print the matching lines; cat file01.out 10.150.140...

7. UNIX for Beginners Questions & Answers

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

I have two files and desire to use the strings from $1 of file 1 (file1.txt) as search criteria to find matches in $2 of file 2 (file2.txt). If matches are found I want to output the entire line of file 2 (file2.txt) followed by fields $2-$11 of file 1 (file1.txt). I can find the matches, I cannot...

8. Shell Programming and Scripting

Print next line beside preceding line on column match

Hi, I have some data like below: John 254 Chris 254 Matt 123 Abe 123 Raj 487 Moh 487 How can i print it using awk to have: 254 John,Chris 123 Matt,Abe 487 Raj,Moh Thanks.

9. 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. ...

10. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def....

LEARN ABOUT HPUX

quot

quot(1M)																  quot(1M)

NAME

       quot - summarize file system ownership

SYNOPSIS

       FStype] FSspecific-options] filesystem ...

       FStype]

DESCRIPTION

       The  command  displays  the number of 1024-byte blocks in the named filesystem that are currently owned by each user.  filesystem is either
       the name of the directory on which the file system is mounted or the name of the device containing the file system.

   Options
       recognizes the following options:

	      Specify the file system type on which to operate (see
			     fstyp(1M) and fs_wrapper(5)).  If this option is not included on the command line, the file system type is determined
			     from  the	file by matching filesystem with an entry in that file.  If there is no entry in then the file system type
			     is determined from the file

	      Echo the completed command line, but perform no other
			     action.  The command line is generated by incorporating the user-specified options and other information derived from
			     This option allows the user to verify the command line.

	      Specify any options specific to the file system.

	      Generate a report for all mounted file systems.

	      Report size rather than user statistics.
			     Generates histogram statistics in 3-column format:

			     Column 1:	 File size in blocks.  Sizes are listed in ascending order up to 499 blocks per file.  Files occupying 499
					 or more blocks are counted together on a single line as 499-block files (but column 3 is based on  actual
					 number of blocks occupied).

			     Column 2:	 Number of files of size indicated in column 1.

			     Column 3:	 Cumulative total blocks occupied by files counted in current plus all preceding lines.

			     Use of this option overrides the and options.

	      Display number of files and space occupied by each user.

	      Calculate the number of blocks in the file based on file size
			     rather than actual blocks allocated.  This option does not account for sparse files (files with holes in them).

	      Accept data from the
			     command (see ncheck(1M)) as input.  Run the pipeline:

			     to produce a list of all files and their owners.

	      Display three columns containing the number of blocks
			     not accessed in the last 30, 60, and 90 days.

AUTHOR

       was developed by the University of California, Berkeley, Sun Microsystems, Inc., and HP.

FILES

       Specifies the default file system type
       Static information about the file systems
       Mounted file system table
       Password file (contains user names)

SEE ALSO

       quot_hfs(1M), quot_vxfs(1M), du(1), find(1), ls(1), fstyp(1M), mount(1M), ncheck(1M), repquota(1M), fs_wrapper(5), quota(5).

																	  quot(1M)