Shell Programming and Scripting

Hi,

I had a scenario need a help as I am new to this. I have a xml file employee.xml with the below content.

<Organisation><employee>xxx</employee><employee>yyy</employee><employee>zzz</employee></Organisation>

I want to split the file into multiple file as below. Is there a specifice way to do this?

employee1.xml with content --> <Organisation><employee>1</employee></Organisation>
employee2.xml with content --> <Organisation><employee>2</employee></Organisation>
employee3.xml with content --> <Organisation><employee>3</employee></Organisation>

Try this awk...

Code:

awk 'BEGIN {
   FS="<(/)?employee>"
    h="<Organisation><employee>"
    t="</employee></Organisation>"
} {
   for (i=1;i<=NF;i++)
      if ($i ~ "[0-9]+")
         printf("%s%s%s\n", h,$i,t) > "emp"$i".xml"
}' file

Is that what the XML file really looks like, or did you pretty it up for posting?

[edit] slightly misread, working on it

Code:

nawk -v RS="</?Organisation>" -v FS="<employee>" '{ for(N=1; N<=NF; N++) if($N ~ /<[/]/) print FS $N > "employee"++C".xml" }' org.xml

If you don't have nawk, try gawk

Thanks for the Reply friends... :-)
That's a sample file. I have to deal with 200 mb file. I will try out the suggestion.. :-)

Note: in POSIX awk, RS can only be a single character, not a regular expression. Otherwise:

Try:

Code:

awk '{if(/^employee/){f=$1 $2 ".xml";print RS org FS RS $1 FS $2 RS "/" $1 FS RS "/" org FS>>f;close(f)}else if(/^[^\/]/)org=$1}' RS=\< FS=\> infile