02-12-2008
how to merge these two files?
I have two files, each of them has 12 lines, fileA has 3 columns, fileB has 1 column, like the following
FileA
a 1
b 2
c 3
..blabla
FileB
A
B
C
..blabla
Now I am trying to put the content of fileB as column 3 of fileA, e.g.
a 1 A
b 2 B
c 3 C
...blahblah
I figure there should be a simple unix command can be used to do this, am I right?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello guys,
I gotta question, i have a lot of log files (simple text) and i need to merge them in group of 10 files, one next to the other, that have sense?
For example, i have the files:
File1
File2
File3
File4
.
.
File100
I need to merge the contents of each file into a new file... (3 Replies)
Discussion started by: lestat_ecuador
3 Replies
2. Shell Programming and Scripting
Hi,
i have the files f1 and f2 like:
files f1:
c1 a1
c2 a2
c3 a3
file f2:
c1 b1
c2 b2
c3 b3
i want merge the f1 and f2 file to f3 file like:
c1 a1 b1
c2 a2 b3
c3 a3 b3........
....
.
.
please help me onthis..... (5 Replies)
Discussion started by: koti_rama
5 Replies
3. Shell Programming and Scripting
hi,
i am facing a problem in merging two files using awk,
the problem is as stated below,
file1:
A|B|C|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|DD|EE|FF|GG|HH|II|1
....
....
....
file2 :
1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies
4. Shell Programming and Scripting
Given are File A and File B
File A has for example 5 lines:
AAA
BBB
CCC
DDD
EEE
File B has 3 lines:
111
222
333
How can i merge A and B into:
111
222
333
AAA (first line from A)
then a new file: (4 Replies)
Discussion started by: Y-T
4 Replies
5. Shell Programming and Scripting
Hi ,
This might be the stupidest question I am asking, but I am struck with this problem. I am trying to merge 2 files, file1 has header and file2 has contents. while I merge them , it merges from the 1st line of file1.
for ex: file1
col1|col2|col3|
file2
123|234|456|... (2 Replies)
Discussion started by: rashmisb
2 Replies
6. Shell Programming and Scripting
Hi all!
How could I merge all the text files (in format xml) of a single folder, after having deleted from each of them all the text from its beginning up to a specific string: "<body>" ?
Thanks a lot!
mjomba (4 Replies)
Discussion started by: mjomba
4 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I would like to know how can I merge files based on their coordinates, but mantaining the score of each file in the output file like:
Note: 1st column is for chromosome, 2nd for start, 3rd for end of segment, 4th for score
file1:
1 200 300 20
1 400 500 30
file2:
1 200 350 30
1... (1 Reply)
Discussion started by: fadista
1 Replies
8. Shell Programming and Scripting
Hi,
My requirement is,there is a directory location like:
:camp/current/
In this location there can be different flat files that are generated in a single day with same header and the data will be different, differentiated by timestamp, so i need to verify how many files are generated... (10 Replies)
Discussion started by: srikanth_sagi
10 Replies
9. Shell Programming and Scripting
Dear Gents,
Please I need your help... I need small script :) to do the following.
I have a thousand of files in a folder produced daily.
I need first to merge all files called. txt (0009.txt, 0010.txt, 0011.txt) and and to output a resume of all information on 2 separate files in csv... (14 Replies)
Discussion started by: jiam912
14 Replies
10. Shell Programming and Scripting
Dear Frens,
I have two files and need to merge into one file. Like
File_1:
Field1 Field2
1 4
File_2:
Field1 Field2
3 5
I need one single output as
File_1:
Field1 Field2
1 4
3 5
This means taking header from either file. (8 Replies)
Discussion started by: manisha_singh
8 Replies
LEARN ABOUT MOJAVE
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
ENVIRONMENT
The COLUMNS, LANG, LC_ALL and LC_CTYPE environment variables affect the execution of column as described in environ(7).
EXIT STATUS
The column utility exits 0 on success, and >0 if an error occurs.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY " ;
printf "HH:MM/YEAR NAME
" ;
ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BUGS
Input lines are limited to LINE_MAX (2048) bytes in length.
BSD
July 29, 2004 BSD