UNIX shell script required to read two columns from xml Post: 303031975

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers UNIX shell script required to read two columns from xml Post 303031975 by sekhar.lsb on Friday 8th of March 2019 09:12:03 AM

03-08-2019

Registered User

UNIX shell script required to read two columns from xml

Hello All,

I am new to unix scripting. I need to read FROMINSTANCE, FROMFIELD from below XML code and need to write a script for

Code:

insert into SQ_EPIC values( "DID", "PROJECT_NAME")
Select DID, PROJECT_NAME from EPIC

Code:

<CONNECTOR TOINSTANCETYPE="Source Qualifier" TOINSTANCE="SQ_EPIC" TOFIELD="DID" FROMINSTANCETYPE="Source Definition" FROMINSTANCE="EPIC" FROMFIELD="DID"/>

<CONNECTOR TOINSTANCETYPE="Source Qualifier" TOINSTANCE="SQ_EPIC" TOFIELD="PROJECT_NAME" FROMINSTANCETYPE="Source Definition" FROMINSTANCE="EPIC" FROMFIELD="PROJECT_NAME"/>

<CONNECTOR TOINSTANCETYPE="Target Definition" TOINSTANCE="STAGE_EPIC" TOFIELD="DID" FROMINSTANCETYPE="Source Qualifier" FROMINSTANCE="SQ_EPIC" FROMFIELD="DID"/>

<CONNECTOR TOINSTANCETYPE="Target Definition" TOINSTANCE="STAGE_EPIC" TOFIELD="PROJECT_NAME"FROMINSTANCETYPE="Source Qualifier" FROMINSTANCE="SQ_EPIC" FROMFIELD="PROJECT_NAME"/>

Kindly some help me how to proceed for this requirement.

Thanks in Advance!!!

Regards,
Sekhar Lekkala.

Last edited by RudiC; 03-08-2019 at 05:23 PM..

sekhar.lsb

View Public Profile for sekhar.lsb

Find all posts by sekhar.lsb

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script required to convert rows to columns

Hi Friends, I have a log file as below siteid = HYD spc = 100 rset = RS_D_M siteid = DEL spc = 200 rset = RS_K_L siteid = DEL2 spc = 210 rset = RS_D_M Now I need a output like column wise as below. siteid SPC rset HYD 100 RS_D_M

2. UNIX for Advanced & Expert Users

Shell script failing to read large Xml record-urgent critical help

Hi All, I have shell script running on AIX 5.3 box. It has 7 to 8 "sed" commands piped(|) together. It has a an Xml file as its input which has many records internally. There are certain record which which have more than hundered tags.The script is taking a huge amount of time more than 1.5 hrs...

3. Shell Programming and Scripting

Help required on basic Unix Bourne Shell Script

Howdy People :), I'm a newbie & its my first question here. I've started learning Unix Bourne Shell scripting recently and struggling already :p Can someone PLEASE help me with the following problem. Somehow my script is not working. Display an initial prompt of the form: Welcome to...

4. Shell Programming and Scripting

How to send email using shell script in UNIX, Is any environment setup required in Mac OS X ?

Hi All, I am using Mac OS X (Leopard OS). I am very new to UNIX. My requirement is that, by running a shell script, I create a log file. So I have to send a mail having that log file attached. What I tried to do is, I simply tried to check,whether this direct command works or not. So I...

5. Shell Programming and Scripting

Unix Script to read the XML file from Website

Hi Experts, I need a unix shell script which can copy the xml file from the below pasted website and paste in in my unix directory. http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml Thanks in Advance...

6. UNIX for Advanced & Expert Users

Shell Script to read XML tags and the data within that tag

Hi unix Gurus, I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information. For example <SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME...

7. Shell Programming and Scripting

Shell Script to read XML file

8. Red Hat

How to read an xml file through shell script?

Hey , can we read an xml file and make changes in it through shell script. Thanks

9. Shell Programming and Scripting

UNIX Shell script to work with .xml file

Hi Team, Could you please help me on below query: I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file 2. it will ignore the commented XML lines. i.e. XML tags between...

10. Shell Programming and Scripting

Read xml tags and then remove the tag using shell script

<Start> <Header> This is header section </Header> <Body> <Body_start> This is body section <a> <b> <c> <st>111</st> </c> <d> <st>blank</st> </d> </b> </a> </Body_start> <Body_section> This is body section

LEARN ABOUT DEBIAN

fop-ttfreader

FOP-TTFREADER(1)					User Contributed Perl Documentation					  FOP-TTFREADER(1)

NAME

       fop-ttfreader --  A tool which reads TTF files and generates XML font metrics file for use in FOP.

SYNOPSIS

       fop-ttfreader [options] fontfile.ttf xmlfile.xml

OPTIONS

       -enc ansi
	   with this option you can create a WinAnsi encoded font. The default is to create a CID keyed font.  If you're not going to use
	   characters outside the pdfencoding range (almost the same as iso-8889-1) you can add this option.

       -ttcname fontname
	   if you're reading data from TrueType Collection (.ttc file) you must specify which font from the collection you will read metrics from.
	   If you read from a .ttc file without this option, the fontnames will be listed for you.

       -fn fontname
	   default is to use the fontname in the .ttf file, but you can override that name to make sure that the embedded font is used (if you're
	   embedding fonts) instead of installed fonts when viewing documents with Acrobat Reader.

EXAMPLES

       "fop-ttfreader /usr/share/fonts/truetype/freefont/FreeSerif.ttf freeserif.xml"
	   generates freeserif.xml file containing XML font metrics from FreeSerif.ttf

JAVA-WRAPPERS NOTE
       This program is a shell script wrapper based on java-wrappers(7).  You therefore benefit from several features; please see the java-
       wrappers(7) manual page for more information about them.

AUTHOR

       Wrapper author: Arnaud Vandyck <avdyk@debian.org>

SEE ALSO

       fop(1), java-wrappers(7)

Fop-TTFReader						   Sun Jan 15 11:24:34 UTC 2012 					  FOP-TTFREADER(1)