Shell Programming and Scripting

Code:

XYZNA0000778800Z
16123000012300321000000008000000000000000
16124000012300322000000007000000000000000
17234000012300323000000005000000000000000
17345000012300324000000004000000000000000
17456000012300325000000003000000000000000
9
XYZNA0000778900Z
16123000012300321000000008000000000000000
16124000012300322000000007000000000000000
17234000012300323000000005000000000000000
17345000012300324000000004000000000000000
17456000012300325000000003000000000000000
9

I have above file format from which I want to find a matching record. For example, match a number(7789) on line starting with XYZ and once matched look for a matching number (7345) in lines below starting with 1 until it reaches to line starting with 9. retrieve the entire line record. How can I accomplish this using shell script, awk, sed or any combination.

Expected Output:

Code:

XYZNA0000778900Z
17345000012300324000000004000000000000000

Your requirements are vague and I don't know what a "line record" is. With the three inputs you have shown us, what output are you hoping to produce?

What is you definition of a line record?

What operating system are you using?

What shell are you using?

What have you tried to solve this problem on your own?

I have edited question with expected output.

The shell is Bash.

Sorry for not being clear, let me explain this data format/requirement. Records that starts with XYZ contains item number (7789) and lines below it starting with 1 have store number immediately after 1. Line starting with 1 indicates store record and a line xyz indicates record for item number. A store number is of 4 characters (7345). The entire line starting with 1 has other details related to store number like quantity etc. for the item number above it. These item-store combination block of records end at 9 and after that new item-store combination block of records start.

I have tried to solve this on my own using

Code:

grep -A5 7789 filename

but I can only get record of item number or store number but not both at same time and my command produces unnecessary store records which I don't want to see. I only want to see a specific item-store combination of the record. Also number of line for store records (starting with 1) varies for each item so I can not accurately predict at which line number after XYZ the store record will be.

Your first step approach above will give false positives if 7789 occurred in any other line as well... improve and extend it like

Code:

grep -A5 ^XYZ.*7789 filename | grep -E "^XYZ|^17345"
XYZNA0000778900Z
17345000012300324000000004000000000000000

There might be leaner, more elegant solutions, though.

This might work but consider this 7789 (item number) will not repeat again in entire file but store number (7345) will definitely occur again in file for other item number. In your solution we are assuming that store record (17345***) will be in 5 lines immediately after matching record of (XYZ*7789*). This may not be the case because the store record I am looking for could be at any line not only within

Code:

grep -A5

. It could be after 10 lines or 20 lines or 50 lines. There are no fixed number of store records after line XYZ.

de facto, it was YOUR solution, adapted.
For any record length, try

Code:

awk '
/^9/                    {L = 0
                        }
$0 ~ "^XYZ.*" PAT1      {L = 1
                         print
                        }
$0 ~ "^1" PAT2 && L 
' PAT1="7789" PAT2="7345" file
XYZNA0000778900Z
17345000012300324000000004000000000000000

Thank you, it works but do you mind explaining what are you doing. It would be helpful to understand. the code.