Hi
I want to grep a column 6 & column 7 from a CSV Format file & then i have to find the difference between these columns as these both columns contains date & time in 7/7/2012 9:20 this format .
Hi,
When I use the `date' command on RHEL5, I can get the time shown in 24 hr format. I wonder if the time can be shown in 12 hr format. But I don't want to use the `date +FORMAT' to do that, neither `alias date='date +FORMAT''. I just want a simple `date' to show time in 12hr format.
Is there any configuration file about the 12/24 hr format?
can anyone one help me....to make date and time format...to following format for my file
Code:
DATE TIME
DD- MON- YEAR 24 Hours
I have a need of format like this
12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me...
currently we are up
There's a file whose date format for the year 2012 are currently in mddyyyy format that we are trying to change to mmddyyyy.
Hi All,
I need to convert an exel spreadsheet into a SAS dataset,
and the following format change is needed.
I have a CSV file with the below data minor changes are required.
while generating CSV file from excel sheet ,date(Format :Mon 8/28/2012)
got converted into the below format with numbers 41148,41149 so on.
Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual date(Format :Mon 8/28/2012).
Code:
abc.net1,BW: 1.07 M,,,,,,,,,,,,,,,,,,,,,,,
Hrly Avg (IN
Hello,
I need some sort of way to extract every date contained in a file, and count how many of those dates there are.
Here are the specifics:The date format I'm looking for is mm/dd/yyyy
I only need to look after line 45 in the file (that's where the data begins)
The columns of data are seperated by indents/tabs, I need to look at the 4th column
I'll take any advice I can get, I just don't
I am trying to figure out how to assign columns of a text file to the day of the month. The end result will be a way to determine when each day (column) is populated with data.
When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please.