Assume we have two files - FileA and FileB. Content of files are as shown below :
FileA:
FileB:
Based on first column from FileB, compare , with FileA and extract the data from FileA and store in new file, the expected output should be:
FileA will have more than 1 million lines [all unique] and FileB will be 50k [all unique lines], so, based on first column from FileB, extract from FileA. please advice the awk.
Moderator's Comments:
Please use CODE tags for code, files, input & output/errors
It makes it much easier to read as fixed width text and preserves multiple spaces
Last edited by rbatte1; 09-11-2014 at 10:46 AM..
Reason: Added CODE tags and made file names concistent within the post.
Compare two files, search for data from position 1-6 if both matches then i need to extract those records only from file A
cat File A
A37985LUNGIUF7845049530113
F41604CHACAMA286000004371
cat File B
C26344
F41604
o/p
F41604CHACAMA286000004371 (8 Replies)
I have 2 files. The first file contains user names in one column. The second, and considerably longer, file contains user names in the first column and corresponding full names in the second column. Currently these are in the .xls format. I'd like to be able to compare file1 with file2 and extract... (2 Replies)
I am not an expert in awk, SED, etc... but I really hope there is a way to do this, because I don't want to have to right a program. I am using C shell.
FILE 1 FILE 2
H0000000 H0000000
MA1 MA1
CA1DDDDDD CA1AAAAAA
MA2 ... (2 Replies)
I have this code
awk 'NR==FNR{a=$1;next} a' file1 file2
which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
I have two files : Alpha and Beta.
The files are as follows (without arrow marks.)
Alpha:
A 1
D 90
G 11
B 24
C 15
Beta:
B 24
C 0 <--
G 11
D 20 <--
A 4 <--
E 777 <--
Expected output of the script :
Alpha: (2 Replies)
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)
Hello,
I have two files which look like this
File 1
Name test1 status P
Gene1 0.00236753 1 1.00E-01
Gene2 0.134187 2 2.00E-01
Gene3 0.000608716 2 3.00E-01
Gene4 0.0016234 1 4.00E-01
Gene5 0.000665868 2 5.00E-01and file 2
No Pos ... (2 Replies)
ppmtosixel(1) General Commands Manual ppmtosixel(1)NAME
ppmtosixel - convert a portable pixmap into DEC sixel format
SYNOPSIS
ppmtosixel [-raw] [-margin] [ppmfile]
DESCRIPTION
Reads a portable pixmap as input. Produces sixel commands (SIX) as output. The output is formatted for color printing, e.g. for a DEC
LJ250 color inkjet printer.
If RGB values from the PPM file do not have maxval=100, the RGB values are rescaled. A printer control header and a color assignment table
begin the SIX file. Image data is written in a compressed format by default. A printer control footer ends the image file.
OPTIONS -raw If specified, each pixel will be explicitly described in the image file. If -raw is not specified, output will default to com-
pressed format in which identical adjacent pixels are replaced by "repeat pixel" commands. A raw file is often an order of magni-
tude larger than a compressed file and prints much slower.
-margin
If -margin is not specified, the image will be start at the left margin (of the window, paper, or whatever). If -margin is speci-
fied, a 1.5 inch left margin will offset the image.
PRINTING
Generally, sixel files must reach the printer unfiltered. Use the lpr -x option or cat filename > /dev/tty0?.
BUGS
Upon rescaling, truncation of the least significant bits of RGB values may result in poor color conversion. If the original PPM maxval was
greater than 100, rescaling also reduces the image depth. While the actual RGB values from the ppm file are more or less retained, the
color palette of the LJ250 may not match the colors on your screen. This seems to be a printer limitation.
SEE ALSO ppm(5)AUTHOR
Copyright (C) 1991 by Rick Vinci.
26 April 1991 ppmtosixel(1)