Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Intelligently merge two files
Top Forums Shell Programming and Scripting Intelligently merge two files Post 302952438 by jamie_123 on Wednesday 19th of August 2015 05:31:35 AM
Old 08-19-2015
Intelligently merge two files
I have two files as the following:

file1:
Code:
243
242
243
242
242

file2:
Code:
243          car       360    396k
242          bike       240    217k

I want the corresponding $3 in file 2 added as $2 in file 2.

The expected output would be:
Code:
243 360
242 240
243 360
242 240
242 240

I figured that I can do this through two loops, but I am not sure how to extract the exact values that I would need, here is that I was thinking of:
Code:
 while read y; do
                while read z; do

                done<file1
        done<file2

Is there a better way to do this using only awk or sed?

Thanks.

---------- Post updated at 11:31 AM ---------- Previous update was at 11:18 AM ----------

I think I figured out a bash based method. I can find matches now. Figuring out a way to print should be straight forward.

Code:
while read y; do
                while read z; do
                        a=$(echo $y | awk '{print $1}')
                        if [ "$a" = "$z" ]; then
                                echo $y
                        else
                                echo nomatch
                        fi
                done<file1
        done<file2

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to merge files

Hello guys, I gotta question, i have a lot of log files (simple text) and i need to merge them in group of 10 files, one next to the other, that have sense? For example, i have the files: File1 File2 File3 File4 . . File100 I need to merge the contents of each file into a new file... (3 Replies)
Discussion started by: lestat_ecuador
3 Replies

2. UNIX for Advanced & Expert Users

Intelligently Installing from Source

Hi: (I apologise in advance for the lengthy prelude--but i think it's necessary to properly ask my question.) I code in Ruby and Python on Mac OS X. Ruby, for instance, as i suspect everyone here knows, is both open source and it it lacks native support for e.g., GUI and Image Manip. These two... (0 Replies)
Discussion started by: Alex_Land
0 Replies

3. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies

4. Shell Programming and Scripting

merge two different files

HI I have input file as date 22jan2011 calc 0 667788.1 998877.2 vals 1 222 444 666 777 999 vals 2 222 444 666 777 999 vals 3 ... (3 Replies)
Discussion started by: Indra2011
3 Replies

5. Shell Programming and Scripting

awk "intelligently" paste two files together.

Hi everyone, I am trying to join two files together based on a field present in both files but not necessarily in the same order. File 1: 123 user1 245 user2 559 user3 File 2: 123 user1 246 user4 544 user2 Also, sometimes a user may not even be in both files. What I want awk to... (3 Replies)
Discussion started by: collards
3 Replies

6. UNIX for Dummies Questions & Answers

Merge files

Hi, I would like to know how can I merge files based on their coordinates, but mantaining the score of each file in the output file like: Note: 1st column is for chromosome, 2nd for start, 3rd for end of segment, 4th for score file1: 1 200 300 20 1 400 500 30 file2: 1 200 350 30 1... (1 Reply)
Discussion started by: fadista
1 Replies

7. Shell Programming and Scripting

Checking in a directory how many files are present and basing on that merge all the files

Hi, My requirement is,there is a directory location like: :camp/current/ In this location there can be different flat files that are generated in a single day with same header and the data will be different, differentiated by timestamp, so i need to verify how many files are generated... (10 Replies)
Discussion started by: srikanth_sagi
10 Replies

8. UNIX for Dummies Questions & Answers

How to use a error log file intelligently.?

This has broad implications but is there a way to tell which applications are logging into lets say xsessons error file? How do I tell which error messages pertain to which applications? Thanks in advance!:D (2 Replies)
Discussion started by: theKbStockpiler
2 Replies

9. Shell Programming and Scripting

Merge files and generate a resume in two files

Dear Gents, Please I need your help... I need small script :) to do the following. I have a thousand of files in a folder produced daily. I need first to merge all files called. txt (0009.txt, 0010.txt, 0011.txt) and and to output a resume of all information on 2 separate files in csv... (14 Replies)
Discussion started by: jiam912
14 Replies

10. Shell Programming and Scripting

How to merge two files?

