UNIX for Dummies Questions & Answers

I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but

- Currently, script is not printing lines to File3.txt in order.

Thanks a lot.
Any help is appreciated.

Script I am using:

Code:

awk 'FNR == NR && ! /^[[:space:]]*$/ { key = substr($0,1,8); a[key] = $0; next }
$1 == "01" { if (key != 0)
             {
                 if (key in a)
                 {
                     printf("77\t%s\n", a[key])
                     delete a[key]
                 }
             }
             key = $4 $3 $2
           }
{ if (key in a) print $0 } ' \
     File2.txt File1.txt > File3.txt

File1.txt

Code:

 01  89  68  5000
    02  83  11
    04  83  9   02
    03  83  00
    06  83  00
    07  83  11  RT0429
    07  83  88  FS0547
    01  44  73  8800
    02  44  73
    04  44  73   02
    03  44  73
    06  44  73
    07  44  11  RT  0789

File2.txt

Code:

    50006889RT0429 NARD /3010  /E     /C A87545457          /  //                ///11        ///
    51002387 NARD /3000  /E     /S N054896334IV          /  //                ///11        ///

Current Output (File3.txt)

Code:

    07  83  11  RT0429
    77	50006889RT0429 NARD /3010  /E     /C A87545457          /  //                ///11        ///
    01  44  73  8800
    02  44  73
    04  44  73   02
    03  44  73
    06  44  73

Desired Output (File3.txt)

I need complete set from line 01 to 07 including any addition 07 lines in case the key is matched from File1, followed by 77 tab and matched string from File2.

Code:

 01  89  68  5000
    02  83  11
    04  83  9   02
    03  83  00
    06  83  00
    07  83  11  RT0429
    07  83  88  FS0547
    77	50006889RT0429 NARD /3010  /E     /C A87545457          /  //                ///11        ///

Using the term URGENT, esp. in bold red, is deprecated and sort of risky in these fora. Try to avoid it in the fututre.

If I remember correctly, you have been supplied with solutions to very similar problems in various threads in the recent past which you tried to condense into your script. So I think you're not too far away. Why don't you sit back and stare a while at your code snippet? The solution will jump to your eyes. (Little hint: Look at your if (key in a) command and what you are printing there...) And, you might want to add an else branch to print the non-matching records.

RudiC,
Note that High-T did get an infraction for using URGENT and double-posting in another thread. I decided that one infraction was required, but didn't think two infractions were necessary at this time.

I also believe that High-T needs to look more closely at the working code he has been given and the new requirements presented in this thread and take a little time to THINK about what different needs to be done to satisfy those new requirements.

High-T,
In the 5 days since you joined this forum, you have submitted 6 threads all based on a very similar awk script. After fixing your code four times to do your tasks, you have submitted two more threads for this problem and say that we volunteers need to URGENTLY fix your code even though it looks like you are not willing to apply suggestions we have suggested in the four threads we solved for you. We are volunteers; not your paid programming staff. You have no right to expect volunteers here who have helped you with other problems (or new volunteers who may be willing to help you) to put aside other things they might have planned to do this weekend to help you meet your deadlines.

Please show us what in your current code is intended to move any lines out of File1.txt.

Please tell us what the code:

Code:

    $1=="01" &&
                FNR>1       {keyfound?"77\t" keyfound:"99"}

is intended to do. It is a nice expression, but it produces no output and sets no variables.

Given that you never use the variable lines except in these two statements:

Code:

        lines = ""
           and
    lines = lines $0 "\n"

please tell us what this variable is intended to do. Are you trying to use this to save up lines to be printed when you get the end of a set if a match was found? That would make sense; but that isn't what you're doing. Are you trying to save up lines to be reprocessed on a later run if no match is found? That would make sense, but that isn't what you're doing.

Given that File2.txt has leading spaces and that the length of the 1st field in that file is variable length (not a constant 14 characters), it would seem that:

Code:

    		a[substr($0,1,14)]=$0

might need to be something more like:

Code:

    		a[$1]=$0

The key used in your other threads could be set when you found a record starting with 01. In this thread you can't set the key until you have found both a 01 record and a 07 record. And, you can have more than one key for a single set of records. Therefore, you need to accumulate an entire set of records that may need to be printed until you have found the entire set of keys for that set and have determined whether there are any matching keys. If you look closely at your output, you will note that you haven't printed lines out of order; instead, you have printed lines starting from when you finished a matching key when you found a record starting with 07 and continued printing lines until you find another 07 record that doesn't match. BUT, I can't see how you would get the output you showed us with the code you've shown us?????

Hopefully, these comments will help you produce a working script.

Thanks RudiC. I have realized that I should not be using this term as I am getting help for free. I have reviewed the policy and I would be careful next time. Thanks for all your help.

---------- Post updated at 11:23 AM ---------- Previous update was at 11:21 AM ----------

Thanks Don. You have been really helpful. I apologize for duplicate posting. I posted a new question and then I updated an old one but they were the same I admit. I promise I would respect the forum policy in future. Again thanks for your time and efforts.

---------- Post updated 02-03-15 at 10:20 AM ---------- Previous update was 02-02-15 at 11:23 AM ----------

Tried everything but the output is not coming in order

Show us what you have tried.

And, you have received several hints on what to modify in your script to make it work.

I have updated the question with the script.

Code:

awk 'FNR == NR && ! /^[[:space:]]*$/ { key = substr($0,1,8); a[key] = $0; next }
$1 == "01" { if (key != 0)
             {
                 if (key in a)
                 {
                     printf("77\t%s\n", a[key])
                     delete a[key]
                 }
             }
             key = $4 $3 $2
           }
{ if (key in a) print $0 } ' \
     File2.txt File1.txt > File3.txt