07-10-2006
Need help for 2 data file merging
Hello
Please help me to write Shell script.
I want to merge 2 data files . The data files have common columns
The data file A have 3 columns
Host Version Numberof Failuers
The data file B have also 3 coulmns
Host Version NumberofFailuers .
I want to merge A and B file whereHost and version is common column in both files
The file C should contain data of A and B file
Host Version NumberofFailuers A file NumberofFailuersB File .
Before merging it should check whether Host & version of A file should be equal to Host & version of B file For eg :
For A file
Host Version NoofFailuersA
Linux 7.8 15
Sun 8.5 20
Sun 5.6 50
For B file
Host Version NoofFailuersB
Linux 7.8 15
Sun 5.6 34
Red 5.7 30
The Output File C should merge and contain data like this
Host Version NoofFailuersA NofFailuersB
Linux 7.8 15 15
Sun 8.5 20 34
Sun 5.6 50
Red 5.7 30
Please help me
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have the following problem:
Input:
"num1","num2","num3",num4,num5,"num6"
required output:
"num1num2","num3",num4,num5,"num6"
I need to join field 1 and field 2 together but I always end up getting:
"num1""num2","num3",num4,num5,"num6"
Note that not all fields have " at both... (8 Replies)
Discussion started by: ReV
8 Replies
2. Shell Programming and Scripting
I'm trying to merge multiple CSV (comma separated value) files into one large master file. All files have a field that is unique to act as the key for entry/merging into the master file & and all files have the same number of fields that are in the master file.
I'll give an example here:
... (2 Replies)
Discussion started by: jjinca
2 Replies
3. Shell Programming and Scripting
This is on a HP-UX system.
I need to merge the 2 reports, for each line in syslog I need to lookup who was logged in to the pts/# based on the time from the last.txt report.
Here is what I get from sulog.log
cat syslog | grep "su:" | grep "Jun 14"
Jul 14 08:02:48 server1 su: - 2 ... (8 Replies)
Discussion started by: Ikon
8 Replies
4. Shell Programming and Scripting
Hi, I am trying to remove the carriage return on the record which starts with ADD, MODIFY, or DELETE keyword as the first value in the record. If the records does not start with anyone of these keywords then combine the records with the previous record (line).
Input
File name xyz.txt... (6 Replies)
Discussion started by: naveed
6 Replies
5. Shell Programming and Scripting
Hi,
I have 2 files that I got as an output from another program. They are :
File 1
((((((CtBJa:197.0,CtBTz:197.0):85.0,CtAHr:197.0):116.0,CtDUw:197.0):176.0,CtSwe:197.0):110.0,
(CtL2b:197.0,Ct4Bu:197.0):196.0):197.0,CmuNg:197.0);... (5 Replies)
Discussion started by: Lucky Ali
5 Replies
6. Shell Programming and Scripting
Hi all,
Sorry if someone has answered something like this already, but I have a problem. I am not brilliant with "awk" but think it should be the command to use to get what I am after.
I have 2 files:
job-file (several hundred lines like):
1018003,LONG MU WAN,1113S
1018004,LONG MU... (4 Replies)
Discussion started by: sgb2301
4 Replies
7. Shell Programming and Scripting
Hello,
I have a master database of a dictionary with the following structure:
a=b (b is a Unicode string)
a is the English part and b is the equivalent in a foreign language
I have also another file which has a database where the /b/ part of the string has been corrected by an expert. let us... (5 Replies)
Discussion started by: gimley
5 Replies
8. UNIX for Dummies Questions & Answers
Hello,
Firstly I just wanted to say that I'm not a programmer at all and appreciate any help you can give. I am trying to create a shellscript that reformats the file and adding up colums 5 and 6 for those sections that are continuation of the previous line(s) (signified by beginning with '*')... (4 Replies)
Discussion started by: neilh1703
4 Replies
9. Shell Programming and Scripting
Hi,
My input is
<message>
looking for a big
<message>Does fit my G74 laptop. Makes the 10 pound.
<message>
<message>This bag is the only one I could find to fit my awesome ASUS G74S.
<message>
<message>
Great bag my only wish is that they had put a pocket in which to store and... (6 Replies)
Discussion started by: pamu
6 Replies
10. Shell Programming and Scripting
Hi Everyone,
I have two files file1 and file2 with these contents
cat file1
AAAAA 01/03/2014 04:01:23
BBBB 01/03/2014 03:03:34
CCCcc 01/03/2014 03:03:34
cat file2
1 RED
1 HHHH
1 TTTT
1 BBBBB
I tried the below... (2 Replies)
Discussion started by: Aditya_001
2 Replies
LEARN ABOUT SUSE
funmerge
funmerge(1) SAORD Documentation funmerge(1)
NAME
funmerge - merge one or more Funtools table files
SYNOPSIS
funmerge [-w|-x] -f [colname] <iname1> <iname2> ... <oname>
OPTIONS
-f # output a column specifying file from which this event came
-w # adjust position values using WCS info
-x # adjust position values using WCS info and save old values
DESCRIPTION
funmerge merges FITS data from one or more FITS Binary Table files or raw event files.
The first argument to the program specifies the first input FITS table or raw event file. If "stdin" is specified, data are read from the
standard input. Use Funtools Bracket Notation to specify FITS extensions and row filters. Subsequent arguments specify additional event
files and tables to merge. (NB: Stdin cannot not be used for any of these additional input file arguments.) The last argument is the out-
put FITS file. The columns in each input table must be identical.
If an input file begins with the '@' character, it is processed as an include file, i.e., as a text file containing event file names (as
well as blank lines and/or comment lines starting with the '#' sign). If standard input is specified as an include file ('@stdin'), then
file names are read from the standard input until EOF (^D). Event files and include files can be mixed on a command line.
Rows from each table are written sequentially to the output file. If the switch -f [colname] is specified on the command line, an addi-
tional column is added to each row containing the number of the file from which that row was taken (starting from one). In this case, the
corresponding file names are stored in the header parameters having the prefix FUNFIL, i.e., FUNFIL01, FUNFIL02, etc.
Using the -w switch (or -x switch as described below), funmerge also can adjust the position column values using the WCS information in
each file. (By position columns, we mean the columns that the table is binned on, i.e., those columns defined by the bincols= switch, or
(X,Y) by default.) To perform WCS alignment, the WCS of the first file is taken as the base WCS. Each position in subsequent files is
adjusted by first converting it to the sky coordinate in its own WCS coordinate system, then by converting this sky position to the sky
position of the base WCS, and finally converting back to a pixel position in the base system. Note that in order to perform WCS alignment,
the appropriate WCS and TLMIN/TLMAX keywords must already exist in each FITS file.
When performing WCS alignment, you can save the original positions in the output file by using the -x (for "xtra") switch instead of the
-w switch (i.e., using this switch also implies using -w) The old positions are saved in columns having the same name as the original
positional columns, with the added prefix "OLD_".
Examples:
Merge two tables, and preserve the originating file number for each row in the column called "FILE" (along with the corresponding file name
in the header):
[sh] funmerge -f "FILE" test.ev test2.ev merge.ev
Merge two tables with WCS alignment, saving the old position values in 2 additional columns:
[sh] funmerge -x test.ev test2.ev merge.ev
This program only works on raw event files and binary tables. We have not yet implemented image and array merging.
SEE ALSO
See funtools(7) for a list of Funtools help pages
version 1.4.2 January 2, 2008 funmerge(1)