Compare two columns of one file to two columns in another file

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Awk: compare values in two columns of the same file

I'm trying to learn awk, but I've hit a roadblock with this problem. I have a hierarchy stored in a file with 3 columns: id name parentID 4 D 2 2 B 1 3 C 1 1 A 5 I need to check if there are any values in column 3 that are not represented anywhere in column 1. I've tried this: awk '{arr;}...

2. Shell Programming and Scripting

Compare 2 columns from the same file and print a value depending on the result

Hello Unix gurus, I have a file with this format (example values): label1 1 0 label2 1 0 label3 0.4 0.6 label4 0.5 0.5 label5 0.1 0.9 label6 0.9 0.1 in which: column 1 is a row label column 2 and 3 are values I would like to do a simple operation on this table and get the...

3. Shell Programming and Scripting

Compare columns in a single file

i have the following files (all separated by tabs): file 1.txt 1 yes 2 no 3 yes 4 yes file 2.txt a no b no c yes d no i combine the above files in file 3 which looks like file 3.txt 1 yes a no 2 no b no 3 yes c yes 4 yes d no now, i need to compare the values between column 2...

4. Shell Programming and Scripting

Compare 2 csv files by columns, then extract certain columns of matcing rows

Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns. I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'...

5. Shell Programming and Scripting

Compare two date columns in same file

Hi All, Need to compare two date columns from the filname FinalDate.txt. My data's are like below D_OT_START D_EXP_STR Amount 1/3/2012 1/3/2012 5000 6/21/2011 6/25/2011 6000 2/28/2011 2/28/2011 7000 7/16/2010 8/16/2010 8000 7/14/2010 10/26/2010 9000 ...

6. Shell Programming and Scripting

Compare Multiple Columns in one file

Hello guys, I am quite new to Shell Scripting and I need help for this I have a CSV file like this: Requisition,Order,RequisitionLineNumber,OrderLineNumber REQ1,Order1,1,1 REQ1,Order1,1,3 REQ2,Order2,1,5 Basically what I want to do is compare the first 3 fields If all 3 fields are the same...

7. Shell Programming and Scripting

script to compare two columns in a file

Dear everyone, I need any sort of shell script or perl script would do the following. I have a txt file as follows: ;Stretnumber Resident Resdient (not in file) 16 John Mary 16 Mary Parker 16 Nancy Smith 16 Mary John 18 Trey ...

8. UNIX for Dummies Questions & Answers

To compare first two columns in an excel file

Hi All, i have a excel sheet with two columns as below. column1 column2 100 100 200 300 300 400 400 400 500 600 i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these...

9. Shell Programming and Scripting

Compare selected columns from a file and print difference

I have learned file comparison from my previous post here. Then, it is comparing the whole line. Now, i have a new problem. I have two files with 3 columns separated with a "|". What i want to do is to compare the second and third column of file 1, and the second and third column of file 2. And...

10. Shell Programming and Scripting

compare file columns

I need help in file comparision. I have two files in below format: FILE_A: ------- COL1 COL2 COL3 COL4 COL5 FILE_B: ------- COL1A COL1B COL1C COL1D COL1E i want to compare for a for each row in FILE_A and FILE_B COL1 of FILE_A with COL1B of FILE_B COL3 of FILE_A with COL1E of...

LEARN ABOUT OSF1

fmt

fmt(1)							      General Commands Manual							    fmt(1)

NAME

       fmt - Formats mail messages prior to sending

SYNOPSIS

       fmt [-width] file...

DESCRIPTION

       The  fmt command reads the input file or files, or standard input if no files are specified, and writes to standard output a version of the
       input with lines of a length as close as possible to width columns. (Because fmt is internationalized software, the number of display  col-
       umns is not necessarily equivalent to the number of bytes.)

       The fmt command both joins and splits lines to achieve the desired width, but words are never joined or split; spaces are always preserved,
       and lines are split at spaces only.  In effect, fmt ignores newline characters in the input and wraps words to make lines a close as possi-
       ble  to	width columns, resulting in individual lines of varying length but a consistent (new) text width overall.  Because blank lines are
       always preserved, fmt does not merge paragraphs separated by blank lines.

       If you specify more than one file, the files are concatenated as input to fmt.  If you do not specify -width, the default line length is 72
       columns.  Spacing at the beginning of input lines is always preserved in the output.

       The  fmt  command  is generally used to format mail messages to improve their appearance before they are sent.  It may also be useful, how-
       ever, for other simple formatting tasks.  For example, when you are using vi, you can use the command :%!fmt -60 to reformat your  text	so
       that all lines are approximately 60 columns long.

NOTES

       The  fmt command is a fast, simple formatting program.  Standard text editing programs are more appropriate than fmt for complex formatting
       operations.  Do not use the fmt command if the message contains embedded messages or preformatted information from other files.	This  com-
       mand formats the heading information in embedded messages and may change the format of preformatted information.

EXAMPLES

       file1 contains these lines:

	      Australia is an island-continent, home to many very interesting plants and animals.

	      To reformat this text to a narrower width, enter: fmt -30 file1

	      This  results in the following, displayed on your screen: Australia is an island-continent, home to many very interesting plants and
	      animals.

	      To make file1 wider, enter: fmt -60 file1

	      This results in: Australia is an island-continent, home to many very interesting plants and animals.  To format a message  you  have
	      created with the mailx editor, at the left margin enter: ~|fmt

	      After you enter the command, your message is formatted, in this case to the default line length of 72 columns, and the word continue
	      is displayed to indicate that you can enter more information or send your message.

SEE ALSO

       Commands:  mail(1), mailx(1), vi(1)

																	    fmt(1)

UNIX for Beginners Questions & Answers