Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merging two files with condition
Top Forums Shell Programming and Scripting Merging two files with condition Post 302542301 by digipak on Wednesday 27th of July 2011 07:14:34 AM
Old 07-27-2011
Merging two files with condition
I have two files of the type

111 222 10
112 223 20
113 224 30
114 225 20


and

111 222 9
444 555 8
113 224 32
666 777 25

I want to merge files based on 1 and 2nd column. if 1st and 2nd column are unique in file 1 and 2 keep them, if they 1st and 2nd column are comman in two files then average the values in 3rd column so I need the final result as;

111 222 9.5 <--- 1st and 2nd column in both are same so 3rd is avg.
112 223 20 <--- Unique to file1
113 224 31 <----- 1st and second column are same so 3rd is avg.
114 225 20 <--- Unique to file 1
444 555 8 <----- unique to file 2
666 777 25 <---- unique to file 2

Please help me with awk or any other script.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Merging two files

Hi I have a requirement like this. I have two files This is how data1.txt looks: EI3171280 38640658501 NENN2005-12-129999-12-312005-12-12HALL NANCY 344 CHENEY HIGHWAY ... (4 Replies)
Discussion started by: venommaker
4 Replies

2. Shell Programming and Scripting

merging files

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

3. Shell Programming and Scripting

Help with merging files

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

merging of files.

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

5. Shell Programming and Scripting

Merging of all files based on a condition

Hi Friends, I am new to UNIX. I need to merge all the files(to FINAL.txt) in single directory based one condition. Out of all the files one of file will have specific value like :GF01: at any where in the file. so the file which is having :GF01: should be appended at the last. EX:... (5 Replies)
Discussion started by: arund_01
5 Replies

6. Shell Programming and Scripting

Merging two files with same name

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

7. Shell Programming and Scripting

merging two files

file1.txt 1 2 10 11 56 57 7 8 43 44 and let's suppose that there is a file called file2.txt with 100 columns I want to produce a file3.txt with columns specified in file1.txt in that order (1,2,10,11,56,57,7,8,43,44) Thanks! (2 Replies)
Discussion started by: johnkim0806
2 Replies

8. Shell Programming and Scripting

Merging two files

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

9. UNIX for Dummies Questions & Answers

Merging two files baased on condition

Hi All, I have two below files(fileds separated by space). File1 001078401 A 5A1 001078401 B 085 001030035 A 5A1 001030035 B 085 File2 001078401 C 001 001078401 D 065 001030035 C 001 001030035 D 065... (6 Replies)
Discussion started by: satyar
6 Replies

10. Shell Programming and Scripting

Merging two files

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 SUNOS

iconv_dhn

iconv_dhn(5)						Standards, Environments, and Macros					      iconv_dhn(5)

NAME

       iconv_dhn - code set conversion tables for DHN (Dom Handlowy Nauki)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |ISO 8859-2    |iso2    | ISO Latin 2	    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |MS 852	      |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |DHN	      |dhn     |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   DHN to ISO 8859-2
       For the conversion of DHN to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |  ISO 8859-2	|     DHN	 |  ISO 8859-2	 |
       |24-177	       | 40		|222		 |40		 |
       |200	       | 241		|223		 |364		 |
       |201	       | 306		|224		 |366		 |
       |202	       | 312		|225-230	 |40		 |
       |203	       | 243		|231		 |326		 |
       |204	       | 321		|232		 |334		 |
       |205	       | 323		|233-237	 |40		 |
       |206	       | 246		|240		 |341		 |
       |207	       | 254		|241		 |355		 |
       |210	       | 257		|242		 |363		 |
       |211	       | 261		|243		 |372		 |
       |212	       | 346		|244-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-365	 |40		 |
       |215	       | 361		|366		 |367		 |
       |216	       | 363		|367		 |40		 |
       |217	       | 266		|370		 |260		 |
       |220	       | 274		|371-376	 |40		 |
       |221	       | 277		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to MS 1250
       For the conversion of DHN to MS 1250, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 1250	|     DHN	 |   MS 1250	 |
       |200	       | 245		|233-237	 |40		 |
       |201	       | 306		|240		 |341		 |
       |202	       | 312		|241		 |355		 |
       |203	       | 243		|242		 |363		 |
       |204	       | 321		|243		 |372		 |
       |205	       | 323		|244-251	 |40		 |
       |206	       | 214		|252		 |254		 |
       |207	       | 217		|253-255	 |40		 |
       |210	       | 257		|256		 |253		 |
       |211	       | 271		|257		 |273		 |
       |212	       | 346		|260-340	 |40		 |
       |213	       | 352		|341		 |337		 |
       |214	       | 263		|342-345	 |40		 |
       |215	       | 361		|346		 |265		 |
       |216	       | 363		|347-360	 |40		 |
       |217	       | 234		|361		 |261		 |
       |220	       | 237		|362-365	 |40		 |
       |221	       | 277		|366		 |367		 |
       |222	       | 40		|367		 |40		 |
       |223	       | 364		|370		 |260		 |
       |224	       | 366		|371		 |40		 |
       |225-230        | 40		|372		 |267		 |
       |231	       | 326		|373-376	 |40		 |
       |232	       | 334		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to MS 852
       For the conversion of DHN to MS 852, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    MS 852	|     DHN	 |    MS 852	 |
       |200	       | 244		|212		 |206		 |
       |201	       | 217		|213		 |251		 |
       |202	       | 250		|214		 |210		 |
       |203	       | 235		|215		 |344		 |
       |204	       | 343		|216		 |242		 |
       |205	       | 340		|217		 |230		 |
       |206	       | 227		|220		 |253		 |
       |207	       | 215		|221		 |276		 |
       |210	       | 275		|222-375	 |40		 |
       |211	       | 245		|		 |		 |
       +---------------+----------------+----------------+---------------+

   DHN to Mazovia
       For the conversion of DHN to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |     DHN       |    Mazovia	|     DHN	 |   Mazovia	 |
       |200	       | 217		|212		 |215		 |
       |201	       | 225		|213		 |221		 |
       |202	       | 220		|214		 |222		 |
       |203	       | 234		|215		 |244		 |
       |204	       | 245		|216		 |242		 |
       |205	       | 243		|217		 |236		 |
       |206	       | 230		|220		 |246		 |
       |207	       | 240		|221		 |247		 |
       |210	       | 241		|222-247	 |40		 |
       |211	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						      iconv_dhn(5)
All times are GMT -4. The time now is 02:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy