I have a file name like this
report_name.xml.12345
where the 12345 was added by using the $$
I need to remove the
.12345 from the end of the filename before I email it out.
Thanks in advance.
I need to be able to use the same style for multiple number formats. For example, I need to show anywhere between 0 & 2 decimal places. I have this like below -
<NumberFormat ss:Format="#,###.##;[Red]\(-#,###.##\)"/>
Problem is I get the following results and I need to not show the decimal...
I have a sqr program that I am using to create a XLS file. I need to be able to enter what column I want the data printed to.
Like below but need the 1, 2, 3 to represent the column number in XLS.
do xml-init-column(#xml_file_number, 1, 48)
do xml-init-column(#xml_file_number, 2, 51)
do...
Newbie to ksh any help would be appreciated.
I need to loop through a directory and copy all the *.xls files to a different directory based off of what value is returned by a sql query. Something like this...
for each file in folder
where file like *.xls
run sql
cp to new folder
I a column names comments, the record I am working with has the following value in comments - '11, 12'
I want to use this select statement as a sub query that would replace the 11, 12 for region in the bottom statement -
SELECT to_number(comments, '99')
from report_dist
where group_type =...
I have a function and based on a parameter I need to call different sql statement something like below?
function get_regions {
sqlplus -s <<EOF
$CONNECT_DB2
set pause off
set heading off
set pagesize 0
set feedback off
Case $var = "XXX"
case ZZZ
do this sql statement
case DDD
do this...
I am new to Korn program and trying to do a simple task.
$group_type = "PLT01"
if [[ $group_type == PLT* ]]
then
print "Success"
fi
Not sure why this will not work?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.