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

Hi thanks for those, but none of them seem to work on my flavour DataGeneral unix

monsanbu

From the first script I get lots of the following:
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number
inputdate: bad number

VINO
I don't seem to have the "-d" option, so I have dumped an extract from the man pages below to hopefully help in solving

SYNOPSIS
touch [ -amc ] [-r ref_file | -t time] files
touch [ -amc ] [ mmddhhmm[yy] ] files

DESCRIPTION
Touch updates the access and modification times of each argument. If no time is specified the current time is used.
(See date(1) for a description of the second synopsis' time format.)

Options are:

-a Update only the access time.

-m Update only the modification time.

If neither -a nor -m is specified, the effect is the same as
-am.

-c Silently prevent touch from creating the file if it did not
previously exist.

-r ref_file
Use the corresponding time of ref_file instead of the current
time.

-t time Use time instead of the current time. time is a decimal
number of the form:
[[CC]YY]MMDDhhmm[.SS]

where each two digits represent the following:
MM month of the year (01-12)
DD day of the month (01-31)
hh hour of the day (00-23)
mm minute of the hour (00-59)
CC first two digits of the year (the century)
YY second two digits of the year
SS second of the minute (0-61)

CC and YY are optional. If neither is given, the current
year is assumed. If YY is specified, but CC is not, CC is
derived as follows:
If YY is: CC becomes:
------------------------
69-99 19
00-68 20

The range for SS is (00-61), because of leap seconds. If SS
is 60 or 61 and the resulting time, as affected by the TZ
environment variable, does not refer to a leap second; the
resulting time shall be one or two seconds after a time where
SS is 59. If SS is not given it is assumed to be zero.

DIAGNOSTICS
The following exit values are returned:

0 The utility executed successfully and all requested changes
were made.

>0 An error occurred.

SEE ALSO
date(1).
utime(2)

NOTESe--
The -t time option should be used in preference to the second
synopsis usage, since the second synopsis may not be supported in
future releases.

Last edited by Gerry405; 10-05-2005 at 11:09 AM..
 

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
touch(1)						      General Commands Manual							  touch(1)

NAME
touch - Updates file access and modification times SYNOPSIS
touch [-acfm] [-r reference_file | -t time] file... The following older syntax is now maintained for backward compatibility, but may be withdrawn in future issues: touch [-acfm] [time] file... STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: touch: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. OPTIONS
Changes only the access time. Suppresses the creation of the file. [Tru64 UNIX] Attempts to force the touch in spite of read and write permissions on a file. The -f option is actually a dummy option; it is not used by the touch code, but is recognized by getopt(). Changes only the modification time. Uses the time of the file named by the pathname reference_file instead of the current time. You cannot use -r and -t together. Uses the specified time instead of the current time. The time argument is a decimal number in the following form: [[CC]YY]MMDDhhmm[.SS] The paired decimal numbers in the preceding syntax line represent the following: The first two digits of the year (the century) The second two digits of the year (00-99) The month of the year (01-12) The day of the month (01-31) The hour of the day (00-23) The minute of the hour (00-59) The second of the minute (00-61) Both CC and YY are optional. If neither is specified, the current year is assumed. If YY is specified, but CC is not, CC is derived as follows: If YY is 69-99, CC is 19. If YY is 00-68, CC is 20. The resulting time is affected by the value of the TZ environment variable. If the resulting time value precedes the Epoch, touch exits immediately with an error status. The range of valid times past the Epoch extends to at least midnight 1 January 2000 UCT. The range for SS is 00-61 rather than 00-59 because of leap seconds. If SS is 60 or 61, and the resulting time, as affected by the TZ environment variable, does not refer to a leap second, the resulting time is one or two seconds after a time where SS is 59. If SS is not given a value, it is assumed to be 0 (zero). If neither the -a option nor the -m options are specified, touch behaves as if you have specified both options. OPERANDS
The file for which times should be modified, or which should be created. In the obsolescent version, if both the -r and -t options are omitted, and if the first file parameter is an eight or ten digit dec- imal integer, it is interpreted as a time parameter. The format for the time parameter in the obsolesent syntax is MMDDhhmm[YY] DESCRIPTION
The touch command updates the access and modification times of each file or directory named to the one specified on the command line or to the current time if you do not specify a time. You can specify the time with -t or by the time of the reference file with the -r option. If you do not specify a time, touch uses the current time. If you specify a file that does not exist, touch creates a file with that name unless you request otherwise with the -c option. The LC_TIME environment variable, if defined, specifies the order of month and day in the date specification and of hour and minute in the time specification. Otherwise, these orders default to MMdd and hhmm. The format for the time argument is MMddhhmm[yy]. The obsolescent format for the time argument is MMddhhmm[YY]. NOTES
The obsolescent version may be withdrawn from future versions of the XCU5.0 standards. The -r or -t options should be used. EXIT STATUS
The following exit values are returned: Successful completion. [Tru64 UNIX] The number of files whose times could not be successfully modified (including files that did not exist and were not created). When the -c option is specified, files are suppressed purposely, an error does not occur and a message is not written to standard error. The exit status returns zero (0) for success. EXAMPLES
To update the access and modification times of a file, enter: touch program.c This sets the last access and last modification times of program.c to the current date and time. If program.c does not exist, touch creates an empty file with that name. To avoid creating a new file, enter: touch -c program.c To update only the modification time, enter: touch -m *.o This updates only the last modification times of the files in the current directory that end with touch command is often used in this way to alter the results of the make command. To explicitly set the access and modification times, enter: touch -c 02171425 program.c This sets the access and modification dates to 14:25 (2:25 p.m.) February 17 of the current year. (This assumes that you are using the default format.) To touch a file with a numeric file name, include its full pathname or precede it with not mistaken for the time argument. For example, to touch the file 123.abc enter: touch -c ./123.abc ENVIRONMENT VARIABLES
The following environment variables affect the execution of touch: Provides a default value for the internationalization variables that are unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari- ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value, overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for- mat and contents of diagnostic messages written to standard error. [Tru64 UNIX] This environment variable, if defined, specifies the order of month and day in the date specification and of hour and minute in the time specification. Otherwise, these orders default to MMdd and hhmm. The format for the time argument is MMddhhmm[yy]. Determines the location of message catalogues for the processing of LC_MES- SAGES. Determines the time zone to be used for interpreting the time specification. SEE ALSO
Commands: date(1) Functions: creat(2), utime(2) Files: locale(4) Standards: standards(5) touch(1)
All times are GMT -4. The time now is 05:45 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy