Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

extract and format information from a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting extract and format information from a file
# 8  
Old 04-15-2008
Hi Murphy,

One more thing ; how can I capture the output in another HTML so that the details can be viewed or arranged in proper format.

Thanks in advance.
# 9  
Old 04-15-2008
Quote:
Originally Posted by sujoy101
Hi Franklyn,

I have modified the same with

awk 'BEGIN{FS="\""; printf("Filename= %s\n\n", /usr/data/weblogic/config/mktmixDomain/config.xml)}
$1 ~ /.* DriverName=$/{print "DriverName==" FS $2 FS}
$3 ~ /.* Name=$/{print "Name==" FS $4 FS}
$5 ~ /.* URL=$/{print "URL==" FS $6 FS ;print ""}
' file

but it gives following error:

./new.sh
awk: syntax error near line 1
awk: illegal statement near line 1

where am I going wrong?
Quote the string in the printf statement:

Code:
printf("Filename= %s\n\n", "/usr/data/weblogic/config/mktmixDomain/config.xml")

But you should use the FILENAME variable.
# 10  
Old 04-15-2008
Quote:
2. How to insert the "filename" with every result in attach output; so the detail for specific file can be identified.
XSLT1 does not have a facility to determine the name of a document being transformed from within the document. The name must be passed in as a top level param.

Quote:
how can I capture the output in another HTML so that the details can be viewed or arranged in proper format.
See the following stylesheet which includes support for both a filename and XHML outpur
Code:
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml"
    doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
    doctype-public="-//W3C//DTD XHTML 1.0 Strict//EN"
    indent="yes"/>
<xsl:param name="FNAME"/>

<xsl:template match="JDBCConnectionPool">
   <html>
      <head>
      </head>
      <body>
         Filename=="<xsl:value-of select="$FNAME"/>"
         DriverName=="<xsl:value-of select="@DriverName"/>"
         Name=="<xsl:value-of select="@Name"/>"
         URL=="<xsl:value-of select="@URL"/>"
      </body>
   </html>
</xsl:template>
</xsl:stylesheet>

Invoke as follows
Code:
xsltproc --param FNAME "'MYFILENAME'" file.xsl file.xml

Which results in the following output:
Code:
<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  </head>
  <body>
         Filename=="MYFILENAME"
         DriverName=="oracle.jdbc.OracleDriver"
         Name=="MyApp_DevPool"
         URL=="jdbcracle:thin:@myserver.net:1521:dbs130"
   </body>
</html>

Hope this helps you!
# 11  
Old 04-16-2008
Hi Murphy,

Thanks so much for your reply. One more thing ; if I want to extract "Name" from following field in the same xml file alongwith previous details for JDBCConnection pool;

<?xml version="1.0" encoding="UTF-8"?>
<Domain ConfigurationVersion="8.1.5.0" Name="accSys815Domain">
<Server AcceptBacklog="50" DefaultProtocol="t3"
DefaultSecureProtocol="t3s" ExpectedToRun="false"

What would be the changes to be done in the xsl?

TIA

Sujoy
# 12  
Old 04-16-2008
I dont want to use FNAME instead it should capture the domain name from the above section.
# 13  
Old 04-16-2008
Hi Murphy,

Pls find attached the modified xsl ; which I want to use for multiple config files.

following command is used to get the output.html file (as attached).


xsltproc --param FNAME "'mktmixDomain'" fname.xsl mktmixDomain.xml > OUTPUT.html

Can you pls suggest changes to be done to address following:

1. If the domain name can be captured from the config.xml specific block;

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="http://dev2dev.bea.com/blog/euxx/config.xsl"?>
<Domain ConfigurationVersion="8.1.5.0" Name="mktmixDomain" ProductionModeEnabled="true">


2. The script should process multiple config.xml files under a folder.

3. Output should be in a single html file.

My basic objective is to create an inventory of all JDBC detail for all weblogic domains.