Dear Frens, I have two files and need to merge into one file. Like File_1: Field1 Field2 1 4 File_2: Field1 Field2 3 5 I need one single output as File_1: Field1 Field2 1 4 3 5 This means taking header from either file. (8 Replies)
Discussion started by: manisha_singh
8 Replies

LEARN ABOUT OPENSOLARIS

iconv_maz

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

NAME

       iconv_maz - code set conversion tables for Mazovia

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |  ISO 8859-2    |   Mazovia      |  ISO 8859-2   |
       |24-177         | 40             |230             |246            |
       |200            | 307            |231             |326            |
       |201            | 374            |232             |334            |
       |202            | 351            |233             |40             |
       |203            | 342            |234             |243            |
       |204            | 344            |235             |40             |
       |205            | 40             |236             |266            |
       |206            | 261            |237             |40             |
       |207            | 347            |240             |254            |
       |210            | 40             |241             |257            |
       |211            | 353            |242             |363            |
       |212-213        | 40             |243             |323            |
       |214            | 356            |244             |361            |
       |215            | 346            |245             |321            |
       |216            | 304            |246             |274            |
       |217            | 241            |247             |277            |
       |220            | 312            |250-340         |40             |
       |221            | 352            |341             |337            |
       |222            | 263            |342-365         |40             |
       |223            | 364            |366             |367            |
       |224            | 366            |367             |40             |
       |225            | 306            |370             |260            |
       |226-227        | 40             |371-376         |40             |
       |256            | 201            |                |               |
       +---------------+----------------+----------------+---------------+

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

       +---------------+----------------+----------------+---------------+
       |   Mazovia     |    MS 1250     |   Mazovia      |   MS 1250     |
       |200            | 307            |236             |234            |
       |201            | 374            |237             |40             |
       |202            | 351            |240             |217            |
       |203            | 342            |241             |257            |
       |204            | 344            |242             |363            |
       |205            | 40             |243             |323            |
       |206            | 271            |244             |361            |
       |207            | 347            |245             |321            |
       |210            | 40             |246             |237            |
       |211            | 353            |247             |277            |
       |212-213        | 40             |250-251         |40             |
       |214            | 356            |252             |254            |
       |215            | 346            |253-255         |40             |
       |216            | 304            |256             |253            |
       |217            | 245            |257             |273            |
       |220            | 312            |260-340         |40             |
       |221            | 352            |341             |337            |
       |222            | 263            |342-345         |40             |
       |223            | 364            |346             |265            |
       |224            | 366            |347-360         |40             |
       |225            | 306            |361             |261            |
       |226-227        | 40             |362-365         |0              |
       |230            | 214            |366             |367            |
       |231            | 326            |367             |40             |
       |232            | 334            |370             |260            |
       |233            | 40             |371             |40             |
       |234            | 243            |372             |267            |
       |235            | 40             |373-376         |40             |
       |274            | 212            |                |               |
       +---------------+----------------+----------------+---------------+

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

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |    MS 852      |   Mazovia      |    MS 852     |
       |205            | 40             |234             |235            |
       |206            | 245            |235             |40             |
       |210-213        | 40             |236             |230            |
       |215            | 206            |237             |40             |
       |217            | 244            |240             |215            |
       |220            | 250            |241             |275            |
       |221            | 251            |243             |340            |
       |222            | 210            |244             |344            |
       |225            | 217            |245             |343            |
       |226-227        | 40             |246             |253            |
       |230            | 227            |247             |276            |
       |233            | 40             |250-375         |40             |
       |227            | 327            |                |               |
       +---------------+----------------+----------------+---------------+

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

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |   Mazovia     |      DHN       |   Mazovia      |     DHN       |
       |200-205        | 40             |234             |203            |
       |206            | 211            |236             |217            |
       |207-214        | 40             |240             |207            |
       |215            | 212            |241             |210            |
       |216            | 40             |242             |216            |
       |217            | 200            |243             |205            |
       |220            | 202            |244             |215            |
       |221            | 214            |246             |220            |
       |225            | 201            |247             |221            |
       |230            | 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_maz(5)
All times are GMT -4. The time now is 01:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy