11-10-2010
Merging information from multiple files to a single file
Hello,
I am new to unix and need help with a problem. I have 2 files each containing multiple columns of information ie;
File 1 :
A B C D E
1 2 3 4 5
File 2 :
F G
6 7
I would like to merge the information from File 2 to File 1 so that the data reads as follows;
File 1:
A B C D E F G
1 2 3 4 5 6 7
I am thinking of using the "Shift" command but i am not too sure. Is there an easier method? If there are any example for future reference i would be very grateful
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to select columns from multiple files and combine them in one file. The files are simulation-data-files with 23 columns each and about 50 rows. I now use:
cut -f 11 Sweep?wing-30?scale=0.?0?fan2?.txt | pr -3 | awk '{printf("\n%s\t%s\t%s",$1,$2,$3)}' > ../Data_Processed/output.txtI... (1 Reply)
Discussion started by: isgoed
1 Replies
2. UNIX for Dummies Questions & Answers
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
Discussion started by: smarter_aries
5 Replies
3. Shell Programming and Scripting
I have a folder that contains say 50 files in a sequential order:
cdf_1.txt
cdf_2.txt
cdf_3.txt
cdf_3.txt
.
.
.
cdf_50.txt.
I need to merge these files in the same order into a single tab delimited file.
I used the following shell script:
for x in {1..50};
do cat cdf_${x}.txt >>... (3 Replies)
Discussion started by: Lucky Ali
3 Replies
4. Shell Programming and Scripting
Hi,
1. Each message starts with date
2. There is blank line between each message
3. Each message does not contain same number of lines.
Any help in merging multiple lines in each message to a single line is much appreciated.
AIX: Korn Shell
Error log file looks like below.
... (5 Replies)
Discussion started by: bala123
5 Replies
5. Shell Programming and Scripting
I have been working of this script for a very long time and I have searched the internet for direction but I am stuck here.
I have about 3000 files with two columns each. The length of each file is 50000. Each of these files is named this way b.4, b.5, b.6, b.7, b.8, b.9, b.10, b.11, b.12... (10 Replies)
Discussion started by: iconig
10 Replies
6. Shell Programming and Scripting
I am trying to combine 4 .dat files into one single Output file
Inputs are:- file123.dat, file256.dat, file378.dat & file490
Expected Output:-
FileName=file1
{text from file1}
EOF
{blank line}
FileName=file2
{text from file2}
EOF
{blank line}
FileName=file3
{text from file3}
EOF... (4 Replies)
Discussion started by: lancesunny
4 Replies
7. Shell Programming and Scripting
Hi,
My requirement is search for the flat files in the location that are generated in a day and merge them into a single flat file.
In the merged file as well particular column value should go into particular column.
awk 'NR=1 FNR>1' $(ls -rt flatfile1_v_*)
when i use this command for... (4 Replies)
Discussion started by: srikanth_sagi
4 Replies
8. Shell Programming and Scripting
I just tried following
ls *.dat|sort -t"_" -k2n,2|while read f1 && read f2; do
awk '{print}' $f1
awk FNR==1'{print $1,$2,$3,$4,$5,"*","*","*" }' OFS="\t" $f2
awk '{print}' $f2
donegot following result
18-Dec-1983 11:45:00 AM 18.692 84.672 0 25.4 24
18-Dec-1983 ... (3 Replies)
Discussion started by: Akshay Hegde
3 Replies
9. Shell Programming and Scripting
Hi Friends ,
Please guide me with the code to extract multiple files from one file .
The File Looks like ( Suppose a file has 2 tables list ,column length may vary )
H..- > File Header....
H....- >Table 1 Header....
D....- > Table 1 Data....
T....- >Table 1 Trailer....
H..-> Table 2... (1 Reply)
Discussion started by: AspiringD
1 Replies
10. UNIX for Beginners Questions & Answers
I Want to merge multiple lines based on the 1st field and keep into single record.
SRC File:
AAA_POC_DB.TAB1
AAA_POC_DB.TAB2
AAA_POC_DB.TAB3
AAA_POC_DB.TAB4
BBB_POC_DB.TAB1
BBB_POC_DB.TAB2
CCC_POC_DB.TAB6
OUTPUT
-----------------
'AAA_POC_DB','TAB1','TAB2','TAB3','TAB4'... (10 Replies)
Discussion started by: raju2016
10 Replies
LEARN ABOUT DEBIAN
cobertura-merge
COBERTURA-MERGE(1) General Commands Manual COBERTURA-MERGE(1)
NAME
cobertura-merge -- merge multiple data files into a single data file
SYNOPSIS
cobertura-merge [--datafile file] datafile [...]
DESCRIPTION
cobertura-merge can be run after your JUnit tests to merge multiple data files into a single data file.
OPTIONS
--datafile file
Specify the name of the file containing metadata about your classes. This is the "destination" file into which the contents of
the other data files will be merged. Default value: "./cobertura.ser".
SEE ALSO
junit(1), cobertura-instrument(1), cobertura-report(1), cobertura-check(1).
AUTHOR
This manual page was written by Miguel Landaeta <miguel@miguel.cc> for the Debian system (but may be used by others). Permission is
granted to copy, distribute and/or modify this document under the terms of the terms of GNU General Public License, Version 2 or any later
version published by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
COBERTURA-MERGE(1)