03-24-2008
Formatting Autosys output
Hi, I am trying to list out the job name, descrition, command for a jil. I would like to get it in a csv format so I can import it to Excel. I have access to the actual jil file for a script executing against the file or a command against the loaded jil will do. Any ideas?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Have the following code(1) producing the results(2 & 3).
Would like to know if there is a way to format the two reports created in a similar fashion.
IE - The first is formatted nicely as a result of the echo "$xmpbdate $xavgs" >> $xmpbrpt
However when I attempt to do the same on... (7 Replies)
Discussion started by: Cameron
7 Replies
2. Shell Programming and Scripting
Hi need some advice..
#grep -i hostname test.csv
(gives the below output)
HOSTNAME,name,host_test,,,,,,,,
Now I need to format the above output as below.
HOSTNAME:
name=host_test
Any easy way of doing this using awk or sed or printf? (4 Replies)
Discussion started by: balaji_prk
4 Replies
3. Shell Programming and Scripting
Ok, for a fun project, my goal is to replicate the style of "catalog" on an old apple ]
*A 002 SOMEAPPLESOFTFILE
B 004 SOMEFILE
T 006 SOMETEXT
I 002 SOMEINTEGERFILE
The first character is either " " or "*" depending on if the file is locked or not.
Next is the filetype, so in... (1 Reply)
Discussion started by: patrick99e99
1 Replies
4. Shell Programming and Scripting
I am using find and ls to search for "warez" files on my server.
find /home/ -regex ".*\.\(avi\|mp3\|mpeg\|mpg\|iso\)" -print0 | xargs -0 ls -oh
This command produces this:
-rw-r--r-- 1 1000 3.2M Feb 18 2009 /home/user/public_html/lupus.mp3
I want to only get this
3.2M... (4 Replies)
Discussion started by: bonrad
4 Replies
5. Shell Programming and Scripting
my script is as follows
cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'`
cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'`
if
then
if
then
rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt
... (1 Reply)
Discussion started by: swkambli
1 Replies
6. Shell Programming and Scripting
Hi Experts,
I have to create a report for certain audit and my output looks as follows
I m trying to format my output to look like
Any inputs would be highly appreciated
Thanks
Syed (5 Replies)
Discussion started by: maverick_here
5 Replies
7. Shell Programming and Scripting
Hi Guys
I need help removing some lines from output i am receiving from a shell script.
Here is the output:
http://i52.tinypic.com/10z0fut.png
I am trying to remove the output that i have circled.
. ${EDW}/extracts/bin/extracts_setup2.sh
. ${EDW}/extracts/extracts.conf
... (7 Replies)
Discussion started by: mooey1232003
7 Replies
8. UNIX for Advanced & Expert Users
if you want to parse the output from an autosys you can use the below
autorep -j Prefix_% | awk '{
if ($6 ~ /^/)
printf "%-20s \t\t %-20s\n",$1,$5 ;
else if ($6 ~ /^/)
printf "%-20s \t\t %-20s\n",$1,$6;
else
printf "%-20s \t\t %-20s\n",$1,$4
}' | awk '{
if ($2... (1 Reply)
Discussion started by: phpsnook
1 Replies
9. Shell Programming and Scripting
I have the output like below:
DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance
SERIAL: 68173531021
==========================================================================
Path# Adapter/Path Name State Mode Select Errors
0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
10. Shell Programming and Scripting
Hi ,
can anyone help me in this
Input file
Name= XYZ
Company= ALPHA
City= Stockhomn
Equipment=computer
Country=Sweden
Name=MNC
Company=Beta
City=Kaulampur
Equipment=computer
Country=Malaysia
Name=JVC
Company=gamma
City=Kiruna (3 Replies)
Discussion started by: swets
3 Replies
LEARN ABOUT DEBIAN
xlhtml
xlhtml(1) General Commands Manual xlhtml(1)
NAME
xlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSIS
xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-
N] FILE
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts for viewing email attachments. Most use of this program is through
the helper scripts and one would probably rarely resort to using the commandline interface.
OPTIONS
-a aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
-asc Ascii out of -dp and extraction data (-xc, -xp, -xr)
-csv Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
-xml Output in XML of -dp and extraction data (-xc, -xp, -xr)
-bc Override the background color. e.g. -bc808080 for gray
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-dp Dump page count and max columns and rows per page
-v Prints program version
-fw suppress formula warnings about accuracy
-m No encoding for multibyte
-nc tells it not to colorize the output.
-nh Suppress header and body tags in html output
-tc Override the text color. e.g. -tcFF0000 for red
-te Trims empty rows & columns at the edges of a worksheet
-xc Columns (separated by a dash) for extraction (zero based)
-xp Page for extraction (zero based), one page only
-xr Rows (separated by a dash) to be extracted (zero based)
An example of the extraction command line is: xlhtml -fw -asc -xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column left to right, columns separated by a tab, end of row is: 0x0A, end of file:
AUTHOR
Steve Grubb, Charles N Wyble
xlhtml May 15, 2002 xlhtml(1)