How To get the data from a tag in XML File - Page 2

Christoph Spohr · #8 (**permalink**) 12-04-2008

@samshaw:

Perhaps you should open your own thread?

For a start try this:

Code:

HOSTS=( $(sed -n 's/^<hostAddress>\([^<]*\).*/\1/p' xfile) )

It will write the results of the sed command into an array HOSTS.

Code:

echo ${HOSTS[1]} etc.

Will give you the values.

Sed is best learned by example. There are many pages with sed one liners.
This one here does the following:

-n only print if asked to print a line
's/ substitute
^<host every line starting with host
\([^<]*\) every character except a "<" and save what you have found in "\1"
.* the rest of the line
/\1/ substitute by what we have just save in \1
p' print this line.

The command does two tasks at a time: a) it finds all lines starting with
host..., b) it extracts the value between the tags.

HTH Chris

naughty21 · #9 (**permalink**) 12-04-2008

Quote:

Originally Posted by dennis.jacob

Try this quick approch:

Code:

sed 's/>/\n>/g' filename | sed 's/>\([A-Za-z0-9]*@[A-Za-z0-9]*\.[A-Za-z0-9]*\)<.*/\1/' | sed '/@/!d'

Is this works for ksh ? ... Im not getting any output

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Validating XSL sheet data in Unix Data file	ravijunghare	UNIX for Dummies Questions & Answers	1	11-07-2008 09:32 AM
Need Help for Adding Three new columns in existing file from fatching data from file	Sandeep_Malik	Shell Programming and Scripting	36	09-17-2008 05:12 PM
Extracting data from text file based on configuration set in config file	suparnbector	Shell Programming and Scripting	3	08-10-2007 02:25 AM
Post Shell programming: Question about source a file and read data from the file	ccwq	Shell Programming and Scripting	3	08-04-2007 10:28 PM
Using loop reading a file,retrieving data from data base.	Sonu4lov	Shell Programming and Scripting	1	01-19-2007 03: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: