Hi Ikki!
Thanks for your reply! I use awk bacause I'm more familiar with its sintax, i've just used sed a couple of time!
My files contain datas from genetic chips, and each file belongs to a person.
Each file has ~360000 lines.
You're right, I have more than one file shorter than the other..at the moment there are 95 shorter files. But they could increase, and yes, in shorter files it's possible that a line starting with cnvi0000004 is followed by a line starting with cnvi0000006 or cnvi0000008...it depends on how many records are missing for this person, but all input file are sorted by the first column.
As I said I've written an R-script that works, but it is extremely slow. In this script I compare a list of "complete" names with another and see if there are differences. Once i found elements that aren't in the short list, i add them in this list in order to have elements with same length. In this way I can merge all column and insert tabs instead of missing datas. I post the R-code:
Now I'm trying to port this in a shell script to have a faster response. My purpose was to avoid files preprocessing if i can, because of the large amount of data stored in each file, if possible.
I tried your command also, and it is running, the only problem is to add manually 1664 columns for the cut command, but I think I can work on It!
Hope I have been clear enough, and greatly appreciate your help!
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
I have n files (for ex:64 files) with one similar column. Is it possible to combine them all based on that column ?
file1
ax100 20 30 40
ax200 22 33 44
file2
ax100 10 20 40
ax200 12 13 44
file2
ax100 0 0 4
ax200 2 3 4 (9 Replies)
Hi Friends,
I have a file1 with 3400 records that are tab separated and I have a file2 with 6220 records. I want to merge both these files. I tried using join file1 and file2 after sorting. But, the records should be (3400*6220 = 21148000). Instead, I get only around 11133567. Is there anything... (13 Replies)
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
hi guys,
i need help
I need to join file2 to file1 when column 3 in my file1 and column 1 in my file2 in the same string
file1
AA|RR|ESKIM
RE|DD|RED
WE|WW|SUPSS
file2
ESKIM|ES
SUPSS|SS
Output
AA|RR|ESKIM|ES
RE|DD|RED|
WE|WW|SUPSS|SS (3 Replies)
Hello,
I have a file with 2 columns ( tableName , ColumnName) delimited by a Pipe like below . File is sorted by ColumnName.
Table1|Column1
Table2|Column1
Table5|Column1
Table3|Column2
Table2|Column2
Table4|Column3
Table2|Column3
Table2|Column4
Table5|Column4
Table2|Column5
From... (6 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 DEBIAN
xgfmerge
XGFMERGE(1) General Commands Manual XGFMERGE(1)NAME
xgfmerge - merges two Xgridfit program files
SYNOPSIS
xgfmerge [options] file-a file-b [...]
DESCRIPTION
Xgfmerge merges two or more Xgridfit program files, where file-a is a program generated automatically from an existing font using TTX and
ttx2xgf, and file-b and any other files in the list contain other programming for the font. Xgfmerge outputs the merged programming to
stdout. To capture the output in a file, use this syntax:
$xgfmerge -o merged-file.xgf file-a.xgf file-b.xgf
Note: To merge Xgridfit instructions with those already in a font, the best method is now to run Xgridfit in merge-mode (option -m).
OPTIONS -c Look for a <default type="compile-globals"/> element in each file after the first in the list. If value="no" then ignore all
<default>, <control-value>, <function>, <macro> and <pre-program> elements in the file.
-h Display a help message.
-n Merge <no-compile> elements from all files. <glyph> elements with duplicate "ps-name" attributes are ignored.
-o file
The file to write the output to. If this option is not used, output is written to stdout.
-p When a <pre-program> element in a file other than file-a is available, use it instead of the one from file-a. If this option is not
present, xgfmerge merges the programming in the <pre-program> of file-a with that in the <pre-program> of whichever file is being
merged at the moment. The result is unlikely to be good if a single run of xgfmerge merges the contents of more than two <pre-
program> elements.
-s Sort <glyph> elements in the output file into alphabetical order.
-v Verbose output: xgfmerge tells you what it is doing at each step.
-x Resolve XIncludes before merging all files in the list except for file-a. Any XIncludes from file-a.xgf are stripped out of the
files before this operation is performed. If XInclude is used to bring global elements (<control-value>, <function>, etc.) into
these files, it is probably a good idea to use the -c option as well.
FILES
/usr/share/xml/xgridfit/util/merge.xsl
An XSLT script that performs the merge.
/usr/share/xml/xgridfit/util/xinclude.xsl
An XSLT script that strips out unwanted XIncludes.
/usr/share/xml/xgridfit/util/sort-glyphs.xsl
An XSLT script that sorts glyph elements in a file.
/usr/share/xml/xgridfit/utils/add-blanks.sed
Does some formatting of the output.
SEE ALSO xgridfit(1), ttx(1), ttx2xgf(1).
AUTHOR
Xgfmerge was written by Peter Baker <psb6m@virginia.edu>.
This manual page was written by Peter Baker
2009-12-18 XGFMERGE(1)