Extracting parts of a file.

srivat79 · #1 (**permalink**) 05-27-2009

Hello,

I have a XML file as below and i would like to extract all the lines between <JOB & </JOB> for every such occurance. The number of lines between them is not fixed.

Anyways to do this awk?

============
<JOB APR="1" AUG="1" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAY="1" NOV="1" OCT="1" SEP="1" >
<QUANTITATIVE NAME="B2_ADJ" QUANT="1"/>
<QUANTITATIVE NAME="B2_NR" QUANT="1"/>
</JOB>
<JOB APR="1" AUG="1" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAY="1" NOV="1" OCT="1" SEP="1" >
<QUANTITATIVE NAME="B2_ADJ" QUANT="1"/>
<QUANTITATIVE NAME="B2_NR" QUANT="1"/>
</JOB>
==================

zaxxon · #2 (**permalink**) 05-27-2009

sed:

Code:

sed '/^<JOB/,/^\/JOB/!d; /^<\/*JOB/d' infile

awk:

Code:

awk '/^<JOB/,/^\/JOB/ {if ( $0 ~ /^<\/*JOB/ ) {next} else {print}}' infile

ghostdog74 · #3 (**permalink**) 05-27-2009

if you have Python

Code:

#!/usr/bin/env python
f=0
for line in open("file"):
    if "</JOB" in line: f=0;continue
    if "<JOB" in line:
        f=1
        continue
    if f: print line.strip()

output

Code:

# ./test.py
<QUANTITATIVE NAME="B2_ADJ" QUANT="1"/>
<QUANTITATIVE NAME="B2_NR" QUANT="1"/>
<QUANTITATIVE NAME="B2_ADJ" QUANT="1"/>
<QUANTITATIVE NAME="B2_NR" QUANT="1"/>

srivat79 · #4 (**permalink**) 05-27-2009

Thanks guys.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Please help to write a executable script for extracting some parts of a file	iammitra	Shell Programming and Scripting	9	05-13-2009 10:34 AM
How to extract some parts of a file to create some outfile	iammitra	Shell Programming and Scripting	21	05-11-2009 11:06 AM
getting parts of a file	bebop1111116	Shell Programming and Scripting	11	10-09-2006 10:19 AM
filter parts of a big file using awk or sed script	apalex	Shell Programming and Scripting	1	07-25-2005 04:45 PM
cksum parts of a file	crazykelso	UNIX for Dummies Questions & Answers	6	07-30-2002 11:38 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: