06-02-2011
Combining columns from multiple files to one file
I'm trying to combine colums from multiple file to a single file but having some issues, appreciate your help.
The filenames are the same except for the extension,
path1.m0
---------
a b c
d e f
g h i
path1.m1
---------
m n o
p q r
s t u
File names are path1.m[0 - 1]
The desired output file is path1.m and output is
a n
d q
g t
I can do this by the paste command
paste path1.m0 path1.m1 | awk '{print $1 $5}' > path1.m
The issue I'm having is that I've multiple files like
path2.m0
path2.m1
path3.m0
path4.m1
How do I set a variable to read all the path1.* and path2.* and path3* files and give the output files
path1.m
path2.m
path3.m
Thanks very much.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I would be very grateful for some advice on the following.
I have several text files. The files are experiment results with columns of data separated by white space.
The files begin with several lines of header which are all preceeded by a comment character '#'.
Each file has a... (10 Replies)
Discussion started by: iomaire
10 Replies
2. Shell Programming and Scripting
I have two files I need to combine. The problem I'm having is I need to only combine data from the second file in the empty spaces of the first. For example:
file1
Data Field
Data Field
Data Field
Data Field
file2
a - Insert Data
b - Insert Data
c - Insert Data
d - Insert Data... (10 Replies)
Discussion started by: handband2
10 Replies
3. UNIX for Dummies Questions & Answers
I have one space delimited file with multiple columns and one tab delimited file with multiple columns (They have the same number of rows). I want to basically combine these two text files into a new text file by column. How would I go about doing that? (1 Reply)
Discussion started by: evelibertine
1 Replies
4. Shell Programming and Scripting
Hello All,
I have several column files like this
$cat a_b_s1.xls
1wert
2tg
3asd
4asdf
5asdf
$cat c_d_s2.xls
1wert
2tg
3asd
4asdf
5asdf
desired put put
$cat combined.txt
s1 s2 (2 Replies)
Discussion started by: avatar_007
2 Replies
5. Shell Programming and Scripting
I have 2 files.
each having 3 coloums
1st field date as 20130322
2nd field time as 05:55
3rd field numberic value
File 2 has entries missing for some date time.
FILE1
20130322 05:35 2219
20130322 05:40 1809
20130322 05:45 1617
20130322 05:50 ... (2 Replies)
Discussion started by: sandeepkmehra
2 Replies
6. Shell Programming and Scripting
Hi,
I have 3 files with one column value as shown
File: a.txt
------------
Data_a1
Data_a2
File2: b.txt
------------
Data_b1
Data_b2
Data_b3
Data_b4
File3: c.txt
------------
Data_c1
Data_c2
Data_c3
Data_c4
Data_c5 (6 Replies)
Discussion started by: vfrg
6 Replies
7. Linux
Hey Guys & Gals,
I am stuck with the following ;
I have 2 text files, each containing 2 columns.
My goal is to have a column from the 2nd file placed inbetween the columns in the first file.
Basically the idea is, each address has a different name (but 1 name per address) but 1 address... (6 Replies)
Discussion started by: TAPE
6 Replies
8. Shell Programming and Scripting
I would like to join two files when two columns in each file matches with each other and then produce an output when taking multiple columns.
Like I have file A
1234,ABCD,23,JOHN,NJ,USA
2345,ABCD,24,SAM,NY,USA
5678,GHIJ,24,TOM,NY,USA
5678,WXYZ,27,MAT,NJ,USA
and file B
... (2 Replies)
Discussion started by: mady135
2 Replies
9. UNIX for Beginners Questions & Answers
Hello Everyone,
I have 4 different files (one column in each) that I'm trying to combine into 1 file with four columns. Having issues trying to get the columns to format properly. I have tried the following:
paste file1 file2 file3 file4 | column -s $'\t' -t > results.txt
paste file1 file2... (1 Reply)
Discussion started by: malk71
1 Replies
10. Shell Programming and Scripting
Hello Unix gurus,
I have a large number of files (say X) each containing two columns of data and the same number of rows.
I would like to combine these files to create a unique merged file containing X columns corresponding to the second column of each file (with a bonus of having the first... (3 Replies)
Discussion started by: ksennin
3 Replies
LEARN ABOUT SUSE
mbk_cata_lib
MBK_CATA_LIB(1) MBK ENVIRONMENT VARIABLES MBK_CATA_LIB(1)
NAME
MBK_CATA_LIB - define the mbk catalog directory
SYNOPSYS
c-shell running
setenv MBK_CATA_LIB path1:path2:path3:...:...:pathn
ORIGIN
This software belongs to the ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in
Paris, France.
Web : http://asim.lip6.fr/recherche/alliance/
E-mail : alliance-users@asim.lip6.fr
DESCRIPTION
MBK_CATA_LIB sets the directories that are to be searched thru for reading. When instanciating a cell for example, the first cell that is
found with the given name is loaded in memory.
The seaching mecanism first look in MBK_WORK_LIB(1), and then, in path1 thru pathn, in the order defined by the user when typing the setenv
command. This directories are considered to be, from a mbk point of view, read only.
The pathi arguments must be actually accessible pathes on your host machine.
ERRORS
"mbk_fopen : can't open file 'unix_path/file.xx' thru directories : path1, ..., pathn"
This occurs when either the unix path is irrelevent, or when the file doesn't exist. This can also be a unix right problem if the
file is not accessible for reading, but this is seldom.
EXAMPLE
setenv MBK_CATA_LIB ~fred/crechan/uom:/labo/sclib
DIAGNOSTICS
Only the first path may be given with a '~', since the shell extents it only when seen first.
SEE ALSO
mbk(3), genlib(1), MBK_WORK_LIB(1).
BUG REPORT
This tool is under development at the ASIM department of the LIP6 laboratory.
We need your feedback to improve documentation and tools.
ASIM
/LIP6 October 1, 1997 MBK_CATA_LIB(1)