Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Converting XML to CSV
Top Forums Shell Programming and Scripting Converting XML to CSV Post 303038660 by stomp on Tuesday 10th of September 2019 02:13:03 PM
Old 09-10-2019
Hi SDohmen,

some additional bits of Knowledge about XPath will lead you forward towards your solution. Especially try to get information about how to figure out "parent nodes" of your target nodes.

One possible algorithm is to not iterate over the different orders(data), but iterate over the different products(products) and get a parent node(idpurchaseorder) from there.

Regards,
stomp.

P. S.: @Mod or @SDohmen: please fix the typo in the xml above: <name>Productname/name>

P. P. S.: I did not know the solution before the question was asked, and - according to Neos request - I will not take the fun and chance to grow from the poster to figuring it out for him-/herself. (The solution is about the same in size as the current shown attempts).

P. P. P. S: +1 Point for SDohmen using a suitable tool for the task. ;-)
Last edited by stomp; 09-10-2019 at 03:48 PM..
These 2 Users Gave Thanks to stomp For This Post:
Neo RavinderSingh13
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting csv to xls

Hi, Can anyone tell the option to change the file type in unix. i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format. Thanks in advance, Milton. (1 Reply)
Discussion started by: miltony
1 Replies

2. Shell Programming and Scripting

converting text to csv format

I am trying to check each line and based on first two digits, the comma needs to be place. I checked in the earlier post where the text is converted to csv with a tab delimited. Here is the test file that needs to be changed to csv 11 051701 22 051701 330123405170105170112345... (13 Replies)
Discussion started by: gthokala
13 Replies

3. UNIX for Dummies Questions & Answers

Converting HTML to CSV

Hi, I need to convert a relatively large html file (1.5megs) into CSV under Unix. How would I be able to do this? Much thanks. (3 Replies)
Discussion started by: Jexel
3 Replies

4. UNIX for Dummies Questions & Answers

Converting spaces to csv

I'm new to shell scripting and I have a file with positional columns. The rows look like this: 222 3333 44444 55 55 55 55 5555 59999 222 3333 44444 55 55 55 55 5555 59999 Not every row has the same number of spaces between the seven columns. They can range anywhere... (11 Replies)
Discussion started by: jkandel
11 Replies

5. Shell Programming and Scripting

Converting a flat file in XML

Hello Friends, I am new to UNIX shell scripting. Using bash....Could you please help me in converting a flat file into an XML style output file. Flat file: (Input File entries looks like this) John Miller: 617-569-7996:15 Bunting lane, staten Island, NY: 10/21/79: 60600 The... (4 Replies)
Discussion started by: humkhn
4 Replies

6. Shell Programming and Scripting

converting specific XML file to CSV

Hi, i would convert the following XML file : <?xml version="1.0" encoding="UTF-8" ?> <files xmlns="http://www.lotus.com/dxl/console"> <filedata notesversion="6" odsversion="43" logged="yes" backup="no" id="C12577E6:004B0DA3" iid="C12577E6:004B0DA8" link="1" dboptions="0,524288,0,0"> ... (24 Replies)
Discussion started by: Nicol
24 Replies

7. Shell Programming and Scripting

Converting CSV to ascii format

Hej All, I have a file like this which is a comma dilimited: input: 6000318,-263.011520678,-59.05869872409,587.67924868792 6000319,-265.6996842902,-50.24902479999,590.65693082607 6000320,-238.1333898366,-288.801232595,633.75332173496... (5 Replies)
Discussion started by: Johanni
5 Replies

8. Shell Programming and Scripting

Help with converting XML to Flat file

Hi Friends, I want to convert a XML file to flat file. Sample I/p: <?xml version='1.0' encoding='UTF-8' ?> <DataFile xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' contactCount='4999' date='2012-04-14' time='22:00:14' xsi:noNamespaceSchemaLocation='gen .xsd'> <Contact... (3 Replies)
Discussion started by: karumudi7
3 Replies

9. UNIX for Dummies Questions & Answers

Need help converting txt to XML

I have a table as following Archive id Line Author Time Text 1fjj34 3 75jk5l 03:20 this is an evidence regarding ... 1fjj34 4 gjhhtrd 03:21 we have seen those documents before 1fjj34 10 645jmdvvb 04:00 Will you consider such an offer?... (0 Replies)
Discussion started by: A-V
0 Replies

10. Shell Programming and Scripting

Using awk for converting xml to txt

Hi, I have a xml script, I converted it to .txt with values comma seperated using awk function. But I want the output values should be inside double quotes My xml script (Workorders.xml) is shown like below: <?xml version="1.0" encoding="utf-8" ?> <scbm-extract version="3.3">... (8 Replies)
Discussion started by: Viswanatheee55
8 Replies

LEARN ABOUT CENTOS

pom_xpath_replace

POM_XPATH_REPLACE(7)						Java Packages Tools					      POM_XPATH_REPLACE(7)

NAME

       pom_xpath_replace - replace XML node from POM file with given XML code

SYNOPSIS

       %pom_xpath_replace XPath XML-code [POM-location]

DESCRIPTION

       This macro patches specified POM file removing all XML nodes described by the XPath expression and injecting given XML code in their place.

       XPath is an expression describing a set of XML nodes to be removed from the POM file. It must be a properly formated XPath 1.0 expression,
       as described in http://www.w3.org/TR/xpath/.

       POM location can be either a full path to the POM file, or a path to the directory containing pom.xml. If POM location is not given then
       pom.xml from current working directory is used.

BUGS

       POM files use a specific namespace - http://maven.apache.org/POM/4.0.0. Currently this namespace needs to be explicitly specified in all
       XPath POM macros by prefixing all node names with pom:.

AUTHOR

       Written by Mikolaj Izdebski.

REPORTING BUGS

       Bugs should be reported through Red Hat Bugzilla at http://bugzilla.redhat.com/.

SEE ALSO

       pom_add_dep(7), pom_add_parent(7), pom_add_plugin(7), pom_disable_module(7), pom_remove_dep(7), pom_remove_parent(7), pom_remove_plugin(7),
       pom_set_parent(7), pom_xpath_inject(7), pom_xpath_remove(7), pom_xpath_set(7).

JAVAPACKAGES
							    06/10/2014						      POM_XPATH_REPLACE(7)
All times are GMT -4. The time now is 04:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy