05-03-2012
Combine columns from multiple files
Can anybody help on the script to combine/concatenate columns from multiple files
input1
HTML Code:
4 135
5 185
6 85
11 30
16 72
17 30
21 52
22 76
input2
HTML Code:
2 50
4 50
6 33
8 62
10 25
12 46
14 42
15 46
output
HTML Code:
nr input1 input2
2 50
4 135 50
5 185
6 85 33
8 62
10 25
11 30
12 46
14 42
15 46
16 72
17 30
21 52
22 76
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there,
I was wondering if someone can help me with this.
I am trying the combine multiple columns from multiple files into one file.
Example file 1:
c0t0d0 c0t2d0 # hostname vgname
c0t0d1 c0t2d1 # hostname vgname
c0t0d2 c0t2d2 # hostname vgname
c0t1d0 c0t3d0 # hostname vgname1... (5 Replies)
Discussion started by: martva
5 Replies
2. UNIX for Dummies Questions & Answers
I need to compile a large amount of data with a common string from individual text files throughout many directories.
An example data file is below. I want to search for the following string, "cc_sectors_1" and combine all the data from each file which contains this string, into one new... (2 Replies)
Discussion started by: GradStudent2010
2 Replies
3. Shell Programming and Scripting
I have multiple files; each file contains a certain data in a column view
simply i want to combine all those files into one file in columns
example
file1:
a
b
c
d
file 2:
1
2
3
4
file 3:
G (4 Replies)
Discussion started by: ahmedamro
4 Replies
4. Shell Programming and Scripting
Hi Guys,
I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated.
inputfile1.txt
12345
67890
24580
inputfile2.txt
AAAAA
BBBBB
CCCCC (11 Replies)
Discussion started by: pinpe
11 Replies
5. Emergency UNIX and Linux Support
Hi Ppl,
I have a requirement like i will be getting files of huge size daily and if the file size is so huge ,the files will be split into many parts and sent.The first file will have the header details followed by detail records and the consecutive files will have detail records and the last... (11 Replies)
Discussion started by: ganesh_248
11 Replies
6. UNIX for Dummies Questions & Answers
This may seem obvious but I am having problems doing this as columns get converted to rows when i try to write a script.
I have 2 files text1.txt and text2.txt each of which have 6 columns of numbers separated by a space.
I need to combine the 2 files so that the output file text3.txt maintains... (2 Replies)
Discussion started by: tgoldstone
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I have a bunch of files with the following format.
PUR.1.9
30910 0.024 0.926 0.050
36587 0.024 0.927 0.049
91857 0.023 0.928 0.049
105797 0.024 0.927 0.049
146659 0.024 0.927 0.049
152695 0.024 0.927 0.049
192118 0.022 0.930 0.048
193310 0.018 0.936 0.046
PUR.2.9
30910 0.028... (6 Replies)
Discussion started by: genehunter
6 Replies
8. 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
9. Shell Programming and Scripting
Hello everyone,
I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble.
I have many files each having two columns and hundreds of rows.
first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies
10. Shell Programming and Scripting
I have to create a new CSV file based on the value listed on the 3rd column from different CSV files. This is what I need:
1. I should substitute the first column from each file, excluding the headers, with the file name InputXX.
2. Then, I need to look for rows with 0 on the third column in... (7 Replies)
Discussion started by: Xterra
7 Replies
LEARN ABOUT XFREE86
bos_prune
BOS_PRUNE(8) AFS Command Reference BOS_PRUNE(8)
NAME
bos_prune - Removes obsolete files from /usr/lib/openafs and /var/log/openafs
SYNOPSIS
bos prune -server <machine name> [-bak] [-old] [-core]
[-all] [-cell <cell name>] [-noauth] [-localauth]
[-help]
bos p -s <machine name> [-b] [-o] [-co] [-a]
[-ce <cell name>] [-n] [-l] [-h]
DESCRIPTION
The bos prune command removes files from the local disk of the server machine named by the -server argument, as specified by one or more of
the following flags provided on the command line:
o The -bak flag removes all files from the /usr/lib/openafs directory that have a ".BAK" extension.
o The -old flag removes all files from the /usr/lib/openafs directory that have a ".OLD" extension.
o The -core flag removes all files from the /var/log/openafs directory that have a "core." prefix.
o The -all flag removes all three types of files at once.
(If none of these flags are included, the command appears to succeed, but removes no files at all.)
To display the timestamp on the current, ".BAK", and ".OLD" versions of one or more files, use the bos getdate command.
OPTIONS
-server <machine name>
Indicates the server machine from which to remove files. Identify the machine by IP address or its host name (either fully-qualified or
abbreviated unambiguously). For details, see bos(8).
-bak
Removes all files from the /usr/lib/openafs directory that have a ".BAK" extension. Do not combine this flag and the -all flag.
-old
Removes all files from the /usr/lib/openafs directory that have a ".OLD" extension. Do not combine this flag and the -all flag.
-core
Removes all files from the /var/log/openafs directory that have a "core." prefix. Do not combine this flag and the -all flag.
-all
Combines the effect of the -bak, -old, and -core flags. Do not combine this flag with any of those three.
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see bos(8).
-noauth
Assigns the unprivileged identity "anonymous" to the issuer. Do not combine this flag with the -localauth flag. For more details, see
bos(8).
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The bos command interpreter presents the ticket
to the BOS Server during mutual authentication. Do not combine this flag with the -cell or -noauth options. For more details, see
bos(8).
-help
Prints the online help for this command. All other valid options are ignored.
EXAMPLES
The following example removes all files from the /usr/lib/openafs directory on the machine "fs3.abc.com" that have a ".BAK" or ".OLD"
extension.
% bos prune -server fs3.abc.com -bak -old
The following example removes all files from the /usr/lib/openafs directory on the machine "db2.abc.com" that have a ".BAK" or ".OLD"
extension, and all files from the /var/log/openafs directory that have a "core." prefix.
% bos prune -server db2.abc.com -all
PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on the machine named by the -server argument, or must be logged onto a
server machine as the local superuser "root" if the -localauth flag is included.
The bos prune command cannot be run against servers which are in restricted mode.
SEE ALSO
KeyFile(5), UserList(5), bos(8), bos_getdate(8)
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BOS_PRUNE(8)