Sponsored Content
Top Forums UNIX for Dummies Questions & Answers converting 6 digit column to dates format Post 85428 by Gerry405 on Wednesday 5th of October 2005 10:46:44 AM
Old 10-05-2005
dates

Hi Again Vino,


Sorry to be a pain but I now get an error..
UX:sh (./DateVino): ERROR: Bad substitution

#! /bin/sh
# gerry.sh
# input 071205
# output Dec 07 2005
# Base date is Oct 19, 2005.

touch -t 0509190000 /tmp/BASE

while read line
do
DAY=${line%????}
line=${line#$DAY}
MON=${line%??}
YR=${line#??}

case "$MON" in
"01") mon=Jan ;;
"02") mon=Feb ;;
"03") mon=Mar ;;
"04") mon=Apr ;;
"05") mon=May ;;
"06") mon=Jun ;;
"07") mon=Jul ;;
"08") mon=Aug ;;
"09") mon=Sep ;;
"10") mon=Oct ;;
"11") mon=Nov ;;
"12") mon=Dec ;;
esac
touch -t "$YR$mon$DAY0000" /tmp/FILEOLD
if [ "/tmp/FILEOLD" -nt "/tmp/BASE" ] ; then
echo "$mon $DAY $YR is newer"
else
echo "$mon $DAY $YR is older"
fi ;
done < gerry.txt

rm -f /tmp/BASE /tmp/FILEOLD
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Format dates

I have a date that is received as text in Jan 1 2002 12:00AM format. Can anyone give me any ideas how to format that in oracle format i.e. 01-JAN-02 (1 Reply)
Discussion started by: jinky
1 Replies

2. UNIX for Advanced & Expert Users

Select entries between two dates by converting Unix timestamp in Oracle Database.

Hi, I need to select the entries between two dates from an Oracle db. The Oracle db has a column with Unix timestamps. I use the following querry, but it doesnt seem to be working as desired. select count(*) from reporter_status where to_char(FIRSTOCCURRENCE, 'mm-dd-yy') between ('08-07-06')... (1 Reply)
Discussion started by: amitsayshii
1 Replies

3. Shell Programming and Scripting

Need script to generate all the dates in DDMMYY format between 2 dates

Hello friends, I am looking for a script or method that can display all the dates between any 2 given dates. Input: Date 1 290109 Date 2 010209 Output: 300109 310109 Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies

4. Shell Programming and Scripting

Split large file based on last digit from a column

Hello, What's the best way to split a large into multiple files based on the last digit in the first column. input file: f 2738483300000x0y03772748378831x1y13478378358383x2y23743878383802x3y33787828282820x4y43748838383881x5y5 Desired Output: f0 3738483300000x0y03787828282820x4y4 f1... (9 Replies)
Discussion started by: alain.kazan
9 Replies

5. Shell Programming and Scripting

Dates not comparing correct even the same format

