I have a Access 97 database that contains a date/time field. When I open the table and view the data it shows the entry as "5/2/03". However when I query the database using the .IDC files via the web interface it returns the entry as "2003-05-02 00:00:00". Can anyone tell me...
I have a field that I want to contain the Date and 24hr time. But I am having trouble enforcing the format. I am using a text field because I could not modify a date field to look the way I wanted (finished input should look like 12/25/03 2330 CTZ). I have a rule that sort of works but allows a...
Hi,
I have been asked to try and write a program that will log into a mainframe system and capture information about orders. This script will be on a LINUX box, and I believe that I can write the portion of the file that will log into the mainframe and pull up the order and display the...
I have a file that is a comma separated file with “ “ around each field. One of the fields has a comma inside of the field and I need to replace it with a space. Below is a sample entry before I have done anything to it, and the second is what I want the entry to look like afterwards. They are...
Ok, here is the deal. I have what I think should be a VERY easy task, accompanied by a brain freeze. What i need to do is to exctract the highest and lowest date from a file and assign them to two variables.
The file I am working with has three columns and the second and third columns are...
I need to split a date into three parts... month day year. The date currently is in this format 10/12/01 and I am trying to use the slpit command, but do not know what the correct syntax is to tell it split on the /.
$PsaDate = split( /(/)/, $Temp[1] );
I know this is an easy one, but I...
I have written a script that imports a flat file which contains several dates on each line. The current format is YearMonthDay or 20011231 and I need to change then to MonthDayYear or 12312001. Each date is being handled as a variable such as $Line[0]. I was thinking I could split the string...
I am trying to create a file called CSCH.CSV on a daily bases and want to include the date in the file name so that it would look like CSCH 20011129.csv but have been unsuccesfull in doing so. I have the date stored as a variable and am able to print it fine. However when I try to create a file...
I am running perl on the d drive of an NT machine, and I have a text file that I want to open from a novell network drive that i have mapped as a G drive... could anyone tell me the correct syntax for this????
open( INITIALS , "G:\aa&t\Flat_Files\initials.txt" )
open( INITIALS ...
I am looking for a resorce to teach me how to create a DOS boot disk that will allow me to do a "net use" command to map a network drive for the purpose of ghosting. I am using ghost 2001 and do not want to have both PCs booted up in DOS. I know there are several programs that will...
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.