Sponsored Content
Top Forums Shell Programming and Scripting awk program for file comparison Post 302312273 by kbirde on Thursday 30th of April 2009 08:18:15 PM
Old 04-30-2009
Hi ldapswandog,

Thanks a lot for the info. I did try out the command 'join' as you mentioned but I got the following result for the newfile2.

1001 11
1004 100

instead of:

1001 11 22 33
1004 100 111 122

Am I doing something wrong?

Appreciate your guidance.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

AWK Program File Help

I have some .dat files that I cannot open and read the data. It is an awk program file, and my question would be to you all is there a way to convert this awk file to ascii text? Thanks (10 Replies)
Discussion started by: ryangfm
10 Replies

2. Shell Programming and Scripting

Looking for AWK Solution for column comparison in a single file

- I am looking for different kind of awk solution which I don't think is mentioned before in these forums. Number of rows in the file are fixed Their are two columns in file1.txt 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 I am looking for 3... (1 Reply)
Discussion started by: softwarekids23
1 Replies

3. Shell Programming and Scripting

Comparison and editing of files using awk.(And also a possible bug in awk for loop?)

I have two files which I would like to compare and then manipulate in a way. File1: pictures.txt 1.1 1.3 dance.txt 1.2 1.4 treehouse.txt 1.3 1.5 File2: pictures.txt 1.5 ref2313 1.4 ref2345 1.3 ref5432 1.2 ref4244 dance.txt 1.6 ref2342 1.5 ref2352 1.4 ref0695 1.3 ref5738 1.2... (1 Reply)
Discussion started by: linuxkid
1 Replies

4. Shell Programming and Scripting

awk comparison

Hello all, Probably a very simple question, I am stuck with a small part of a code: I am trying to do a comparison to get the maximum value of column 6 if columns 1, 4 and 5 of two or more rows match. Here is what I am doing: awk -F'\t' '{if ($6 > a)a=$6}END{for (i in a) print i"\t"a}' ... (4 Replies)
Discussion started by: jaysean
4 Replies

5. Shell Programming and Scripting

awk column comparison big file

Hi all, I would like to compare a column in one file to a column in another file and when there is a match it prints the first column and the corresponding second column. Example File1 ABA ABC ABE ABF File 2 ABA 123 ABB 124 ABD 125 ABC 126 So what I would like printed to a... (6 Replies)
Discussion started by: pcg
6 Replies

6. Shell Programming and Scripting

Urgent Help Required for File Comparison using Awk

Hello All, I am having a below requirement. File1 contains KEY|VIN|SEQUENCE|COST 101 | XXX111 | 1 | 234.22 234 | XXX111 | 2 | 134.32 444 | ABC234 | 1 | 100.22 555 | DFF611 | 1 | 734.82 FILE 2 Contains only VINs XXX111 DFF611 Now if the VIN from file 1 is present in... (8 Replies)
Discussion started by: dinesh1985
8 Replies

7. Shell Programming and Scripting

awk file comparison, x lines after matching as output

Hello, I couldn't find anything on the Forum that would help me to solve this problem. Could any body help me process below data using awk? I have got two files: file1: Worker1: Thomas Position: Manager Department: Sales Salary: $5,000 Worker2: Jason Position: ... (5 Replies)
Discussion started by: killerbee
5 Replies

8. Shell Programming and Scripting

File comparison using awk

my files are as follows fileA sepearated by tab /t 00 lieferungen 00 attractiop 01 done 02 forness 03 rasp 04 alwaysisng 04 funny 05 done1 fileB funnymou120112 funnymou234470 mou3raspnhdhv rddfgmoudone1438748 so all those record which are greater than 3 and which are not... (6 Replies)
Discussion started by: rajniman
6 Replies

9. Shell Programming and Scripting

File comparison using awk

Hi All, i have two files file1 ,file 2 file 1 col1|col2|col3|col4|col5|col6|col7|col8 11346925|0|2009-09-20|9999-12-31|100|0 11346925|0|2009-09-20|9999-12-31|120|0 12954311|0|2009-09-11|9999-12-31|100|0 12954311|0|2009-07-23|2999-12-31|120|0 12954312|0|2009-09-11|9999-12-31|100|0... (9 Replies)
Discussion started by: mohanalakshmi
9 Replies

10. Shell Programming and Scripting

File comparison and proccessing using awk

Hi Guys, I am having two requirement in one of my scripts. please help out to find a fast solution using AWK (since there is lot of data to be processed) 1) First snippet - File1 has two columns and file2 has three columns If any value of column 1 of file1 matches with column 1... (4 Replies)
Discussion started by: stormfield
4 Replies
pgmtoy4m(1)							MJPEG tools manual						       pgmtoy4m(1)

NAME
pgmtoy4m - Convert mpeg2dec pgm and pgmpipe output to YUV4MPEG2 SYNOPSIS
pgmtoy4m [options] DESCRIPTION
pgmtoy4m repacks the PGM output from mpeg2dec into YUV4MPEG2 4:2:0p. No actual changes to the data are made. The data is unpacked from the quasi-PGM format and placed in YUV4MPEG2 format with the specified sample aspect, frame rate and field order. Output must be either to a pipe or a file, leaving stdout as a terminal will elicit an error and the program will exit. OPTIONS
pgmtoy4m accepts the following options: -v num Set verbosity level. (default: 0) -h Print a usage summary and exit. -i t|b|p Set the interlacing mode. Top field first (t), bottom field first (b) or progressive/none (p). (default: t) -a sar Set the sample aspect ratio. (default: 10:11) -r frame rate Set the frame rate. (default: 30000:1001) EXAMPLES
mpeg2dec -s -o pgmpipe file.mpg | pgmtoy4m -a 10:11 -r 24000:1001 -i b | yuvplay mpeg2dec -s -o pgm file.mpg cat *.pgm | pgmtoy4m -r 30000:1001 -i t | yuvplay NOTES
This program is specifically designed to work with the output of mpeg2dec and is NOT a general PGM (NetPBM) tool! From the introduction in the source file: * Note: mpeg2dec uses a variation of the PGM format - they're really not * "Grey Maps" but rather a catenation of the 420P data (commonly called * "YUV"). The type is P5 ("raw") and the number of rows is really * the total of the Y', Cb and Cr heights. The Cb and Cr data is "joined" * together. After the Y' rows you have 1 row of Cb and 1 row of Cr per * "row" of PGM data. * NOTE: You MAY need to know the field order (top/bottom field first), * sample aspect ratio and frame rate because the PGM format makes * none of that information available! AUTHOR
This manpage was written by Steven Schultz (sms at 2bsd dot com). BUGS
Possible but none known at the present time. MJPEG Linux Square 16 December 2003 pgmtoy4m(1)
All times are GMT -4. The time now is 11:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy