Split large xml into mutiple files and with header and footer in file Post: 303027499

Sponsored Content

Top Forums Shell Programming and Scripting Split large xml into mutiple files and with header and footer in file Post 303027499 by Corona688 on Monday 17th of December 2018 10:39:27 AM

12-17-2018

Registered User

Thanks for showing what input you actually have. What output do you actually want?

Code modified to rudic's suggestions:

Code:

BEGIN {
	ORS=""
	OUT="x."
	ROWS=5
	ROWTAG="DOCUMENT"
	FTRTAG="FOOTER"
}

# First pass, remember headers and footers
NR==FNR {
	if(F || TAG == FTRTAG)
	{
		if(!F) {
			FTRSTART=FNR
			F=1
		}
		FTR=FTR RS $1 OFS $2
	}
	else if((!H) && (TAG == ROWTAG))
	{
		HDREND=FNR
		H=1
	}
	else if(!H)	HDR=HDR RS $1 OFS $2
	next
}

# Skip header and footer
(FNR < HDREND) || (FNR >= FTRSTART) { next }

# Close output file once enough DOCUMENT records
((XNR%(ROWS+1)) == 0) {
	if(FILE) {
		print FTR > FILE
		close(FILE);
	}
	FILE=sprintf("%s%04d", OUT,++FILENUM);
	print HDR > FILE
	XNR++
}

{	print RS $0 > FILE	}

CTAG == "DOCUMENT" { XNR++ }

END {	if(FILE) print FTR > FILE }

...but it won't work until I know what tags you're actually using for header and footer. Modify HDRTAG and FTRTAG accordingly.

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to Chop Header and Footer record from input file

Hi, I need to chope the header and footer record from an input file and make a new output file, please let me know how i can do it in unix.thanks.

2. Shell Programming and Scripting

Total of lines w/out header and footer incude for a file

I am trying to get a total number of tapes w/out headers or footers in a ERV file and append it to the file. For some reason I cannot get it to work. Any ideas? #!/bin/sh dat=`date +"%b%d_%Y"` + date +%b%d_%Y dat=Nov16_2006 tapemgr="/export/home/legato/tapemgr/rpts"...

3. Shell Programming and Scripting

Split large file and add header and footer to each file

I have one large file, after every 200 line i have to split the file and the add header and footer to each small file? It is possible to add different header and footer to each file?

4. Shell Programming and Scripting

Split large file and add header and footer to each small files

I have one large file, after every 200 line i have to split the file and the add header and footer to each small file? It is possible to add different header and footer to each file?

5. Shell Programming and Scripting

sort a report file having header and footer

I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer. pls help

6. Shell Programming and Scripting

Add header and footer with record count in footer

This is my file(Target.txt) name|age|locaction abc|23|del xyz|24|mum jkl|25|kol The file should be like this 1|03252012 1|name|age|location 2|abc|23|del 2|xyz|24|mum 2|jkl|25|kol 2|kkk|26|hyd 3|4 Column 1 is row indicator for row 1 and 2, column indicator is 1,for data rows...

7. Shell Programming and Scripting

Removing header or footer from file

Hi Every one, what is the coomand to remove header or footer from a file. Please help me by providing command/syntax to remove header/footer from unix. Thanks in advance for all your support.

8. Shell Programming and Scripting

Is there a way to append both at header and footer of a file

currently I've a file Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('024', '024', 2, sysdate); Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('032', '032', 2, sysdate); ........ is it...

9. UNIX for Dummies Questions & Answers

File Row Line Count without Header Footer

Hi There! I am saving the file count of all files in a directory to an output file using: wc -l * > FileCount.txt I get: 114 G4SXORD 3 G4SXORH 0 G4SXORP 117 total But this count includes header and footer. I want to subtract 2 from the count and get ...

10. UNIX for Dummies Questions & Answers

Eliminate Header and footer from EBCDIC file

Is there any command to eliminate Header and footer from EBCDIC file

LEARN ABOUT LINUX

grub-fstest

GRUB-FSTEST(1)							   User Commands						    GRUB-FSTEST(1)

NAME

       grub-fstest - debug tool for GRUB filesystem drivers

SYNOPSIS

       grub-fstest [OPTION...] IMAGE_PATH COMMANDS

DESCRIPTION

       Debug tool for filesystem driver.

	      Commands:

       blocklist FILE
	      Display blocklist of FILE.

       cmp FILE LOCAL
	      Compare FILE with local file LOCAL.

       cp FILE LOCAL
	      Copy FILE to local file LOCAL.

       crc FILE
	      Get crc32 checksum of FILE.

       hex FILE
	      Hex dump FILE.

       ls PATH
	      List files in PATH.

       -c, --diskcount=N
	      N input files.

       -d, --debug=S
	      Set debug environment variable.

       -n, --length=N
	      Handle N bytes in output file.

       -r, --root=DEVICE_NAME
	      Set root device.

       -s, --skip=N
	      Skip N bytes from output file.

       -v, --verbose
	      Print verbose messages.

       -?, --help
	      give this help list

       --usage
	      give a short usage message

       -V, --version
	      print program version

       Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options.

SEE ALSO

       grub-probe(8)

       The  full  documentation for grub-fstest is maintained as a Texinfo manual.  If the info and grub-fstest programs are properly installed at
       your site, the command

	      info grub-fstest

       should give you access to the complete manual.

grub-fstest (GRUB) 1.99-12ubuntu5				   October 2011 						    GRUB-FSTEST(1)