Sponsored Content
Top Forums Shell Programming and Scripting Insert rows with computations of next row Post 302147200 by Jae on Monday 26th of November 2007 12:30:45 AM
Old 11-26-2007
It is closer but not right.

Thanks summer_cherry;
It is very closer, but I am not able to get the right answer using your script, either. Two time steps are missing in the output.
1987-01-01-22Z and 1987-01-01-23Z.
I think the script should have special care of midnight (00Z) in order to make 22Z and 23Z by subtracting 2 and 1, respectively.
For example,
2 hour time lag of 1987-02-01-00Z should be 1987-01-01-22Z, and
1 hour time lag of 1987-02-01-00Z should be 1987-01-01-23Z.

I appreciate your kind help.

Jae
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Concatenate 2 rows into 1 row

I need to search a file for two values (valueA & valueB). ValueA will be on a different row than valueB, and concatenate the two together on the same row of my output. Example: search input file for strings "node" and "OS", combine the two results into one row input node A text text OS... (4 Replies)
Discussion started by: indianadoug
4 Replies

2. UNIX for Dummies Questions & Answers

insert header row into .xls

Hello, I am building an .xls file extracting info from a DB to be eventually emailed. All is good except how do I put in a header row.. like date, name of report etc. before the columns with the actual column name and data? Thanks for any assistance.. the below is after I have signed into... (11 Replies)
Discussion started by: Tish
11 Replies

3. Shell Programming and Scripting

How to insert data befor some field in a row of data depending up on values in row

Hi I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example. The original data record should be some thing like this 60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies

4. Shell Programming and Scripting

insert txt in the row

hi i am having text file like this 444 raju 666 ranga Clerk 999 rani officer 111 juhi i want to get the out put as 444 raju NA 666 ranga Clerk 999 rani officer 111 juhi NA pls help (5 Replies)
Discussion started by: suryanarayana
5 Replies

5. UNIX for Advanced & Expert Users

convert rows to single row

Hi I want to convert multiple rows ro single row ,I have tried with below one but I am not getting what I am expecting.Please any idea a.txt conn1=stg conn2=dev path=\xxx\a1.txt fre=a conn1=stg conn2=dev path=\xxx\a2.txt freq=a awk '/a/{ORS=" "}{print}END{print "\n"}'... (5 Replies)
Discussion started by: akil
5 Replies

6. UNIX for Advanced & Expert Users

Converting rows to a single row

Hi all I have a file as below : Development System User Production i want to convert the file to below format: "Development","System","User","Production" Is it possible with UNIX ? if so can you please give me some direction on it ? Thanks, Satya Use code tags please, ty. (10 Replies)
Discussion started by: satyaranjon
10 Replies

7. UNIX for Dummies Questions & Answers

Insert rows with some rules??

Hi, I am rather new to Unix/Linus. I have this problem that I would like to solve using unix. Here is what I have start stop expression 1 5 15 2 6 10 I want a output like this position expression 1 15 2 25 3 ... (1 Reply)
Discussion started by: wanghlv
1 Replies

8. Shell Programming and Scripting

Print various rows in one row

I have this in a file 11.22.33.44 yyyyyyuser With awk/sed, I need this to be output as follows alias server.domain.com='ssh yyyyyyuser@11.22.33.44' (4 Replies)
Discussion started by: anil510
4 Replies

9. UNIX for Dummies Questions & Answers

Insert row into empty file...how?

Greetings: I generate an empty flat file just fine when there's no data returned from my process, as the customer wants one always (using the 1st line of the below script). However, they also want at least the column names in this flat file (row 1, the only row to be in the emply file). I'm... (7 Replies)
Discussion started by: Benrosa
7 Replies

10. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies
GETDATE(3)						   BSD Library Functions Manual 						GETDATE(3)

