Hello Expert,
I have a file in the following format:
Code:
SYNTAX_VERSION 5
MONITOR "NAME_TEMPLATES"
DESCRIPTION "Monitors for contents of error "
INTERVAL "1m"
MONPROG "script.sh NAME_TEMPLATES"
MAXTHRESHOLD
GEN_BELOW_RESET
SEVERITY Major
APPLICATION "script.sh"
MSGGRP "MSG"
MSGCONDITIONS
DESCRIPTION "Has NEW errors"
CONDITION_ID "00000-34dc-25e0-1cfe-0a088b060000"
CONDITION
OBJECT "<#>diff<*.folder>"
THRESHOLD 0.500000
RESET 0.500000
SET
OBJECT "<$OPTION(area)>"
TEXT "There have been new failures Processing the <$OPTION(area)>
file on Central.
AUTOACTION "ls <folder>" ANNOTATE
HELPTEXT "OPS
=========
Please call support team"
HELP "0d152f3c-59dc-71e0-1cfe-0a034b060000"
DESCRIPTION "Has ANY errors"
CONDITION_ID "d26dda06-55f2-71e0-0025-0a034b060000"
CONDITION
OBJECT "<*.folder>"
THRESHOLD 0.500000
RESET 0.500000
SET
OBJECT "<$OPTION(area)>"
TEXT "There has been a failure Processing the <$OPTION(area)> file
HELPTEXT "OPS
=========
Please call out the support team"
others instruction
others instruction
HELP "0d152f3c-59dc-71e0-1cfe-0a034b060000"
I would like to transform it in .csv or .xls file.
Hi,
I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused:
Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Hi,
having two csv files, both sorted, by key (column1), f1 containing duplicate keys and f2 containing no duplicate keys, how can I obtain all rows from f1 with the keys listed in file2? Example:
f1 is:
k1,gsj01fd
k2,vi982cj
k2,1fjk01e
k3,81kjfds
k4,sd9dasi
f2 is:
k2
k3
and I... (3 Replies)
Hi,
I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this?
I'm struggling on this.
Thanks (11 Replies)
Hi All,
I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box .
I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Hi All,
I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file.
I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box.
Perl code should have 2 params while running. i.e
perl... (1 Reply)
There can be thousand of .ksh in a specific directory where sql files are called from ksh.
Requirement is to loop through all the files content and generate a report like below:
Jobname Type type sqlname
gemd1970 sql daily tran01
gemw1971 sql weekly ... (6 Replies)