Visit Our UNIX and Linux User Community


Parse a string in XML file using shell script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parse a string in XML file using shell script
# 43  
Old 12-04-2007
Sorry for not being correct the first time.

I have made the modifications

( Its not tested )

Hopefully, this should work now ! Smilie

Code:
#using a variable to keep track of the previously processed file
my $prev = "";

open(OUTPUT, ">>", "output.txt");

while (1) {

#Make it as ever running process

$file = `ls -lrt | awk '/SMSCDR/ { before = curr; curr = \$9 }END{ print before }'`; 

#select the file which is last but one
#include one more check, 

whether we are attempting to process an already processed file or not
next if ( $file =~ /tmp/ || $file eq $prev );

#if its the 'tmp' file dumper process is still active so don't process it else continue processing

open (FILE, "<", $file) or die  "Unable to open file $file <$!> \n";

#open the file and start processing

while(<FILE>) {
chomp;
my @arr = split(/></);
foreach (@arr) {
if( /xml version/ ) {
$c++;
print OUTPUT "\n";
}
if( />/ && /</ ) {
if( $c == 1 ) {
s/(.*)>(.*)<.*$/1|2/;
my($tmp1, $tmp2) = split(/|/);
$data .= (" " . $tmp2);
printf OUTPUT "%s ", $tmp1;
}
else {
s/(.*)>(.*)<.*$/2/;
printf OUTPUT "%s ", $_;
}
}
}
print OUTPUT "\n";
print OUTPUT "$data\n" if( /xml version/i );
}

close (FILE);

#Assign the current processed file to the prev variable, 
#so that previously processed file is stored in prev
$prev = $file;

#continue with while loop, by this time dumper process might have completed and next file ready for processing
}

close(OUTPUT);

exit 0;

# 44  
Old 12-12-2007
Parse a string in XML file using shell script

Hi Matrixmadhan,

Sorry for the late reply! I'm just busy the past few days with other work stuff. The script is working now! You're such a big help! Without you I won't be able to do it. Hope I can still ask for help from you. Thanks for all the patience. Smilie
# 45  
Old 12-14-2007
Power Parse String in XML file

Hello All,

I am new to this and I need to parse an XML file.

Here's the XML Input File:
<Report version="1.2">
<summary fatals="0" testcases="1" expected_fails="0" unexpected_passes="0" warnings="9" tests="21" errors="0" fails="1" passes="20" />
<testresult line="../shared/scripts/addElement.js:573" message="Add Network Element [ Tampines ] successfully created" result="PASS" time="2007-12-13T16:23:47" />
</Report version>

The expected output should be:
Report

summary fatals=0 testcases=1 expected_fails=0 unexpected_passes=0 warnings=9 tests=21 errors=0 fails=1 passes=20

PASS -- Add Network Element [ Tampines ] successfully created


Can you help me with the script to have the output?


Thanks in advance.
racbern
# 46  
Old 12-18-2007
This should be a new thread ! Smilie
# 47  
Old 01-09-2008
Hi Matrixmadhan,

I'm working on another script. Basically it's somehow the same with the previous xml but the problem is some of the parameters have space between > <. Please see sample below. Hope you can help me again. Thanks again in advance!

Code:
<?xml version="1.0"?><message><sbr version="1.0"><appid>Messaging</appid><custid>adm_root_provider</custid><callid>032147109</callid> <trmid>5</trmid><portid>16</portid> <callstart>12/11/2007 15:16:46</callstart><callend>12/11/2007 15:17:30</callend><chstart>12/11/2007 15:16:47</chstart><chend>12/11/2007 15:17:30</chend><type>1</type><status>0</status><called>
</called><callreturnused></callreturnused><nonsubused>0</nonsubused></sbr></message><?xml version="1.0"?>

Script that we used before:

Code:
#! /usr/local/bin/perl 

my $c = 0;