Regards
Sujoy
fname.zip (4.1 KB) 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

awk script to extract transcript information from gff3 file

I need help to extract transcript information from gff3 file. Here is the input Chr01 JGI gene 82773 86941 . - . ID=Potri.001G000900;Name=Potri.001G000900 Chr01 JGI mRNA 82793 86530 . - . ID=PAC:27047814;Name=Potri.001G000900.1;pacid=27047814;longest=1;Parent=Potri.001G000900... (6 Replies)
Discussion started by: Maduranga
6 Replies

2. Shell Programming and Scripting

Extract information from file

In a particular directory, there can be 1000 files like below. filename is job901.ksh #!/bin/ksh cront -x << EOJ submit file=$PRODPATH/scripts/genReport.sh maxdelay=30 &node=xnode01 tname=job901 &pfile1=/prod/mldata/data/test1.dat ... (17 Replies)
Discussion started by: vedanta
17 Replies

3. Shell Programming and Scripting

Extract information from file

Gents, If is possible please help. I have a big file (example attached) which contends exactly same value in column, but from column 2 to 6 these values are diff. I will like to compile for all records all columns like the example attached in .csv format (output.rar ).. The last column in the... (11 Replies)
Discussion started by: jiam912
11 Replies

4. Shell Programming and Scripting

Extract information from txt file

Hello! I need help :) I have a file like this: AA BC FG RF TT GH DD FF HH (a few number of rows and three columns) and I want to put the letters of each column in a variable step by step in order to give them as input in another script. So I would like to obtain: for the 1° loop:... (11 Replies)
Discussion started by: edekP
11 Replies

5. Shell Programming and Scripting

How to extract information from a file?

Hi, i have a file like this: <Iteration> <Iteration_iter-num>3</Iteration_iter-num> <Iteration_query-ID>lcl|3_0</Iteration_query-ID> <Iteration_query-def>G383C4U01EQA0A length=197</Iteration_query-def> <Iteration_query-len>197</Iteration_query-len> ... (9 Replies)
Discussion started by: the_simpsons
9 Replies

6. Shell Programming and Scripting

Extract various information from a log file

Hye ShamRock If you can help me with this difficult task for me then it will save my day Logs : ================================================================================================================== ... (4 Replies)
Discussion started by: SilvesterJ
4 Replies

7. Shell Programming and Scripting

extract information from a log file (last days)

I'm still new to bash script , I have a log file and I want to extract the items within the last 5 days . and also within the last 10 hours the log file is like this : it has 14000 items started from march 2002 to january 2003 awk '{print $4}' < *.log |uniq -c|sort -g|tail -10 but... (14 Replies)
Discussion started by: matarsak
14 Replies

8. Shell Programming and Scripting

Create shell script to extract unique information from one file to a new file.

Hi to all, I got this content/pattern from file http.log.20110808.gz mail1 httpd: Account Notice: close igchung@abc.com 2011/8/7 7:37:36 0:00:03 0 0 1 mail1 httpd: Account Information: login sastria9@abc.com proxy sid=gFp4DLm5HnU mail1 httpd: Account Notice: close sastria9@abc.com... (16 Replies)
Discussion started by: Mr_47
16 Replies

9. Shell Programming and Scripting

Extract information from Log file formatted

Good evening! Trying to make a shell script to parse log file and show only required information. log file has 44 fields and alot of lines, each columns separated by ":". log file is like: first_1:3:4:5:6:1:3:4:5:something:notinterested second_2:3:4:3:4:2 first_1:3:4:6:6:7:8 I am interested... (3 Replies)
Discussion started by: dummie55
3 Replies

10. Shell Programming and Scripting

How to extract a piece of information from a huge file

Hello All, I need some assistance to extract a piece of information from a huge file. The file is like this one : database information ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc os information cccccccccccccccccc cccccccccccccccccc... (2 Replies)
Discussion started by: Marcor
2 Replies
Login or Register to Ask a Question