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
spreadsheet::xlsx::utility2007
Spreadsheet::XLSX::Utility2007(3pm) User Contributed Perl Documentation Spreadsheet::XLSX::Utility2007(3pm)
NAME
Spreadsheet::XLSX::Utility2007 - Utility function for Spreadsheet::XLSX
SYNOPSIS
use strict;
#Declare
use Spreadsheet::XLSX::Utility qw(ExcelFmt ExcelLocaltime LocaltimeExcel);
#Convert localtime ->Excel Time
my $iBirth = LocaltimeExcel(11, 10, 12, 23, 2, 64);
# = 1964-3-23 12:10:11
print $iBirth, "
"; # 23459.5070717593
#Convert Excel Time -> localtime
my @aBirth = ExcelLocaltime($iBirth, undef);
print join(":", @aBirth), "
"; # 11:10:12:23:2:64:1:0
#Formatting
print ExcelFmt('yyyy-mm-dd', $iBirth), "
"; #1964-3-23
print ExcelFmt('m-d-yy', $iBirth), "
"; # 3-23-64
print ExcelFmt('#,##0', $iBirth), "
"; # 23,460
print ExcelFmt('#,##0.00', $iBirth), "
"; # 23,459.51
print ExcelFmt('"My Birthday is (m/d):" m/d', $iBirth), "
";
# My Birthday is (m/d): 3/23
DESCRIPTION
Spreadsheet::XLSX::Utility exports utility functions concerned with Excel format setting.
ExcelFmt is used by Spreadsheet::XLSX::Fmt2007.pm which is used by Spreadsheet::XLSX.
Functions
This module can export 3 functions: ExcelFmt, ExcelLocaltime and LocaltimeExcel.
ExcelFmt
$sTxt = ExcelFmt($sFmt, $iData [, $i1904]);
$sFmt is a format string for Excel. $iData is the target value. If $flg1904 is true, this functions assumes that epoch is 1904. $sTxt is
the result.
For more detail and examples, please refer sample/chkFmt.pl in this distribution.
ex.
ExcelLocaltime
($iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay, $iMSec) =
ExcelLocaltime($iExTime [, $flg1904]);
ExcelLocaltime converts time information in Excel format into Perl localtime format. $iExTime is a time of Excel. If $flg1904 is true,
this functions assumes that epoch is 1904. $iSec, $iMin, $iHour, $iDay, $iMon, $iYear, $iwDay are same as localtime. $iMSec means
1/1,000,000 seconds(ms).
LocaltimeExcel
$iExTime = LocaltimeExcel($iSec, $iMin, $iHour, $iDay, $iMon, $iYear [,$iMSec] [,$flg1904])
LocaltimeExcel converts time information in Perl localtime format into Excel format . $iSec, $iMin, $iHour, $iDay, $iMon, $iYear are same
as localtime.
If $flg1904 is true, this functions assumes that epoch is 1904. $iExTime is a time of Excel.
col2int
$iInt = col2int($sCol);
converts a excel row letter into an int for use in an array
This function was contributed by Kevin Mulholland.
int2col
$sCol = int2col($iRow);
convert a column number into column letters NOET: This is quite a brute force coarse method does not manage values over 701 (ZZ)
This function was contributed by Kevin Mulholland.
sheetRef
($iRow, $iCol) = sheetRef($sStr);
convert an excel letter-number address into a useful array address NOTE: That also Excel uses X-Y notation, we normally use Y-X in arrays
$sStr, excel coord (eg. A2).
This function was contributed by Kevin Mulholland.
xls2csv
$sCsvTxt = xls2csv($sFileName, $sRegion, $iRotate);
convert a chunk of an excel file into csv text chunk $sRegions = "sheet-colrow:colrow" (ex. '1-A1:B2' means 'A1:B2' for sheet 1) $iRotate
= 0 or 1 (output should be rotated or not)
This function was contributed by Kevin Mulholland.
AUTHOR
Rob Polocz rob.polocz@trackvia.com based on work by for Spreadsheet::ParseExcel by Kawai Takanori (Hippo2000) used with permission
SEE ALSO
Spreadsheet::ParseExcel, Spreadsheet::WriteExcel
COPYRIGHT
This module is part of the Spreadsheet::XLSX distribution.
perl v5.10.1 2010-05-16 Spreadsheet::XLSX::Utility2007(3pm)