Shell Programming and Scripting

Hello

I have a requirement where i need to split the Input fixed width file which contains multiple invoices into multiple files with 2 invoices per file.

Each invoice can be identified by its first line's second character which is "H" and sixth character is " " space and the invoice would end when the invoices last line's second character is "T" and sixth character is "M" and the next line would be second invoice.

I have pasted the model data which contains 4 invoices. I need to split the input data into two files with each file having 2 invoices each.

Each invoice can contain any noof transcations.

4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001
4T999M000 002
4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001
4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001
4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001

The first file should contain 2 invoices like this

4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001
4T999M000 002
4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001

The second file should contain 2 invoices like this


4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001
4H000 000 000
4H000A000 000
4L003M002 000
4L004 000 000
4L004M001 000
4L004M002 000
4T999 000 000
4T999M000 001

Need help on this. Appreciate

Thanks

Basically each invoice's second character of the first line is "H" and sixth character is " " (space)

The first invoice in your example has two lines containing .T...M at the end, is this correct?

Code:

4T999M000 001
4T999M000 002

Actually, it doesn't matter.
Use gawk, nawk or /usr/xpg4/bin/awk on Solaris:

Code:

awk 'NR == 1 || /.H... / && _++ { 
  fn && close(fn)
  fn = "part_" ++c; _ = 0 
  }
{ print > fn }' infile

You can remove the NR == 1 part if you're sure that the first line matches the .H... pattern.

Yes

Thats right.Each invoice might contain 1 line 2 lines or 3 lines etc

If it contains 1 line it would be
4T999M000 001

if it contians 2 lines it would be

4T999M000 001
4T999M000 002

if it contians 3 lines it would be

4T999M000 001
4T999M000 002
4T999M000 003

Hello

The script is not working.

this is the error

Syntax Error The source line is 1.
The error context is
<<< NR == 1 || /.H... / && _++ { >>>
awk: 0602-502 The statement cannot be correctly parsed. The source line is 1.
Syntax Error The source line is 2.


The sample data is only for four invoices. The input data might contain any number of invoices but the requirement is to produce 2 invoices in a file each.

thanks

I am using AIX