RudiC has given you some good pointers to how you could solve your problem. This kind of problem is posted here frequently. What makes this problem stand out is the imperfections in the input files. b.csv contains spurious leading/trailing spaces in multiple fields, which will likely mess up the results.
So this can be fixed by getting rid of the space before storing and comparing, but also storing the imperfections, so they are not altered in the process:
Whereas with a proper input file, something like this would suffice:
These approaches can be further augmented by first testing if a field pair is present in the other file..
Dear all,
Being new to Unix i have a problem. I have 2 files:
File 1:
118,1,0,2,3,0,5,0.3,0,0.3,0.6,1
118,2,1,2,2,0,5,0.4,0,0.4,0.4,1
118,4,2,0,3,0,5,0.7,0,0.3,0.6,1
118,6,4,1,0,0,5,0.8,0,0.2,0,1
File 2:
118,1,BFGL-NGS-109695,3610326,0,18,1,0.556,0.389,0.056,0.25,0.8183... (2 Replies)
Hi may i ask how to accomplish this task:
I have 2 files which has multiple columns
first file
1 a
2 b
3 c
4 d
second file
14 a 9 ....
13 b 10....
12 c 11...
11 d 12...
I want to merge the second file to first file that will looks like this
... (2 Replies)
Hi,
I have tab limited file 1
and tab limited file 2
The output should contain common first column vales and corresponding 2nd column values; AND also unique first column value with corresponding 2nd column value of the file that contains it and 0 for the second file.
the output should... (10 Replies)
Hi!
I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt.
# cat 1.txt
aaa;a12
bbb;b13
ccc;c33
ddd;d55
eee;e11
# cat 2.txt
bbb;b55;34444;d55
aaa;a15;35666;a44
I try with this awk and I get succesfully first column from 1.txt:
# awk -F";"... (2 Replies)
Hello, I have two files that have this format:
file 1
86.82 0.00 86.82 43.61
86.84 0.00 86.84 43.61
86.86 0.00 86.86 43.61
86.88 0.00 86.88 43.61
file 2
86.82 0.22
86.84 0.22
86.86 0.22
86.88 0.22
I would like to merge these two files such that the final file looks like... (5 Replies)
Hello and Good day
I have a lot of files with same number of rows and columns.$2 and $3 are the same in all files .
I need to merge $2,$3,$6 from first file and $6 from another files.
File1:
$1 $2 $3 $4 $5 $6... (8 Replies)
I know I'm not the first one asking this but my code still does not work:
File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01";
gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01";
gi|4283| rRNAscan exon 197020 197058 . - . transcript_id... (5 Replies)
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT LINUX
ppmquantall
ppmquantall(1) General Commands Manual ppmquantall(1)NAME
ppmquantall - run ppmquant on a bunch of files all at once, so they share a common colormap
SYNOPSIS
ppmquantall [-ext extension] ncolors ppmfile ...
DESCRIPTION
Takes a bunch of portable pixmap as input. Chooses ncolors colors to best represent all of the images, maps the existing colors to the new
ones, and overwrites the input files with the new quantized versions.
If you don't want to overwrite your input files, use the -ext option. The output files are then named the same as the input files, plus a
period and the extension text you specify.
Verbose explanation: Let's say you've got a dozen pixmaps that you want to display on the screen all at the same time. Your screen can
only display 256 different colors, but the pixmaps have a total of a thousand or so different colors. For a single pixmap you solve this
problem with ppmquant; this script solves it for multiple pixmaps. All it does is concatenate them together into one big pixmap, run
ppmquant on that, and then split it up into little pixmaps again.
(Note that another way to solve this problem is to pre-select a set of colors and then use ppmquant's -map option to separately quantize
each pixmap to that set.)
SEE ALSO ppmquant(1), ppm(5)AUTHOR
Copyright (C) 1991 by Jef Poskanzer.
27 July 1990 ppmquantall(1)