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!

Register Log in
  • Congratulations TouchToneTommy 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: wilsonk
  • Content: Threads
  • Order by date
  1. wilsonk

    SQL*LOADER Control script with System Date input

    Good day. I've inherited a load process that uploads data into our Oracle database (unix platform). The control scripts (.ctl) require that I manually edit the date field (type constant) each time so that I can have today's date associated with the uploaded data. The date is not part of the...
  2. wilsonk

    Trouble preserving number format

    I am trying to save an Excel document to type csv with the number format 00000 (zip code format). Some zip codes have zeroes left-padded (00501). When I open the csv document, however, the number has reverted back to 501. I think I need to somehow convert the formatted 00501 to type text, but...
  3. wilsonk

    Assigning Dates to output file names

    I want to take a file and rename it with the current date: sample.txt > sample101601.txt The date format is not crucial, though I probably need a time stamp as well. I simply need a unique identifier for logging purposes. Any ideas are appreciated.

Part and Inventory Search

Back
Top