Recent content by wilsonk

Thank you for the information. I'm going to give these ideas a try and locate a copy of the 8i utilities manual. Again, Thanks!

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

Thanks for the contributions. I understand what's happening now. When I save it in zip-code format, the 501 is saved as 00501. But when I re-open it in Excel, it displays as 501 still (which is where I was looking). Opening the file in Word shows the zeroes still pre-pended. I'm a happy...

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

The back ticks do the trick. Thank you both!

Good idea, but when I try it, Unix (or the shell) treats the command literally. So, mv sample.txt "sample'date+%m%d%y'.txt" yields: sample'date+%m%d%y'.txt I'm wondering if Unix (or the shell) can handle system variables in renaming commands. I haven't found any documentation on...

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.