Recent content by awood69

I have a file named like this report_nbr.xml.2356 need to copy it and call it report_nbr.xml Very new to KORN, need all the help I can get. Thanks

Very cool thanks a lot!

Is there a way to do it without using the " * "?

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.

Andy, thanks for the response but that will still show the decimal.

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

If I change the data to - 11, 12 and use select * from region where email_flag = 'Y' and ((region in(SELECT comments from report_dist where group_type = 'PLT01') and 'PLT01' like 'PLT%') or 'PLT01' NOT LIKE 'PLT%') order by region I...

If i change the data to a single number then it works. Maybe I need another approach?

Thanks but that didn't work still get - Example data - '11, 12' ORA-01722: invalid number select * from region where email_flag = 'Y' and ((to_char(region) in(SELECT to_number(comments, '99') from report_dist where group_type = 'PLT01')...

I get ORA-01722: invalid number select * from region where email_flag = 'Y' and ((region in(SELECT to_number(comments, '99') from report_dist where group_type = 'PLT01') and 'PLT01' like 'PLT%') or 'PLT01' NOT LIKE 'PLT%') order by region

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 =...

Thanks but that didn't do it, I get the same messages.

I keep getting these errors... unknown command beginning "case "PLT0..." - rest of line ignored unknown command beginning "PLT01) sql..." - rest of line ignored unknown command "esac" - rest of line ignored For a list of known commands enter HELP to leave enter EXIT here is my code function...