NAME
getdate, getdate_err -- convert user format date and time LIBRARY
Standard C Library (libc, -lc) SYNOPSIS
#include <time.h> struct tm * getdate(const char *str); extern int getdate_err; DESCRIPTION
The getdate() function converts a date or time character string pointed to by str into a static tm structure described in tm(3). The input string is parsed and interpreted using templates. A text file containing templates is specified by the environment variable DATEMSK. This should contain the full path to the template file. Lines in the template file represent acceptable date and/or time conver- sion specifications. These specifications are similar to those given for strptime(3). The first line in the template file that matches the input string is used to interpret and convert to internal time format. Internal Format Conversion The following rules apply to converting the input into the internal format. o If only the weekday is given, the conversion assumes today when the weekday matches today or the first future matching weekday. o If only the month and no year is given, the conversion assumes the current month when the month matches or the first future match- ing month. The first day of the month is assumed if no day is given. o If only the year is given, the values of the tm_mon, tm_mday, tm_wday, tm_yday, and tm_isdst members of the returned struct tm are unspecified. o If the century is given, but the year within the century is not given, the conversion assumes the current year. o If no hour, minute, and second are given, the conversion assumes the current hour, minute, and second. o If no date is given, the conversion assumes today when the given hour is greater than the current hour and tomorrow when the given hour is less. o If %Z is being scanned, then the broken-down time is based on the the current time of the matched timezone and not the current run- time environment timezone. RETURN VALUES
If successful, the getdate() function returns a pointer to a static tm structure containing the broken-down time. Otherwise, a null pointer is returned and getdate_err is set to indicate the error. The variable getdate_err can have the following values: 1 DATEMSK environment variable is null or undefined. 2 Cannot open the template file for reading. 3 Get file status failed for template file. 4 Template file is not a regular file. 5 Encountered an error while reading the template file. 6 Cannot allocate memory. 7 Input string does not match any line in the template file. 8 Input string is invalid (for example February 31) or could not be represented in a time_t. ENVIRONMENT
DATEMSK The full path to the text file containing the templates for acceptable date and/or time conversions. FILES
/usr/share/examples/getdate/datemsk.template An example template file that could be specified via the DATEMSK environment variable. EXAMPLES
The following example shows the possible contents of a template file: %m %A %B %d, %Y, %H:%M:%S %A %B %m/%d/%y %I %p %d,%m,%Y %H:%M at %A the %dst of %B in %Y run job at %I %p, %B %dnd %A den %d. %B %Y %H.%M Uhr The following are examples of valid input for the above template: 10/1/87 4 PM Friday Firday September 18, 1987, 10:30:30 24,9,1986 10:30 at monday the 1st of december in 1986 run job at 3 PM, december 2nd The following examples show how local data and time specification can be defined in the template. Input String Line in Template 11/27/86 %m/%d/%y 27.11.86 %d.%m/%y 86-11-27 %y-%m-%d Friday 12:00:00 %A %H:%M:%S The following examples illustrate the Internal Format Conversion rules given that the current date is Mon Sep 22 12:19:47 EDT 1986 and the LC_TIME environment variable is set to the default C locale. Input String Line in Template Date Mon %a Mon Sep 22 12:19:47 EDT 1986 Sun %a Sun Sep 28 12:19:47 EDT 1986 Fri %a Sun Sep 26 12:19:47 EDT 1986 September %B Mon Sep 1 12:19:47 EDT 1986 January %B Thu Jan 1 12:19:47 EST 1987 December %B Mon Dec 1 12:19:47 EST 1987 Sep Mon %b %a Mon Sep 1 12:19:47 EDT 1986 Jan Fri %b %a Fri Jan 2 12:19:47 EDT 1987 Dec Mon %b %a Mon Dec 1 12:19:47 EDT 1986 Jan Wed 1989 %b %a %Y Wed Jan 4 12:19:47 EST 1989 Fri 9 %a %H Fri Sep 26 09:00:00 EDT 1986 Feb 10:30 %b %H:%S Sun Feb 1 10:00:30 EST 1987 10:30 %H:%M Tue Sep 23 10:30:00 EDT 1986 13:30 %H:%M Tue Sep 22 13:30:00 EDT 1986 SEE ALSO
ctime(3), localtime(3), mktime(3), strftime(3), strptime(3), time(3) STANDARDS
The getdate() function conforms to IEEE Std 1003.1-2001 (``POSIX.1''). HISTORY
The getdate function appeared in AT&T System V Release 4 UNIX. BUGS
The getdate interface is inherently unsafe for multi-threaded programs or libraries, since it returns a pointer to a static variable and uses a global state variable. BSD
April 14, 2011 BSD
All times are GMT -4. The time now is 11:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy