Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert XML to Data File in Shell Script
Top Forums Shell Programming and Scripting Convert XML to Data File in Shell Script Post 302420091 by ragha81 on Monday 10th of May 2010 03:57:15 PM
Old 05-10-2010
Hi Tyler Thanks a lot for your help. Its working fine and creating the text files

I have a question though, I am trying to create ProductRef.txt and Products.txt just like you did for other three but its not working as expected. Is it because there are some extra tags within those tags.

How do I create files for them as well.

Thanks
Raghav

---------- Post updated at 02:41 PM ---------- Previous update was at 02:37 PM ----------

Tyler,

This is how I modified your code

Code:
perl -lne 'BEGIN {undef $/}
            while (/<(Portfolio|Family|SubFamily) productCode="(.*?)".*?value="(.*?)".*?

value="(.*?)".*?<\/(Portfolio|Family|SubFamily)>/sg) {
              if ($1 eq "Portfolio") {push @p, "$2|$3|$4"}
              elsif ($1 eq "Family") {push @f, "$2|$3|$4"}
              elsif ($1 eq "SubFamily") {push @sf, "$2|$3|$4"}
              elsif ($1 eq "ProductRefs") {push @pr, "$2|$3|$4|$4|$5|$6|$7|$8|$9|$10"}
              
            }
           END {if (@p)  {open(F, ">portfolio.txt"); foreach(@p) {print F $_} close(F)}
                if (@f)  {open(F, ">family.txt"); foreach(@f) {print F $_} close(F)}
                if (@sf) {open(F, ">subfamily.txt"); foreach(@sf) {print F $_} close(F)}
                if (@pr) {open(F, ">ProductRefs.txt"); foreach(@pr) {print F $_} close(F)}
           }
           ' CPC.xml



---------- Post updated at 03:57 PM ---------- Previous update was at 02:41 PM ----------

Hi... I have XSLT installed in my unix box. Can you guys suggest me how to create an xsl file for the xml I posted. I think using the xsl approach will be much easier to convert the xml to a data file
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Plz Help To convert xml file to text file using bourn shell scripts

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> <country_code>AK></country_code>... (0 Replies)
Discussion started by: ram2s2001
0 Replies

2. Shell Programming and Scripting

extract data from xml- shell script using awk

Hi, This is the xml file that i have. - <front-servlet platform="WAS4.0" request-retriever="SiteMinder-aware" configuration-rescan-interval="60000"> <concurrency-throttle maximum-concurrency="50" redirect-page="/jsp/defaulterror.jsp" /> - <loggers> <instrumentation... (5 Replies)
Discussion started by: nishana
5 Replies

3. Shell Programming and Scripting

Sample Unix script file to convert .xml to .csv

Dear all, Can you send me a script file the changes .xml to .csv file. Thanks, Srinivasa (4 Replies)
Discussion started by: srinivasaphani
4 Replies

4. Shell Programming and Scripting

Help with shell script to extract data from XML file

Hello Scripting Gurus, I need help with extracting data from the XML file using shell script. The data is in a large XML and I need to extract the id values of all completedworkflows. Here is a sample of it. Input and output data is also in the attached text files. <wfregistry>... (5 Replies)
Discussion started by: yajaykumar
5 Replies

5. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

I have an xml file: <AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Table1> <Data1 10 </Data1> <Data2 20 </Data2> <Data3 40 </Data3> <Table1> </AutoData> and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only. I tried using sed... (10 Replies)
Discussion started by: Gary1978
10 Replies

6. Shell Programming and Scripting

convert one form of xml data to other

I would like to convert one form of xml tag data to another <DescriptionList> <DescriptionExt language="en" shortDesc="ITALIAN SAUSAGE SUB" longDesc="" sizeDesc="" smallImage="Pictures\sub-italian-sausage.png" largeImage="" forceImageUpdate="yes" /> ... (1 Reply)
Discussion started by: saisus
1 Replies

7. UNIX for Advanced & Expert Users

Convert column data to row data using shell script

Hi, I want to convert a 3-column data to 3-row data using shell script. Any suggestion in this regard is highly appreciated. Thanks. (4 Replies)
Discussion started by: sktkpl
4 Replies

8. 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

9. Shell Programming and Scripting

Convert XML to CSV using awk or shell script

Hello, I am working on a part of code where I need a awk or shell script to convert the given XML file to CSV or TXT file. There are multiple xml files and of different structure, so a single script is required for converting data. I did find a lot of solutions in the forum but... (16 Replies)
Discussion started by: Rashmitha
16 Replies

10. Shell Programming and Scripting

Need get data from XML file through shell script..

hi all, here is the sample log file and these errors are repeated in log file.. i need all the repeated time stamp ,severity and message tags needs to print in output file.. through shell script <log-message> <timestamp>2019-03-13T04:52:49.648-05:00</timestamp> <severity>ERROR</severity>... (17 Replies)
Discussion started by: ravi
17 Replies

LEARN ABOUT REDHAT

vermiculate

XScreenSaver(1) 					      General Commands Manual						   XScreenSaver(1)

NAME

       vermiculate - to move in a worm-like manner.

SYNOPSIS

       vermiculate [-display host:display.screen] [-visual visual] [-window] [-root]

DESCRIPTION

       Draws squiggly worm-like paths.

OPTIONS

       -visual visual
	       Specify which visual to use.  Legal values are the name of a visual class, or the id number (decimal or hex) of a specific visual.

       -window Draw on a newly-created window.	This is the default.

       -root   Draw on the root window.

ENVIRONMENT

       DISPLAY to get the default host and display number.

       XENVIRONMENT
	       to get the name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.

SEE ALSO

       X(1), xscreensaver(1)

COPYRIGHT

       Copyright (C) 2002 by Tyler Pierce.  Permission to use, copy, modify, distribute, and sell this software and its documentation for any pur-
       pose is hereby granted without fee, provided that the above copyright notice appear in all copies and that both that copyright  notice  and
       this permission notice appear in supporting documentation.  No representations are made about the suitability of this software for any pur-
       pose.  It is provided "as is" without express or implied warranty.

AUTHOR

       Tyler Pierce.

X Version 11															   XScreenSaver(1)
All times are GMT -4. The time now is 11:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy