Get values from different columns from file2 when match values of file1 Post: 302559477

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

match value from file1 in file2

Hi, i've two files (file1, file2) i want to take value (in column1) and search in file2 if the they match print the value from file2. this is what i have so far. awk 'FILENAME=="file1"{ arr=$1 } FILENAME=="file2" {print $0} ' file1 file2

2. Shell Programming and Scripting

Search values between ranges in File1 within File2

Hi people, I have 2 files, one with a list of non consecutive ranges (File1.txt), where each range begins with the value in column 1 and finishes with the value in column 2 in the same line, as can be seen above. 215312581156279 215312581166279 215312582342558 215312582357758...

3. Shell Programming and Scripting

AWK: read values from file1; search for values in file2

I have read another post about this issue and am wondering how to adapt it to my own, much simpler, issue. I have a file of user IDs like so: 333333 321321 546465 ...etc I need to take each number and use it to print records wherein the 5th field matches the user ID pulled from the...

4. Shell Programming and Scripting

Remove lines in file1 with values from file2

Hello, I have two data files: file1 12345 aa bbb cccc 98765 qq www uuuu 76543 pp rrr bbbbb 34567 nn ccc sssss 87654 qq ppp rrrrr file2 98765 34567 I need to remove the lines from file1 if the first field contains a value that appears in file2: output 12345 aa bbb cccc 76543 pp...

5. Shell Programming and Scripting

Match one column of file1 with that of file2

Hi, I have file1 like this aaa ggg ddd vvv eeeand file2 aaa 2 aaa 443 xxx 76 aaa 34 ggg 33 wee 99 ggg 33 ddd 1 ddd 10 ddd 98 sds 23

6. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use...

7. Shell Programming and Scripting

awk to search field2 in file2 using range of fields file1 and using match to another field in file1

I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited. I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range...

8. Shell Programming and Scripting

Mapping the values of ids of two columns of file1 from file2

I have of two space separated files: ==> File1 <== PT|np_496075.1 st|K92748.1 st|K89648.1 PT|np_001300561.1 PT|np_497284.1 st|K90752.1 st|K90279.1 PT|np_740775.1 PT|np_497749.1 st|K90752.1 st|K92038.1 PT|np_490856.1 PT|np_497284.1 st|K90752.1 st|K88095.1 PT|np_494764.1 ==> File 2 <==...

9. Shell Programming and Scripting

awk to look up values in File 2 from File 1, & printingNth field of File1 based value of File2 $2

I have two files which are the output of a multiple choice vocab test (60 separate questions) from 104 people (there are some missing responses) and the question list. I have the item list in one file (File1) Item,Stimulus,Choice1,Choice2,Choice3,Choice4,Correct...

10. Shell Programming and Scripting

awk to match file1 and extract specific tag values

File2 is tab-delimeted and I am trying to use $2 in file1 (space delimeted) as a search term in file2. If it is found then the AF= in and the FDP= values from file2 are extracted and printed next to the file1 line. I commented the awk before I added the lines in bold the current output resulted. I...

LEARN ABOUT HPUX

diff3

diff3(1)						      General Commands Manual							  diff3(1)

NAME

       diff3 - 3-way differential file comparison

SYNOPSIS

       file1 file2 file3

DESCRIPTION

       compares three versions of a file, and prints disagreeing ranges of text flagged with these codes:

	      all three files differ
	      file1	is different
	      file2	is different
	      file3	is different

       The type of change required to convert a given range of a given file to some other is indicated in one of these ways:

	      Text is to be appended after line number
			     n1 in file f, where f = or

	      Text is to be changed in the range line
			     n1 through line n2.  If n1 = n2, the range can be abbreviated to n1.

       The  original  contents of the range follows immediately after a indication.  When the contents of two files are identical, the contents of
       the lower-numbered file is suppressed.

	      Produces a script for the
			editor that can be used to incorporate into file1 all changes between file2 and file3 (see ed(1)); i.e., the changes  that
			normally would be flagged and

	      Produces a script to incorporate only changes flagged

	      Produces a script to incorporate only changes flagged

	      Produces a script that will incorporate all
			changes  between  file2  and  file3,  but treat overlapping changes (that is, changes that would be flagged with in normal
			listing) differently. The overlapping lines in both files will be inserted by the edit script bracketed by and lines.

	      Produces a script that will incorporate only changes flagged
			, but treat these changes in the manner of option.

       The following command applies the resulting script to file1.

EXTERNAL INFLUENCES

   International Code Set Support
       Single- and multi-byte character code sets are supported.

WARNINGS

       Text lines that consist of a single period defeat

       Files longer than 64K bytes do not work.

FILES

SEE ALSO

       diff(1).

																	  diff3(1)