Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

extract a pattern from a xml file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extract a pattern from a xml file
# 1  
Old 10-10-2012
extract a pattern from a xml file
Hello All,

I want to write a shell script for extracting a content from a xml file

the xml file looks like this:
HTML Code:
[CODE]<Variable name="moreAxleInfo">

							<type>

								<Table>

									<type>

										<NamedType>

											<type>

												<TypeRef name="LMI::LMI_EditBoxStatus_t"/>

											</type>

										</NamedType>

									</type>

									<size>

										<IdExpression>

											<path>

												<ConstVarRef name="LMI::NOOFNUMBOXAXLE"/>

											</path>

										</IdExpression>

									</size>

								</Table>

							</type>

							<pragmas>

								<ed:Variable oid="!ed/22db66/6665/464/4ed4be3e2af6"/>

							</pragmas>

						</Variable>[/CODE]

when the Variable name=m/M then just extract the variable name.
# 2  
Old 10-10-2012
Like this?
Code:
sed -n '/<Variable name="[mM]/,/<\/Variable>/{
s/.*=\("[^"]*"\).*/\1/
t prnt
b
:prnt
p
}' file

# 3  
Old 10-10-2012
trying to execute the same but it is throwing this error:
sed -n '/<Variable name="[mM]/,/<\/Variable>/{s/.*=\("[^"]*"\).*/\1/t prntb Smilierntp}' file

throwing the below error:
sed: -e expression #1, char 62: unknown option to `s'
# 4  
Old 10-10-2012
Execute the command as I have given. Don't remove the line-breaks.
# 5  
Old 10-10-2012
@elixir_sinari: your command will output all double quoted strings in that file fragment. Omiting the end of the address range (,/<\/Variable>/) will output the variable name only, as desired.
# 6  
Old 10-10-2012
Thanks for the information its working......

Let me know what i shall use if i want to extract all the contents which starts with a capital letter like:
<Variable name="moreAxleInfo">...it shall not be extracted
<Variable name="MoreAxleInfo">....it shall be extracted....
<Variable name="JklAxleInfo">........it shall be extracted...
<Variable name="oklAxleInfo">...it shall not be extracted
# 7  
Old 10-10-2012
RudiC, the OP's requirement was not very clear to me. I assumed that he wants only those strings which he has highlighted in a different colour.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract a value from an xml file

I have this XML file format and all in one line: Fri Dec 23 00:14:52 2016 Logged Message:689|<?xml version="1.0" encoding="UTF-8"?><PORT_RESPONSE><HEADER><ORIGINATOR>XMG</ORIGINATOR><DESTINAT... (16 Replies)
Discussion started by: mrn6430
16 Replies

2. Shell Programming and Scripting

Extract a particular xml only from an xml jar file

Hi..need help on how to extract a particular xml file only from an xml jar file... thanks! (2 Replies)
Discussion started by: qwerty000
2 Replies

3. Shell Programming and Scripting

Get extract text from xml file

Hi Collegue, i have a file say a.xml. it has contents <bpelFault><faultType>1</faultType><genericSystemFault xmlns=""><part name="payload"><v2:Fault... (10 Replies)
Discussion started by: Jewel
10 Replies

4. Shell Programming and Scripting

Extract data from XML file

Hi , I have input file as XML. following are input data #complex.xml <?xml version="1.0" encoding="UTF-8"?> <TEST_doc xmlns="http://www.w3.org/2001/XMLSchema-instance"> <ENTRY uid="123456"> <protein> <name>PROT001</name> <organism>Human</organism> ... (1 Reply)
Discussion started by: mohan sharma
1 Replies

5. Shell Programming and Scripting

Extract XML tag value from file

Hello, Hope you are doing fine. I have an log file which looks like as follows: Some junk text1 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: Some jun text 2 Date: Thu Mar 15 13:38:46 CDT 2012 DATA SENT SUCCESSFULL: ... (3 Replies)
Discussion started by: srattani
3 Replies

6. Shell Programming and Scripting

Extract a pattern from xml file

Hi, In a single line I have the below xml content <lst name="responseHeader"><int name="status">0</int><int name="QTime">1</int></lst><lst name="status"><lst name=""><str name="name"/><str name="instanceDir">/var/www/search/current/Search/solr/./</str><str... (5 Replies)
Discussion started by: ashokvpp
5 Replies

7. Shell Programming and Scripting

Extract XML content from a file

310439 2012-01-11 03:44:42,291 INFO PutServlet:? - Content of the Message is:="1.0" encoding="UTF-8"?><ESP_SSIA_ACC_FEED> 310440 <BATCH_ID>12345678519</BATCH_ID> 310441 <UID>3498748823</UID> 310442 <FEED_TYPE>FULL</FEED_TYPE> 310443 <MART_NAME>SSIA_DM_TRANSACTIONS</MART_NAME> 310444... (11 Replies)
Discussion started by: arukuku
11 Replies

8. UNIX for Dummies Questions & Answers

Extract Field Value from XML file

Hi, Within a UNIX shell script I need to extract a value from an XML field. The field will contain different values but will always be 6 digits in length. E.g.: <provider-id>999999</provider-id> I've tried various ways but no luck. Any ideas how I might get the provider id (in this case... (2 Replies)
Discussion started by: pnclayt11
2 Replies

9. Shell Programming and Scripting

extract a number within an xml file

Hi Everyone, I have an sh script that I am working on and I have run into a little snag that I am hoping someone here can assist me with. I am using wget to retrieve an xml file from thetvdb.com. This part works ok but what I need to be able to do is extract the series ID # from the xml and put... (10 Replies)
Discussion started by: tret
10 Replies

10. Shell Programming and Scripting

How to extract text from xml file

I have some xml files that got created by exporting a website from RedDot. I would like to extract the cost, course number, description, and meeting information. <?xml version="1.0" encoding="UTF-16" standalone="yes" ?> - <PAG PAG0="3AE6FCFD86D34896A82FCA3B7B76FF90" PAG3="525312"... (3 Replies)
Discussion started by: chrisf
3 Replies
Login or Register to Ask a Question