Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: awood69
  • Content: Threads
  • Order by date
  1. awood69

    KORN Copy file with PID and rename it

    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
  2. awood69

    KORN Remove PID from FIlename

    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.
  3. awood69

    Number Formatting in XLS

    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...
  4. awood69

    SQR to XLS Column Number

    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...
  5. awood69

    ksh for each file in a directory

    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
  6. awood69

    to_number PL/SQL

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

    sqlplus and Korn case statement

    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...
  8. awood69

    Korn string compair

    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?

Part and Inventory Search

Back
Top