open(OUTPUT, ">>", "result.txt");
#chomp(@inputfayl = `cat file.txt`);
chomp(@inputfayl = `ls -lrt | awk '/SMSR/ { before = curr; curr = \$9 }END{ print before }'`);
#system("echo $inputfayl >> newfile.txt");
# if (compare("newfile.txt","oldfile.txt") == 0) {
   while (<@inputfayl>) {
      if (/SMSR/) {
        $inputfayl=$_;
        system("echo $inputfayl >> newfile.txt");
          use File::Compare;
           if (compare("newfile.txt","oldfile.txt") == 1) {
          print OUTPUT "$inputfayl ##########################################################################################\n";
          &processi; 
      }
      else {
      print "wala";
      system("rm newfile.txt");

    }
    }
}
sub processi { 
open inputfayl or die "Cannot open file for read :$!";

while(<inputfayl>) {
  chomp;
    my @arr = split(/></);
    foreach (@arr) {
    if( /xml version/ ) {
      $c++;
      print OUTPUT "\n";
    }
    if( />/ && /</ ) {
      if( $c == 1 ) {
        s/(.*)>(.*)<.*$/\1|\2/;
        my($tmp1, $tmp2) = split(/\|/);
        $data .= (" " . $tmp2);
        printf OUTPUT "%s ", $tmp1;
      }
      else {
        s/(.*)>(.*)<.*$/\2/;
        printf OUTPUT "%s ", $_;
      }
    }
  }
  print OUTPUT "\n";
  print OUTPUT "$data\n" if( /xml version/i );
}

close inputfayl;

system("rm oldfile.txt");
system("mv newfile.txt oldfile.txt");
#exit 0
}
exit 0


Previous Thread | Next Thread
Test Your Knowledge in Computers #642
Difficulty: Easy
The first full release of NeXTSTEP 1.0 shipped on September 18, 1988.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parse xml in shell script and extract records with specific condition

Hi I have xml file with multiple records and would like to extract records from xml with specific condition if specific tag is present extract entire row otherwise skip . <logentry revision="21510"> <author>mantest</author> <date>2015-02-27</date> <QC_ID>334566</QC_ID>... (12 Replies)
Discussion started by: madankumar.t@hp
12 Replies

2. Shell Programming and Scripting

Using shell command need to parse multiple nested tag value of a XML file

I have this XML file - <gp> <mms>1110012</mms> <tg>988</tg> <mm>LongTime</mm> <lv> <lkid>StartEle=ONE, Desti = Motion</lkid> <kk>12</kk> </lv> <lv> <lkid>StartEle=ONE, Source = Velocity</lkid> <kk>2</kk> </lv> <lv> ... (3 Replies)
Discussion started by: NeedASolution
3 Replies

3. Shell Programming and Scripting

How to Parse the XML data along with the URL in Shell Script?

Hi, Can anybody help to solve this. I want to parse some xmldata along with the URL in the Shell. I'm calling the URL via the curl command Given below is my shell script file export... (7 Replies)
Discussion started by: Megala
7 Replies

4. Shell Programming and Scripting

How to parse xml file in variable-string?

In the wake of the post: how-parse-following-xml-file Thank you for the very useful chakrapani response 302355585-post4 ! A close question. How to pass a file to xmllint in variable? For example, let it be: NEARLY_FILE='<?xml version="1.0" encoding="iso-8859-1"?><html><set label="09/07/29"... (0 Replies)
Discussion started by: OleM2k
0 Replies

5. Shell Programming and Scripting

Shell script (not Perl) to parse xml with awk

Hi, I have to make an script according to these: - I have couples of files like: xxxxxxxxxxxxx.csv xxxxxxxxxxxxx_desc.xml - every xml file has diferent fields, but keeps this format: ........ <defaultName>2011-02-25T16:43:43.582Z</defaultName> ........... (2 Replies)
Discussion started by: Pluff
2 Replies

6. Shell Programming and Scripting

Parse XML file in shell script

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

regex/shell script to Parse through XML Records

Hi All, I have been working on something that doesn't seem to have a clear regex solution and I just wanted to run it by everyone to see if I could get some insight into the method of solving this problem. I have a flat text file that contains billing records for users, however the records... (5 Replies)
Discussion started by: Jerrad
5 Replies

8. Shell Programming and Scripting

Parse XML file into CSV with shell?

Hi, It's been a few years since college when I did stuff like this all the time. Can someone help me figure out how to best tackle this problem? I need to parse a file full of entries that look like this: <eq action="A" sectyType="0" symbol="PGR" exch="CA" curr="VEF" sess="NORM"... (7 Replies)
Discussion started by: Pcushing
7 Replies

9. Shell Programming and Scripting

Need help in creating a Unix Script to parse xml file

Hi All, My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
Discussion started by: Anil.Wmg
10 Replies

10. Shell Programming and Scripting

Parse String in XML file

Hello All, I am new to this and I need to parse an XML file. Here's the XML Input File: <Report version="1.2"> <summary fatals="0" testcases="1" expected_fails="0" unexpected_passes="0" warnings="9" tests="21" errors="0" fails="1" passes="20" /> <testresult... (4 Replies)
Discussion started by: racbern
4 Replies

Featured Tech Videos