07-14-2010
Wow that works great. Looks like I need to read up some more on nawk.
One thing though. This is eliminating the rows from FileA that have the same A3 value but the unique A1. In other words, the merged file should contain 1 row for every A1 field that contains an A3 (no matter if its the same as the one above it). This is eliminating the first 2 lines that have a "DDDD" in FileA. There needs to be 3 lines that have a "DDDD" in the merged output since FileA had 3 different A1's with the same A3. "HHHH" is the same way.
How would you alter this to allow those scenarios to be caught?
:::::::::
::FileA::
:::::::::
A1-------A2--------A3---A4---A5--
=================================
DC35S51--XXXXY1----DDDD------44X-
DC35S52--XXXXY2----DDDD------44Y-
DC35S53--XXXXY3----DDDD------44Z-
=================================
:::::::::
::FileB::
:::::::::
B1------B2-------------------B3--------B4--------B5----------
=============================================================
DDDD----+NDMMN.BMXXMNX-------27/98B----NX/778----93010-------
=============================================================
It should come out to this:
:::::::::::::::
::Merged File::
:::::::::::::::
A1--------A3----B2----------------B3------B4------B5------
==========================================================
DC35S51---DDDD--+NDMMN.BMXXMNX----27/98B--NX/778--93010---
DC35S52---DDDD--+NDMMN.BMXXMNX----27/98B--NX/778--93010---
DC35S53---DDDD--+NDMMN.BMXXMNX----27/98B--NX/778--93010---
==========================================================
But instead its coming out like this:
A1--------A3----B2----------------B3------B4------B5------
==========================================================
DC35S53---DDDD--+NDMMN.BMXXMNX----27/98B--NX/778--93010---
==========================================================
eliminating the DC35S51 & DC35S52.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Thanks in advance
I have 2 files having key field in each.I would like to join both on common key.I have used join but not sucessful.
The files are attached here .
what i Want in the output is on the key field SLS OFFR .
I have used join commd but not successful.
File one
=======
SNO ... (6 Replies)
Discussion started by: vakharia Mahesh
6 Replies
2. Shell Programming and Scripting
Hi,
I have got two files
1.txt
1111|apple|
2222|orange|
2.txt
1111|1234|000000000004356|
1111|1234|000000001111|
1111|1234|002000011112|
2222|5678|000000002222|
2222|9102|000000002222|
I need to merge these two so that my out put looks like below:
Search code being used should be... (4 Replies)
Discussion started by: jisha
4 Replies
3. Shell Programming and Scripting
i would like to merge two files that have the same format but have different data.
i would like to create one output file that contains information from both the original files.:rolleyes: (2 Replies)
Discussion started by: joe black
2 Replies
4. Shell Programming and Scripting
Hi everyone,
I have two files which will be exactly same at first. After sometime there will be inserts in one file. My problem is how to reflect these changes in second file also.
I found out that any compare and merge utility would do the job like, GNU " sdiff " command. But the... (14 Replies)
Discussion started by: rameshonline
14 Replies
5. Shell Programming and Scripting
Hi,
I want to merge the two files on the basis of columns like...
file 1
Data Key
A 12
B 13
file2
Data Value
A A1
A A2
B B1
B B2 (5 Replies)
Discussion started by: clx
5 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have two files a.txt and b.txt.
a.txt
1
2
3
4
b.txt
a
b
c
d
e
I want to generate a file c.txt by merging these two file and the resultant file would contain
c.txt
1 (4 Replies)
Discussion started by: siba.s.nayak
4 Replies
7. Shell Programming and Scripting
I have two files
file 1 containing x rows and 1 column
file 2 containing x rows and 1 column
I want to merge both the files and add a comma between the two
eg
plz guide (1 Reply)
Discussion started by: test_user
1 Replies
8. Shell Programming and Scripting
Hello all,
I have limited experience in shell scripting. Here goes my question:
I have two directories that have same number of files with same file names i.e. consider 2 directories A and B. Both directories have files 1.txt, 2.txt......
I need to merge the file 1.txt of A with file 1.txt... (5 Replies)
Discussion started by: jaysean
5 Replies
9. Shell Programming and Scripting
Guys,
I am having little problem with getting a daily report!
The daily process that I do is as follows
1. Unload Header for the report from the systables to one unl file, say Header.unl
2. Unload the data from the required table/tables to another unl file, say Data.unl
3. Send a... (2 Replies)
Discussion started by: PikK45
2 Replies
10. Shell Programming and Scripting
Hi All ,
I have a scenario where we need to combine two files .
Below are the sample files and expected output ,
File 1:
1|ab
1|ac
1|ae
2|ad
2|ac
File 2:
1|xy
1|fc
2|gh
2|ku
Output file :
1|ab|xy (3 Replies)
Discussion started by: saj
3 Replies
LEARN ABOUT DEBIAN
dh_installdeb
DH_INSTALLDEB(1) Debhelper DH_INSTALLDEB(1)
NAME
dh_installdeb - install files into the DEBIAN directory
SYNOPSIS
dh_installdeb [debhelperoptions]
DESCRIPTION
dh_installdeb is a debhelper program that is responsible for installing files into the DEBIAN directories in package build directories with
the correct permissions.
FILES
package.postinst
package.preinst
package.postrm
package.prerm
These maintainer scripts are installed into the DEBIAN directory.
Inside the scripts, the token #DEBHELPER# is replaced with shell script snippets generated by other debhelper commands.
package.triggers
package.shlibs
These control files are installed into the DEBIAN directory.
package.conffiles
This control file will be installed into the DEBIAN directory.
In v3 compatibility mode and higher, all files in the etc/ directory in a package will automatically be flagged as conffiles by this
program, so there is no need to list them manually here.
package.maintscript
Lines in this file correspond to dpkg-maintscript-helper(1) commands and parameters. Any shell metacharacters will be escaped, so
arbitrary shell code cannot be inserted here. For example, a line such as "mv_conffile /etc/oldconffile /etc/newconffile" will insert
maintainer script snippets into all maintainer scripts sufficient to move that conffile.
A versioned Pre-Dependency on dpkg is needed to use dpkg-maintscript-helper(1). An appropriate Pre-Dependency is set in
${misc:Pre-Depends} ; you should make sure to put that token into an appropriate place in your debian/control file.
SEE ALSO
debhelper(7)
This program is a part of debhelper.
AUTHOR
Joey Hess <joeyh@debian.org>
9.20120909 2011-09-12 DH_INSTALLDEB(1)