so I fitered out from that big XML with required fields to make out this layout, but not able to proceed further to make layout like this .
So after filter from the big XML, the new xml having data looks like below,
As I already stated this xml is the filter out xml from original one(have header and footer) just to represent the layout.
vague idea:
Code:
1 remove all member items i.e. AllMember
2 in this requirement the headers of lyout are fixed like TOTAL+CB,CB+FX,CS,IR, TOTAL
3 all I need to find out consequent items falling under these mentioned header
let say for array TOTAL+CB there are two items as DMFXNY, EMSGFX
TOTAL+CB
DMFXNY
TOTAL+CB
EMSGFX
similarly for CB+FX there are four items CB/DMFXNY ,CB/EMSGFX, FX/DMFXNY and FX/EMSGFX
CB+FX
CB
DMFXNY
CB+FX
CB
EMSGFX
CB+FX
FX
DMFXNY
CB+FX
FX
EMSGFX
this is just vague idea, if you have better thought then please share?
---------- Post updated at 06:27 AM ---------- Previous update was at 04:30 AM ----------
now I sort out some more fields as per above requirement , now My file looks like as below , let's say I have a file like below
Code:
TOTAL+CB
DMFXNY
TOTAL+CB
EMSGFX
CB+FX
CB
DMFXNY
CB+FX
CB
EMSGFX
CB+FX
FX
DMFXNY
CB+FX
FX
EMSGFX
CS
DMFXNY
CS
EMSGFX
IR
DMFXNY
IR
EMSGFX
TOTAL
DMFXNY
TOTAL
EMSGFX
and now need to customise this file to look as below, so can anyone help me , how to ??
TOTAL+CB
DMFXNY
TOTAL+CB
EMSGFX
CB+FX
CB
DMFXNY
CB+FX
CB
EMSGFX
CB+FX
FX
DMFXNY
CB+FX
FX
EMSGFX
CS
DMFXNY
CS
EMSGFX
IR
DMFXNY
IR
EMSGFX
TOTAL
DMFXNY
TOTAL
EMSGFX
script.awk
========
#! /usr/bin/awk
{
gsub(/item|\<|\>|\//,"");
if ( $0 !~ /AllMember/ )
{
if( NR != 1 )
{
a=a"|"$0;
}
else
{
a=$0;
}
}
}
END{
split(a,out,"|");
c=gsub(/\|/,"",a);
for(i=1;i<=c;i++)
{
key=out[i];
if(res[key]=="")
{
res[key]=out[i+1];
}
else
{
res[key]= res[key]" "out[i+1];
}
}
print"\n\n";
for(i in res)
{
ORS="";
printf("%s%8s|",i," ");
ORS="\n";
}
print "\n-----------------------------------------------------------------------------------------------------------------\n";
for(i in res)
{
ORS="";
print res[i]" |";
ORS="\n";
}
}
Running Procedure:
awk -f script.awk Input_File
If you are in solaris system, use nawk instead on awk.
The above script will take the below information as an input.
Code:
TOTAL+CB
DMFXNY
TOTAL+CB
EMSGFX
CB+FX
CB
DMFXNY
CB+FX
CB
EMSGFX
CB+FX
FX
DMFXNY
CB+FX
FX
EMSGFX
CS
DMFXNY
CS
EMSGFX
IR
DMFXNY
IR
EMSGFX
TOTAL
DMFXNY
TOTAL
EMSGFX
Cheers,
Ranga
Last edited by rangarasan; 02-24-2012 at 10:26 AM..
Yeah, just now worked with your complete input.
Its working fine if you have some small amount of information. I mean six header. If its more than six headers it hurts.
Cheers,
Ranga
Last edited by rangarasan; 02-24-2012 at 10:27 AM..
I have an xml file where the format looks like below
<SESSIONCOMPONENT REFOBJECTNAME ="pre_session_command" REUSABLE ="NO" TYPE ="Pre-session command">
<TASK DESCRIPTION ="" NAME ="pre_session_command" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
... (8 Replies)
HI
I want to parse below file in to two output :-
Input :-
?xml version="1.0" encoding="UTF-8"?>
<bulkCmConfigDataFile xmlns:un="utranNrm.xsd"
<configData dnPrefix="Undefined">
<xn:SubNetwork id="ONRM_ROOT_MO_R">
<xn:MeContext id="C136">
... (3 Replies)
I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere.
I can not supply any sample file as it contains private data but you can download your own contacts using this script:
#!/bin/sh
# imports... (9 Replies)
I am trying to parse an xml file and trying to grab certain values and inserting them into database table. I have the following xml that I am parsing:
<dd:service name="locator" link="false">
<dd:activation mode="manual" />
<dd:run mode="direct_persistent" proxified="false" managed="true"... (7 Replies)
Learned People,
Hello !
Till today, for the most part, all of the tricky questions/situations that I encountered were already posted by other folks and all I had to do was peruse through these one at a time and I could find some sort of an answer and all I had to do was add some minor tweaks... (5 Replies)
I have a xml file attached. I need to parse parameterId and its value
My output should be like
151515 38
151522 32769
and so on..
Please help me. Its urgent (6 Replies)
Hi,
Need a script to parse the following xml file content
<tag1 Name="val1">
<abc Name="key"/>
<abc Name="pass">*********</abc>
</tag1>
<tag2 Name="Core">
<Host Name="a.b.c">
<tag1 Name="abc">
<abc Name="ac">None</abc>
... (4 Replies)
I want to use wget comment to parse an xml parse that exist in an online website. How can I connect it using shell script through Unix and how can I parse it?? (1 Reply)
Hi
I want to take an XML file and transform it into a pipe-delimited format. What is the best tool to use for this? I have libxml2 which seems to be the best xml parser around.
The xml file will have the following format.
<Txn>
<Date>120504</Date>
<id>99</id>
<Items>
<Item>... (1 Reply)