Need Help in extracting data from XML File


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need Help in extracting data from XML File
# 8  
Old 12-23-2014
Yes, this one works. Thanks a lot, appreciate it.

Smilie

Code:
==> cat scr6.ksh
sed -n "/rs:data/,/\\rs:data/{//d; s/[^'=]*=//g; s/''/','/g; s/[^']*$//;p;}" Hospital.xml


==> ./scr6.ksh
'John Doe','XYZ Hospital','Heart Health'
'Jane Doe','XYZ Hospital','Maternity'


Last edited by Scrutinizer; 12-23-2014 at 01:10 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extracting data between continuous non empty xml tags

Hi, I need help in extracting only the phone numbers between the continuous non empty xml tags in unix. I searched through a lot of forum but i did not get exact result for my query. Please help Given below is the sample pipe delimited file. I have a lot of tags before and after... (6 Replies)
Discussion started by: zen01234
6 Replies

2. Shell Programming and Scripting

Extracting the tag name from an xml file

Hi, My requirement is something like this, I have a xml file that contains some tags and nested tags, <n:tag_name1> <n:sub_tag1>val1</n:sub_tag1> <n:sub_tag2>val2</n:sub_tag2> </n:tag_name1> <n:tag_name2> <n:sub_tag1>value</n:sub_tag1> ... (6 Replies)
Discussion started by: Little
6 Replies

3. Shell Programming and Scripting

Reading XML file and extracting value

Dear All, I am reading one XML file to extract value from the particular tag:- Sample xml is below:- <KeyValuePairs> <Key>TestString</Key> <Value>Test12_Pollings</Value> </KeyValuePairs> I want to read the value for the KEY tag and there will be multiple key tags :- awk... (4 Replies)
Discussion started by: sharsour
4 Replies

4. Shell Programming and Scripting

Extracting content from xml file

Hello All, Hope you are doing well!!!!! I have a small code in the below format in xml file: <UML:ModelElement.taggedValue> <UML:TaggedValue tag="documentation" value="This sequence&#xA;&#xA;HLD_EA_0001X&#xA;HLD_DOORS_002X"/> <UML:TaggedValue tag="documentation" value="This... (11 Replies)
Discussion started by: suvendu4urs
11 Replies

5. Shell Programming and Scripting

Need help in extracting data from xml file

Hello, This is my first post in here, so excuse me if I sound too noob here! I need to extract the path "/apps/mp/installedApps/V61/HRO/hrms_01698_A_qa.ear" from the below xml extract. The path will always appear with the key "binariesURL" <deployedObject... (6 Replies)
Discussion started by: abhishek2386
6 Replies

6. UNIX for Dummies Questions & Answers

Extracting data from an xml file

Hello, Please can someone assist. I have the following xml file: <?xml version="1.0" encoding="utf-8" ?> - <PUTTRIGGER xmlns:xsd="http://www.test.org/2001/XMLSchema" xmlns:xsi="http://www.test.org/2001/XMLSchema-instance" APPLICATIONNUMBER="0501160" ACCOUNTNAME="Mrs S Test"... (15 Replies)
Discussion started by: Dolph
15 Replies

7. UNIX for Dummies Questions & Answers

Extracting values from an XML file

Hello People, I have an xml file from which I need to extract the values of the parameters using UNIX shell commands. Ex : Input is like : <Name>Roger</Name> or <Address>MI</Address> I need the output as just : Roger or MI with the tags removed. Please help. (1 Reply)
Discussion started by: sushant172
1 Replies

8. Shell Programming and Scripting

Extracting a part of XML File

Hi Guys, I have a very large XML feed (2.7 MB) which crashes the server at the time of parsing. Now to reduce the load on the server I have a cron job running every 5 min.'s. This job will get the file from the feed host and keep it in the local machine. This does not solve the problem as... (9 Replies)
Discussion started by: shridhard
9 Replies

9. Shell Programming and Scripting

Extracting Data from xml file

Hi ppl out there... Can anyone help me with the shell script to extract data from an xml file. My xml file looks like : - <servlet> <servlet-name>FrontServlet</servlet-name> <display-name>FrontServlet</display-name> ... (3 Replies)
Discussion started by: nishana
3 Replies

10. Shell Programming and Scripting

extracting XML file using sed

Hello folks I want to extract data between certain tag in XML file using 'sed' <xml> ......... .......... <one>XXXXXXXXXXXXXXXXXXXX</one> ...... Anyone ?Thank you (7 Replies)
Discussion started by: pujansrt
7 Replies
Login or Register to Ask a Question
create-branching-keyboard(1)					   User Commands				      create-branching-keyboard(1)

NAME
create-branching-keyboard - create branching keyboards for GOK SYNOPSIS
create-branching-keyboard [--usage] infile [n-desired-rows] DESCRIPTION
create-branching-keyboard takes an input data file and creates a family of branching keyboard XML files in the format that GOK expects. Given an input file named test.data, create-branching-keyboard creates test.data.kbd, which in turn refers to a family of *.kbd files that are created based on data in the input file. OPTIONS
The following options are supported: --usage Display usage information. OPERANDS
The following operands are supported: infile The name of the input file. n-desired-rows If specified, create-branching-keyboard attempts to create keyboards with the specified number of rows. The recommended values are between 2 and 6. EXTENDED DESCRIPTION
create-branching-keyboard can be used to create families of branching keyboards from UTF-8 input files. The format of the input files is as follows: o Lines beginning with '#' are ignored. o The rest of the input file consists of consecutive pairs of lines. The first line of a pair is typically ignored, but should serve as a UTF-8 label describing the "primary key" in the next line. The second line of the pair consists of a single UTF-8 character followed by a ':' color delimiter, and a string of UTF-8 characters to which the initial character may branch. The resulting XML file, after processing, defines .kbd files such that each prefix 'primary key' forms a key on the GOK keyboard whose label is the "primary key" UTF-8 character, and which branches to a keyboard consisting of the following UTF-8 characters, one per key. create-branching-keyboard is particularly useful in creating branching keyboards for ideographic languages. For instance, the primary key for a given line may consist of the UTF-8 character for a 'radical' such as hng. EXAMPLES
Example 1: Creating Branching Keyboards From a File Called test.data example% create-branching-keyboard test.data EXIT STATUS
The following exit values are returned: 0 Application exited successfully >0 Application exited with failure FILES
The following files are used by this application: /usr/bin/create-branchinExecutable to create branching keyboards for GOK ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-a11y-gok-share | | | | | |SUNWgnome-a11y-gok | +-----------------------------+-----------------------------+ |Interface stability |External | +-----------------------------+-----------------------------+ SEE ALSO
Latest version of the GNOME Desktop User Guide for your platform. gok(1) NOTES
The create-branching-keyboard utility is experimental and unsupported. Written by Bill Haneman, Sun Microsystems Inc., 2004. SunOS 5.10 7 Sep 2004 create-branching-keyboard(1)