Shell Programming and Scripting

Hi All,

I have more than half million lines of XML file , wanted to split in four files in a such a way that top 7 lines should be present in each file on top and bottom line of should be present in each file at bottom.

from the 8th line actual record starts and each record contains 15 lines means from 8th to 22nd line is the first record of the file.
so the total number of actual records are varying each time.

wanted to divide this actual record in four chunks and each chunks should move to new four files respectively below to the top 7 and above the bottom line.

say...

Code:

cat ABCD.xml |wc -l
 690728
Actual Record lines = 690728 -[top 7] -[bottom1]= 690720
690720/15 = Actual Record = 46048

then
46048/4 = 11512 or [if it is not exactly divisible then the remainder record should move to the last ]


so first 11512 record move to ABCD_part1.xml
second 11512 will move to ABCD_part2.xml
third 11512 will move move to ABCD_part3.xml
Fourth/remaining records 11512 will move to to ABCD_part4.xml

Please help on this .

You already gave math.
You can use

Code:

sed -n 'x,yp' file

where x is the starting line number and y is the ending.

CLX,
thnx, wanted to make it generalized the scenario the math i have given you that is the example records may vary for each new file.

any hint in shell scripting to process the below request ?

For any number of records, below code will create 4 parts with 7 lines of header and a trailer in each file
But, make sure to provide the file name twice as in the code

Code:

awk '
BEGIN{n = 1;
  prt = 4}
NR == FNR {
  if(FNR <= 7)
    {hd = (hd == "") ? $0 : (hd "\n" $0)}
  else
    {tr = $0;
    n = FNR}
  next}
FNR == 1 {fc = (n - 8) / prt;
  c = 0;
  next}
FNR > 7 && FNR <= (fc * c + 7) && FNR < n {
  print $0 > "ABCD_part" c ".xml";
  next}
FNR > (fc * c + 7) && FNR < n {
  if(FNR != 8)
    {print tr > "ABCD_part" c ".xml"};
    c++;
    print hd > "ABCD_part" c ".xml"
 print $0 > "ABCD_part" c ".xml"}
END {print tr > "ABCD_part" c ".xml"}' ABCD.xml ABCD.xml

Thank a lot ! it is as expected.

Only one thing is that in original file on seventh line we have a tag like

Code:

<TotalRecord>46048</TotalRecord>

and in each file it is replicating the same even though the records are 1/4th of the original means in each file the above tag is to be like 46048/4 =11512

part1

Code:

<TotalRecord>11512</TotalRecord>

part2

Code:

<TotalRecord>11512</TotalRecord>

......so on..

Do you have a blank line at the beginning of the file or anywhere before 7 lines