I have the date of the file passed into a variable also current date formatted same passed into a separate variable and compare the two with an if statement and statement always comes up false. Even though I verified the dates. Any help would be awesome. Filecrtdate=`ls -l $i | awk '{print... (19 Replies)
Discussion started by: coderanger
19 Replies

6. Shell Programming and Scripting

Converting windows format file to unix format using script

Hi, I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix. My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies

7. Shell Programming and Scripting

command for converting 4 column data to 1 column

dear friends I want to convert four column data to one column data. For example: from 1, 2, 3, 4 5, 6, 7, 8to 1 2 3 4 5 6 7 8what is the general command for that type of convertion. thanks (5 Replies)
Discussion started by: rpf
5 Replies

8. UNIX for Dummies Questions & Answers

Converting column to rows for every 3 lines in the column

Hi gurus! Please help me with this one. I have an file with the following contents: a b c d e f g h i j I would like to make to transform it to look like this as my output file: a,b,c d,e,f (4 Replies)
Discussion started by: kokoro
4 Replies

9. Shell Programming and Scripting

Converting Single Column into Multiple rows, but with strings to specific tab column

Dear fellows, I need your help. I'm trying to write a script to convert a single column into multiple rows. But it need to recognize the beginning of the string and set it to its specific Column number. Each Line (loop) begins with digit (RANGE). At this moment it's kind of working, but it... (6 Replies)
Discussion started by: AK47
6 Replies

10. UNIX for Dummies Questions & Answers

Converting dates to iso format

Hi , i am trying to read a tsv file record by record and change the date column with iso date format. it have different dates with format like mm/dd/yyyy HH:MM:SS EST ,i am trying serarch for the date format lke this yyyy-mm-dd HH:MM:SS EST and replace to it if dosent match that format . Any... (2 Replies)
Discussion started by: vikatakavi
2 Replies
monitor(3C)						   Standard C Library Functions 					       monitor(3C)

NAME
monitor - prepare process execution profile SYNOPSIS
#include <mon.h> void monitor(int (*lowpc(), int (*highpc)(), WORD *buffer, size_t bufsize, size_t nfunc); DESCRIPTION
The monitor() function is an interface to the profil(2) function and is called automatically with default parameters by any program created by the cc(1B) utility with the -p option specified. Except to establish further control over profiling activity, it is not necessary to explicitly call monitor(). When used, monitor() is called at least at the beginning and the end of a program. The first call to monitor() initiates the recording of two different kinds of execution-profile information: execution-time distribution and function call count. Execution-time distribution data is generated by profil() and the function call counts are generated by code supplied to the object file (or files) by cc(1B) -p. Both types of information are collected as a program executes. The last call to monitor() writes this collected data to the output file mon.out. The name of the file written by monitor() is controlled by the environment variable PROFDIR. If PROFDIR does not exist, the file mon.out is created in the current directory. If PROFDIR exists but has no value, monitor() does no profiling and creates no output file. If PROFDIR is dirname, and monitor() is called automatically by compilation with cc -p, the file created is dirname/pid.progname where progname is the name of the program. The lowpc and highpc arguments are the beginning and ending addresses of the region to be profiled. The buffer argument is the address of a user-supplied array of WORD (defined in the header <mon.h>). The buffer argument is used by moni- tor() to store the histogram generated by profil() and the call counts. The bufsize argument identifies the number of array elements in buffer. The nfunc argument is the number of call count cells that have been reserved in buffer. Additional call count cells will be allocated auto- matically as they are needed. The bufsize argument should be computed using the following formula: size_of_buffer = sizeof(struct hdr) + nfunc * sizeof(struct cnt) + ((highpc-lowpc)/BARSIZE) * sizeof(WORD) + sizeof(WORD) - 1 ; bufsize = (size_of_buffer / sizeof(WORD)); where: o lowpc, highpc, nfunc are the same as the arguments to monitor(); o BARSIZE is the number of program bytes that correspond to each histogram bar, or cell, of the profil() buffer; o the hdr and cnt structures and the type WORD are defined in the header <mon.h>. The default call to monitor() is as follows: monitor (&eprol, &etext, wbuf, wbufsz, 600); where: o eprol is the beginning of the user's program when linked with cc -p (see end(3C)); o etext is the end of the user's program (see end(3C)); o wbuf is an array of WORD with wbufsz elements; o wbufsz is computed using the bufsize formula shown above with BARSIZE of 8; o 600 is the number of call count cells that have been reserved in buffer. These parameter settings establish the computation of an execution-time distribution histogram that uses profil() for the entire program, initially reserves room for 600 call count cells in buffer, and provides for enough histogram cells to generate significant distribution- measurement results. For more information on the effects of bufsize on execution-distribution measurements, see profil(2). EXAMPLES
Example 1 Example to stop execution monitoring and write the results to a file. To stop execution monitoring and write the results to a file, use the following: monitor((int (*)())0, (int (*)())0, (WORD *)0, 0, 0); Use prof to examine the results. USAGE
Additional calls to monitor() after main() has been called and before exit() has been called will add to the function-call count capacity, but such calls will also replace and restart the profil() histogram computation. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |MT-Level |Safe | +-----------------------------+-----------------------------+ SEE ALSO
cc(1B), profil(2), end(3C), attributes(5), prof(5) SunOS 5.11 29 Dec 1996 monitor(3C)
All times are GMT -4. The time now is 09:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy