Sponsored Content
Top Forums Shell Programming and Scripting Need to Split Big XML into multiple xmls Post 302467087 by dprakash on Thursday 28th of October 2010 08:24:34 AM
Old 10-28-2010
thanks a lot pravin..its working.....

---------- Post updated at 07:24 AM ---------- Previous update was at 06:38 AM ----------

Hi Pravin
we are not able to generate our real time Order xml with ur command..
Below dot shows n no of lines....
and we need to capture data between <Order Number="1"> tag to </Order> tag for different orders
and also we need to add other tags like than <Order> to each xml
for example:
here PaymentMethods and LineCharge tag data will be needed to add in each xml.
Code:
<OrderDetail BillToKey="20100805337" Createuserid="CreateGuestOrder" >
<Order Number="1">
<OrderLine CarrierServiceCode="G2" FulfillmentType="ShipToHome"/>
<Item ItemDesc="iPearl 8GB MP3 " ItemID="11239924" ItemWeight="0.00" />
.....
.
....
....
..

</Order>
<Order Number="2">
<OrderLine CarrierServiceCode="H2" FulfillmentType="ShipToHome" />
....
....
...
</Order>
<Order Number="3">
<OrderLine CarrierServiceCode="M2" FulfillmentType="ShipToHome" />
<Item ItemDesc="TV" ItemID="4545345" ItemWeight="67.00" />
<LinePriceInfo ActualPricingQty="6.00" BundleTotal="0.00" DiscountPercentage="0.00" LineTotal="80.79" />
....
......
.........
............
</Order>

<PaymentMethods>
<PaymentMethod HoldType="ADDRESS_VAL_HOLD" Status="1100" StatusDescription="Created" />
...
.....
</PaymentMethods>
<LineCharge ChargeAmount="0.00" ChargeCategory="SHIPPING" ChargeName="ShippingCharge" />
</OrderDetail>


Last edited by Scott; 10-28-2010 at 11:57 AM.. Reason: Code tags, please...
This User Gave Thanks to dprakash For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split a Big Report.

Hi All, I am a newbie for Unix Script. I have report like the following: (file name: Report.txt): Report No.: AAA BE NO: 111 asfsdflsjdfklsdjfklsjfklsfsflsjdlk fsdfjsfkjsklfsfj Report No.: AAA BE NO: 111 sdfsdfjsdklfjsfkj fsdflkjsdfklsjkl Report No.: AAA (16 Replies)
Discussion started by: raychu65
16 Replies

2. UNIX for Dummies Questions & Answers

Split BIG report using nawk

I have the following nawk script: nawk -F: '{ if($0 ~ "^Report No") {fl=1; i=0;} if(fl==1){data=$0; i++} if($0 ~ "^BE NO:") { fname = "reprot_"$2".lis"; gsub(" ","",fname); for(j=0;j<i;j++) print data > fname; fl=0; } else if(fl==0) print $0 > fname; }' filename When I try to apply... (1 Reply)
Discussion started by: raychu65
1 Replies

3. Shell Programming and Scripting

Help Needed : Split one big file to multiple files

Hi friends, I have data in flat file as following, first filed is the customer number. We have almost 50-100 customers in the system 100 ABC A123 100 BVC D234 100 BNC N324 200 CBC A122 200 AVC D294 200 HNC N324 300 GBC A173 300 FVC D234 300 DNC N344 I want to split the file and... (5 Replies)
Discussion started by: monicasgupta
5 Replies

4. UNIX for Advanced & Expert Users

Split a big file into two others files

Hello, i have a very big file that has more then 80 MBytes (100MBytes). So with my CVS Application I cannot commit this file (too Big) because it must have < 80 MBytes. How can I split this file into two others files, i think the AIX Unix command : split -b can do that, buit how is the right... (2 Replies)
Discussion started by: steiner
2 Replies

5. Shell Programming and Scripting

split XML file into multiple files based on pattern

Hello, I am using awk to split a file into multiple files using command: nawk '{ if ( $1 == "<process" ) { n=split($2, arr, "\""); file=arr } print > file }' processes.xml <process name="Process1.process"> ... (3 Replies)
Discussion started by: chiru_h
3 Replies

6. Shell Programming and Scripting

Split a big file into multiple files based on first four characters

I have a requirement to split a huge file to smaller text files based on first four characters which look like ABCD 1234 DFGH RREX : : : : : 0000 Each of these records are OF EQUAL bytes with a different internal layout based on the above first digit identifier.. Any help to start... (5 Replies)
Discussion started by: etldev
5 Replies

7. HP-UX

How to split big file on HP-UX and join on Windows?

Hi HP-admins, I have 120GB file on HP-UX and need to split to 4GB pieces and join them on Windows. As I don't want to use zipsplit, tried to use split command and join on windows using "copy /b" but it doesn't work (It merges and creates new file but file is corrupt) What is the correct... (6 Replies)
Discussion started by: prvnrk
6 Replies

8. Shell Programming and Scripting

Split a big file into multiple files using awk

this thread is a continuation from previous thread https://www.unix.com/shell-programming-and-scripting/223901-split-big-file-into-multiple-files-based-first-four-characters.html ..I am using awk to split file and I have a syntax error while executing the below code I am using AIX 7.2... (4 Replies)
Discussion started by: etldev
4 Replies

9. Shell Programming and Scripting

Split xml file into multiple xml based on letterID

Hi All, We need to split a large xml into multiple valid xml with same header(2lines) and footer(last line) for N number of letterId. In the example below we have first 2 lines as header and last line as footer.(They need to be in each split xml file) Header: <?xml version="1.0"... (5 Replies)
Discussion started by: vx04
5 Replies

10. Shell Programming and Scripting

Split Big XML file Base on tag

HI I want to split file base on tag name. I have few header and footer on file <?xml version="1.33" encing="UTF-8"?> <bulkCmConfigDataFile" <xn:SubNetwork id="ONRM_ROOT"> <xn:MeContext id="PPP04156"> ... (4 Replies)
Discussion started by: pareshkp
4 Replies
trang(1)						      General Commands Manual							  trang(1)

NAME
trang - convert between different schema languages for XML SYNOPSIS
trang [-I rng|rnc|dtd|xml] [-O rng|rnc|dtd|xsd] [-i input-param] [-o output-param] input-file ... output-file DESCRIPTION
trang takes as input a schema written in any of the following formats: RELAX NG (XML syntax) RELAX NG (compact syntax) XML 1.0 DTD and produces as output a schema written in any of the following formats: RELAX NG (XML syntax) RELAX NG (compact syntax) XML 1.0 DTD W3C XML Schema Trang can also infer a schema from one or more example XML documents. Trang uses an internal representation based on RELAX NG. For each supported input format, there is an input module that converts a schema in that input format into this internal representation. For each supported output format, there is an output module that converts the internal representation into a schema in that output format. Thus, any supported input format can be translated to any supported output format. Trang requires two command-line arguments: the first is the URI or filename of the schema to be translated; the second is the output file- name. Trang infers the input and output modules to be used from the extension of input and output filenames as follows: .rng RELAX NG (XML syntax) .rnc RELAX NG (compact syntax) .dtd XML 1.0 DTD .xsd W3C XML Schema .xml XML documents (used as examples from which to infer a schema) This inference can be overridden using the -I and -O options. When the input is XML documents used as examples to infer a schema, more than one input file may be specified as arguments. All the input files are specified before the output file. OPTIONS
-I rng|rnc|dtd|xml Specifies which input module to use. -O rng|rnc|dtd|xsd Specifies which output module to use. -i input-param -o output-param Specifies a parameter for an input (-i) or output (-o) module. The -i and -o options may be used multiple times in order to specify multiple parameters. There are two kinds of parameter: boolean parameters and string-valued parameters. A string-valued parameter is specified using the form name=value. A boolean parameter is specified using the form name or no-name. The applicable parameters depend on the particular input and output module. For details, see the HTML documentation. SEE ALSO
jing(1) Trang Manual http://relaxng.org AUTHOR
James Clark (jjc@jclark.com) This product includes software developed by the Apache Software Foundation (http://www.apache.org/). @VERSION@ trang(1)
All times are GMT -4. The time now is 04:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy