Sponsored Content
Top Forums Shell Programming and Scripting Match strings in two files and compare columns of both Post 302347643 by GarciasMuffin on Wednesday 26th of August 2009 07:24:21 AM
Old 08-26-2009
Worked 100% perfectly.

You're an absolute star mate Smilie

Not sure how the bits award thing works, but did it (hopefully correctly).

Last edited by GarciasMuffin; 08-26-2009 at 08:32 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to compare 2 files & get only few columns based on a condition related to both files?

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338... (6 Replies)
Discussion started by: reva
6 Replies

2. Shell Programming and Scripting

Compare one files with strings from another + remove lines

Have two files and want to compare the content of file1 with file2. When matched remove the line. awk 'NR==FNR {b; next} !(b in $0)' file1 file2file1 1. if match 2. removefile2 1. this line has to be removed if match 2. this line has a match, remove 3. this line has no match, no removingThe... (3 Replies)
Discussion started by: sdf
3 Replies

3. Shell Programming and Scripting

Match list of strings in File A and compare with File B, C and write to a output file in CSV format

Hi Friends, I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving... File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Discussion started by: asnandhakumar
6 Replies

4. Shell Programming and Scripting

Match columns several files

Hey fellas! Here come my problem. I appreciate if you have a look at it. I have several files with following structure: file_1:1 21 4 45 file_2:2 31 4 153 6 341 and so on... and I have a 'reference' file look like this: File_ref:A 1 B 2 C 3 (5 Replies)
Discussion started by: @man
5 Replies

5. Shell Programming and Scripting

Match the columns between 2 files

I have two files I want to match ids in the 5th column of the file 1 with the first column of the file 2 and get the description for the matched ids as shown in the output sno nm no nm2 ID 1 cc 574372 yyyi |6810|51234| 2 bb 119721 nmjk |6810|51234|51179| ... (4 Replies)
Discussion started by: raj_k
4 Replies

6. Shell Programming and Scripting

Match strings in 2 different files

Hi, i am trying to match strings from 2 different files based on position like below:- file1 (tab delimited) f07270 lololol fff u12730 gggddd dddkkrr mmm file2 (not tab delimited) %f07270 APSLH bl%alalalalallaadsdsfdfdfdgsgfss %g13450 GDIDFLRIP%ILITEAPPRKgsfgsgsf %d08880... (11 Replies)
Discussion started by: redse171
11 Replies

7. 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 Replies)
Discussion started by: bkane3
5 Replies

8. UNIX for Dummies Questions & Answers

Match the columns between two files and output

Hi Help, I have two files namely a.txt and b.txt a.txt looks like a.txt 1 2 2 1 3 3 2 4 4 4 5 6 6 7 7 b.txt looks like, b.txt 1 2 1 1 3 2 2 4 3 3 4 4 4 5 5 (2 Replies)
Discussion started by: Indra2011
2 Replies

9. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am... (4 Replies)
Discussion started by: axis88
4 Replies

10. UNIX for Beginners Questions & Answers

Match patterns between two files and extract certain range of strings

Hi, I need help to match patterns from between two different files and extract region of strings. inputfile1.fa >l-WR24-1:1 GCCGGCGTCGCGGTTGCTCGCGCTCTGGGCGCTGGCGGCTGTGGCTCTACCCGGCTCCGG GGCGGAGGGCGACGGCGGGTGGTGAGCGGCCCGGGAGGGGCCGGGCGGTGGGGTCACGTG... (4 Replies)
Discussion started by: bunny_merah19
4 Replies
PFILT(1)						      General Commands Manual							  PFILT(1)

NAME
pfilt - filter a RADIANCE picture SYNOPSIS
pfilt [ options ] [ file ] DESCRIPTION
Pfilt performs anti-aliasing and scaling on a RADIANCE picture. The program makes two passes on the picture file in order to set the expo- sure to the correct average value. If no file is given, the standard input is read. -x res Set the output x resolution to res. This must be less than or equal to the x dimension of the target device. If res is given as a slash followed by a real number, the input resolution is divided by this number to get the output resolution. By default, the output resolution is the same as the input. -y res Set the output y resolution to res, similar to the specification of the x resolution above. -p rat Set the pixel aspect ratio to rat. Either the x or the y resolution will be reduced so that the pixels have this ratio for the specified picture. If rat is zero, then the x and y resolutions will adhere to the given maxima. Zero is the default. -c Pixel aspect ratio is being corrected, so do not write PIXASPECT variable to output file. -e exp Adjust the exposure. If exp is preceded by a '+' or '-', the exposure is interpreted in f-stops (ie. the power of two). Other- wise, exp is interpreted as a straight multiplier. The individual primaries can be changed using -er, -eg and -eb. Multiple exposure options have a cumulative effect. -t lamp Color-balance the image as if it were illuminated by fixtures of the given type. The specification must match a pattern listed in the lamp lookup table (see the -f option below). -f lampdat Use the specified lamp lookup table rather than the default (lamp.tab). -1 Use only one pass on the file. This allows the exposure to be controlled absolutely, without any averaging. Note that a single pass is much quicker and should be used whenever the desired exposure is known and star patterns are not required. -2 Use two passes on the input. This is the default. -b Use box filtering (default). Box filtering averages the input pixels corresponding to each separate output pixel. -r rad Use Gaussian filtering with a radius of rad relative to the output pixel size. This option with a radius around 0.6 and a reduc- tion in image width and height of 2 or 3 produces the highest quality pictures. A radius greater than 0.7 results in a defocused picture. -m frac Limit the influence of any given input pixel to frac of any given output pixel. This option may be used to mitigate the problems associated with inadequate image sampling, at the expense of a slightly blurred image. The fraction given should not be less than the output picture dimensions over the input picture dimensions (x_o*y_o/x_i/y_i), or blurring will occur over the entire image. This option implies the -r option for Gaussian filtering, which defaults to a radius of 0.6. -h lvl Set intensity considered ``hot'' to lvl. This is the level above which areas of the image will begin to exhibit star diffraction patterns (see below). The default is 100 watts/sr/m2. -n N Set the number of points on star patterns to N. A value of zero turns star patterns off. The default is 0. (Note that two passes are required for star patterns.) -s val Set the spread for star patterns to val. This is the value a star pattern will have at the edge of the image. The default is .0001. -a Average hot spots as well. By default, the areas of the picture above the hot level are not used in setting the exposure. ENVIRONMENT
RAYPATH directories to search for lamp lookup table FILES
/tmp/rt?????? AUTHOR
Greg Ward SEE ALSO
getinfo(1), ies2rad(1), pcompos(1), pflip(1), pinterp(1), pvalue(1), protate(1), rad(1), rpict(1), ximage(1) RADIANCE
11/8/96 PFILT(1)
All times are GMT -4. The time now is 01:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy