04-10-2008
In our case as we get very large xml's and xml's being varying every time it may become bit complex to import the data to database and as i only need 2 or 3 tag values from the whole xml i dont find the need to import whole data to database. I can fetch those by using SED or awk Scripts.
please suggest me the way I can write the fetched data to a file in 1 line with comma separated using unix script(ksh or sh).
Input sample xml file:
<gDSNError>
<errorCode>U007</errorCode>
<errorDescription>00093624998419|BEST_BUY_LONG_DESCRIPTION|PDQ Import - The value coded against this attribute exceeds the maximum field length. Please amend & resend.</errorDescription>
<errorDateTime>2008-02-26T09:04:11.728-00:00</errorDateTime>
</gDSNError>
The output should be something like as below:
U007, 00093624998419|BEST_BUY_LONG_DESCRIPTION|PDQ Import - The value coded against this attribute exceeds the maximum field length. Please amend & resend, 2008-02-26T09:04:11.728-00:00
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to know the way. I have got parsing down some nodes. But I was unable to get the child node perfectly. If you have code please send it. It will be very useful for me. (0 Replies)
Discussion started by: girigopal
0 Replies
2. Shell Programming and Scripting
Hi,
I need to parse the following XML data enclosed in <a> </a> XML tag using shell script.
<X>
.....
</X>
<a>
<b>
<c>data1</c>
<c>data2</c>
</b>
<d>
<c>data3</c>
</d>
</a>
<XX>
...
</XX> (5 Replies)
Discussion started by: viki
5 Replies
3. Shell Programming and Scripting
Hi! I'm just new here and don't know much about shell scripting. I just want to ask for help in creating a shell script that will parse a string or value of the status in the xml file. Please sample xml file below. Can you please help me create a simple script to get the value of status? Also it... (46 Replies)
Discussion started by: ayhanne
46 Replies
4. Shell Programming and Scripting
How can I parse file containing xml ?
I am sure that its best to use perl - but my perl is not very good - can someone help?
Example below contents of file containing the xml - I basically want to parse the file and have each field contained in a variable..
ie. I want to store the account... (14 Replies)
Discussion started by: frustrated1
14 Replies
5. Shell Programming and Scripting
I am completely new to bash scripting and now need to write a bash script that would parse a XML file and take out values from specific tags.
I tried using xsltproc, xml_grep commands. But the issue is that the XML i am trying to parse is not UTF 8. so those commands are unable to parse my XML's... (4 Replies)
Discussion started by: shivashankar.g
4 Replies
6. Shell Programming and Scripting
Hi Everybody,
I have an XML file containing some data and i want to extract it, but the specific issue in my file is that the data is repeated some times like the following example :
<section1>
<subsection1>
X=...
Y=...
Z=...
<\subsection1>
<subsection2>
X=...
Y=...
Z=...... (2 Replies)
Discussion started by: yassine
2 Replies
7. Shell Programming and Scripting
Hello all,
Given the following extract from a xml file with multiple <JOB> .... </JOB> entries
<JOB
APPLICATION="APP"
APR="0"
AUG="0"
AUTHOR="AUT"
AUTOARCH="0"
CMDLINE="/tmp/test1 %%var"
CONFIRM="1"
CREATION_DATE="20100430"
CREATION_TIME="130739"
... (2 Replies)
Discussion started by: cabrao
2 Replies
8. Shell Programming and Scripting
Dear Members,
I have a table in Oracle DB and one of its column name is INFO which has data in text format which we need to fetch in a script and create an xml file of a new table from the input.
The contents of a single cell of INFO column is like:
Area:app - aam
Clean Up Criteria:... (0 Replies)
Discussion started by: Yoodit
0 Replies
9. UNIX for Dummies Questions & Answers
HI Guys,
Input .XML
<xn:MeContext id="L0307">
<xn:ManagedElement id="1">
<xn:VsDataContainer id="1">
<xn:attributes>
<xn:vsDataType>vsDataENodeBFunction</xn:vsDataType>
... (3 Replies)
Discussion started by: pareshkp
3 Replies
10. Shell Programming and Scripting
I am trying to create a shell script that will parse an xml file (file attached).
awk '/Id v=/ { print }' Test.xml | sed 's!<Id v=\"\(.*\)\"/>!\1!' > output.txt
An output.txt file is created but it is empty. It should contain the value 222159 in it. Thanks. (7 Replies)
Discussion started by: cmccabe
7 Replies
LEARN ABOUT DEBIAN
stag-filter
STAG-FILTER(1p) User Contributed Perl Documentation STAG-FILTER(1p)
NAME
stag-filter - filters a stag file (xml, itext, sxpr) for nodes of interest
SYNOPSIS
stag-filter person -q name=fred file1.xml
stag-filter person 'sub {shift->get_name =~ /^A*/}' file1.xml
stag-filter -p My::Foo -w sxpr record 'sub{..}' file2
USAGE
stag-filter [-p|parser PARSER] [-w|writer WRITER] NODE -q tag=val FILE
stag-filter [-p|parser PARSER] [-w|writer WRITER] NODE SUB FILE
stag-filter [-p|parser PARSER] [-w|writer WRITER] NODE -f PERLFILE FILE
DESCRIPTION
parsers an input file using the specified parser (which may be a built in stag parser, such as xml) and filters the resulting stag tree
according to a user-supplied subroutine, writing out only the nodes/elements that pass the test.
the parser is event based, so it should be able to handle large files (although if the node you parse is large, it will take up more
memory)
ARGUMENTS
-p|parser FORMAT
FORMAT is one of xml, sxpr or itext, or the name of a perl module
xml assumed as default
-w|writer FORMAT
FORMAT is one of xml, sxpr or itext, or the name of a perl module
-c|count
prints the number of nodes that pass the test
-filterfile|f
a file containing a perl subroutine (in place of the SUB argument)
-q|query TAG1=VAL1 -q|query TAG2=VAL2 ... -q|query TAGN=VALN
filters based on the field TAG
other operators can be used too - eg <, <=, etc
multiple q arguments can be passed in
for more complex operations, pass in your own subroutine, see below
SUB a perl subroutine. this subroutine is evaluated evry time NODE is encountered - the stag object for NODE is passed into the subroutine.
if the subroutine passes, the node will be passed to the writer for display
NODE
the name of the node/element we are filtering on
FILE
the file to be parser. If no parser option is supplied, this is assumed to a be a stag compatible syntax (xml, sxpr or itext);
otherwise you should parse in a parser name or a parser module that throws stag events
SEE ALSO
Data::Stag
perl v5.10.0 2008-12-23 STAG-FILTER(1p)