Sponsored Content
Top Forums Shell Programming and Scripting Awk - how to select the column based on day of month Post 302454455 by Gizmo1007 on Saturday 18th of September 2010 10:01:51 AM
Old 09-18-2010
Awk - how to select the column based on day of month

Problem,

How can you pass today's date (eg) 18 into Awk and select the field representing the 18th column?

I have an output that I want to interact with based on what day it is

information=0:0 192:0 5436:0 22:99 0:0 0:0 1234:0 1359:09

Code:
 
DAY=date'+%d'

numbrs=`$information | awk '{print $DAY}'| sed "s/:/ + /g"`

any help?

Many thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Write a shell script to find whether the first day of the month is a working day

Hi , I am relatively new to unix... Can u pls help me out to find out if the first day of the month is a working day ie from (Monday to Friday)...using Date and If clause in Korn shell.. This is very urgent. Thanks for ur help... (7 Replies)
Discussion started by: phani
7 Replies

2. UNIX for Dummies Questions & Answers

Select records based on search criteria on first column

Hi All, I need to select only those records having a non zero record in the first column of a comma delimited file. Suppose my input file is having data like: "0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005" "0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"... (2 Replies)
Discussion started by: shashi_kiran_v
2 Replies

3. Shell Programming and Scripting

Select Record based on First Column

Hi, I have a file with multiple records...and I have to select records based on first column....here is the sample file... I01,abc,125,1a2,LBVI02 I01,abc,126,2b5,LBVI02 I02,20070530,254,abc,LLBI01 I02,20070820,111,bvd,NGBI01 I need all records with I01 in first field in one file and... (8 Replies)
Discussion started by: mgirinath
8 Replies

4. Shell Programming and Scripting

Script to find previous month last day minus one day timestamp

Hi All, I need to find the previous month last day minus one day, using shell script. Can you guys help me to do this. My Requirment is as below: Input for me will be 2000909(YYYYMM) I need the previous months last day minus 1 day timestamp. That is i need 2000908 months last day minus ... (3 Replies)
Discussion started by: girish.raos
3 Replies

5. Shell Programming and Scripting

awk to select rows based on condition on column

I have got a file like this 003ABC00281020091005000100042.810001 ... (8 Replies)
Discussion started by: Maruti
8 Replies

6. Shell Programming and Scripting

Code creates day 32 instead of 1st day of next month.

I am using the code below modified from a post I saw here regarding having the script write out future dates. The problem is that instead of making 8/1 it makes 7/32! Please help! yy=`date +%Y` mm=`date +%m` dd=`date +%d` echo "Today is : $yy $mm $dd" #!/usr/bin/ksh date '+%m... (5 Replies)
Discussion started by: libertyforall
5 Replies

7. Shell Programming and Scripting

Script to counting a specific word in a logfile on each day of this month, last month etc

Hello All, I am trying to come up with a shell script to count a specific word in a logfile on each day of this month, last month and the month before. I need to produce this report and email it to customer. Any ideas would be appreciated! (5 Replies)
Discussion started by: pnara2
5 Replies

8. Shell Programming and Scripting

Julian day to dates in YEAR-MONTH-DAY

hello, I have many files called day001, day002, day003 and I want to rename them by day20070101, day20070102, etc. I need to do it for several years and leap years as well. What is the best way to do it ? Thank you. (1 Reply)
Discussion started by: Ggg
1 Replies

9. Shell Programming and Scripting

awk to select lines with maximum value of each record based on column value

Hello, I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record? Input: A1 chr5D 634 7 82 707 A2 chr5D 637 6 82 713 A3 chr5D 637 5 82 713 A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies

10. UNIX for Beginners Questions & Answers

Select and copy .csv files based on row and column number

Dear UNIX experts, I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum. I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains... (8 Replies)
Discussion started by: rcsapo
8 Replies
Date::ISO8601(3pm)					User Contributed Perl Documentation					Date::ISO8601(3pm)

NAME
Date::ISO8601 - the three ISO 8601 numerical calendars SYNOPSIS
use Date::ISO8601 qw(present_y); print present_y($y); use Date::ISO8601 qw(month_days cjdn_to_ymd ymd_to_cjdn present_ymd); $md = month_days(2000, 2); ($y, $m, $d) = cjdn_to_ymd(2406029); $cjdn = ymd_to_cjdn(1875, 5, 20); print present_ymd(2406029); print present_ymd(1875, 5, 20); use Date::ISO8601 qw(year_days cjdn_to_yd yd_to_cjdn present_yd); $yd = year_days(2000); ($y, $d) = cjdn_to_yd(2406029); $cjdn = yd_to_cjdn(1875, 140); print present_yd(2406029); print present_yd(1875, 140); use Date::ISO8601 qw(year_weeks cjdn_to_ywd ywd_to_cjdn present_ywd); $yw = year_weeks(2000); ($y, $w, $d) = cjdn_to_ywd(2406029); $cjdn = ywd_to_cjdn(1875, 20, 4); print present_ywd(2406029); print present_ywd(1875, 20, 4); DESCRIPTION
The international standard ISO 8601 "Data elements and interchange formats - Information interchange - Representation of dates and times" defines three distinct calendars by which days can be labelled. It also defines textual formats for the representation of dates in these calendars. This module provides functions to convert dates between these three calendars and Chronological Julian Day Numbers, which is a suitable format to do arithmetic with. It also supplies functions that describe the shape of these calendars, to assist in calendrical calculations. It also supplies functions to represent dates textually in the ISO 8601 formats. ISO 8601 also covers time of day and time periods, but this module does nothing relating to those parts of the standard; this is only about labelling days. The first ISO 8601 calendar divides time up into years, months, and days. It corresponds exactly to the Gregorian calendar, invented by Aloysius Lilius and promulgated by Pope Gregory XIII in the late sixteenth century, with AD (CE) year numbering. This calendar is applied to all time, not just to dates after its invention nor just to years 1 and later. Thus for ancient dates it is the proleptic Gregorian calendar with astronomical year numbering. The second ISO 8601 calendar divides time up into the same years as the first, but divides the year directly into days, with no months. The standard calls this "ordinal dates". Ordinal dates are commonly referred to as "Julian dates", a mistake apparently deriving from true Julian Day Numbers, which divide time up solely into linearly counted days. The third ISO 8601 calendar divides time up into years, weeks, and days. The years approximate the years of the first two calendars, so they stay in step in the long term, but the boundaries differ. This week-based calendar is sometimes called "the ISO calendar", apparently in the belief that ISO 8601 does not define any other. It is also referred to as "business dates", because it is most used by certain businesses to whom the week is the most important temporal cycle. The Chronological Julian Day Number is an integral number labelling each day, where the day extends from midnight to midnight in whatever time zone is of interest. It is a linear count of days, where each day's number is one greater than the previous day's number. It is directly related to the Julian Date system: in the time zone of the prime meridian, the CJDN equals the JD at noon. By way of epoch, the day on which the Convention of the Metre was signed, which ISO 8601 defines to be 1875-05-20 (and 1875-140 and 1875-W20-4), is CJDN 2406029. This module places no limit on the range of dates to which it may be applied. All function arguments are permitted to be "Math::BigInt" or "Math::BigRat" objects in order to achieve arbitrary range. Native Perl integers are also permitted, as a convenience when the range of dates being handled is known to be sufficiently small. FUNCTIONS
Numbers in this API may be native Perl integers, "Math::BigInt" objects, or integer-valued "Math::BigRat" objects. All three types are acceptable for all parameters, in any combination. In all conversion functions, the most-significant part of the result (which is the only part with unlimited range) is of the same type as the most-significant part of the input. Less-significant parts of results (which have a small range) are consistently native Perl integers. All functions "die" if given invalid parameters. Years present_y(YEAR) Puts the given year number into ISO 8601 textual presentation format. For years [0, 9999] this is simply four digits. For years outside that range it is a sign followed by at least four digits. This is the minimum-length presentation format. If it is desired to use a form that is longer than necessary, such as to use at least five digits for all year numbers (as the Long Now Foundation does), then the right tool is "sprintf" (see "sprintf" in perlfunc). This format is unconditionally conformant to all versions of ISO 8601 for years [1583, 9999]. For years [0, 1582], preceding the historical introduction of the Gregorian calendar, it is conformant only where it is mutually agreed that such dates (represented in the proleptic Gregorian calendar) are acceptable. For years outside the range [0, 9999], where the expanded format must be used, the result is only conformant to ISO 8601:2004 (earlier versions lacked these formats), and only where it is mutually agreed to use this format. Gregorian calendar Each year is divided into twelve months, numbered [1, 12]; month number 1 is January. Each month is divided into days, numbered sequentially from 1. The month lengths are irregular. The year numbers have unlimited range. month_days(YEAR, MONTH) The parameters identify a month, and the function returns the number of days in that month as a native Perl integer. cjdn_to_ymd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year, month, and day. ymd_to_cjdn(YEAR, MONTH, DAY) This performs the reverse of the translation that "cjdn_to_ymd" does. It takes year, month, and day numbers, and returns the corresponding CJDN. present_ymd(CJDN) present_ymd(YEAR, MONTH, DAY) Puts the given date into ISO 8601 Gregorian textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, MONTH, DAY) triplet then these are not checked for consistency. The MONTH and DAY values are only checked to ensure that they fit into the fixed number of digits. This allows the use of this function on data other than actual Gregorian dates. Ordinal dates Each year is divided into days, numbered sequentially from 1. The year lengths are irregular. The years correspond exactly to those of the Gregorian calendar. year_days(YEAR) The parameter identifies a year, and the function returns the number of days in that year as a native Perl integer. cjdn_to_yd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year and ordinal day. yd_to_cjdn(YEAR, DAY) This performs the reverse of the translation that "cjdn_to_yd" does. It takes year and ordinal day numbers, and returns the corresponding CJDN. present_yd(CJDN) present_yd(YEAR, DAY) Puts the given date into ISO 8601 ordinal textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, DAY) pair then these are not checked for consistency. The DAY value is only checked to ensure that it fits into the fixed number of digits. This allows the use of this function on data other than actual ordinal dates. Week-based calendar Each year is divided into weeks, numbered sequentially from 1. Each week is divided into seven days, numbered [1, 7]; day number 1 is Monday. The year lengths are irregular. The year numbers have unlimited range. The years correspond to those of the Gregorian calendar. Each week is associated with the Gregorian year that contains its Thursday and hence contains the majority of its days. year_weeks(YEAR) The parameter identifies a year, and the function returns the number of weeks in that year as a native Perl integer. cjdn_to_ywd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year, week, and day. ywd_to_cjdn(YEAR, WEEK, DAY) This performs the reverse of the translation that "cjdn_to_ywd" does. It takes year, week, and day numbers, and returns the corresponding CJDN. present_ywd(CJDN) present_ywd(YEAR, WEEK, DAY) Puts the given date into ISO 8601 week-based textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, WEEK, DAY) triplet then these are not checked for consistency. The WEEK and DAY values are only checked to ensure that they fit into the fixed number of digits. This allows the use of this function on data other than actual week- based dates. SEE ALSO
Date::JD, DateTime AUTHOR
Andrew Main (Zefram) <zefram@fysh.org> COPYRIGHT
Copyright (C) 2006, 2007, 2009 Andrew Main (Zefram) <zefram@fysh.org> LICENSE
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2010-03-30 Date::ISO8601(3pm)
All times are GMT -4. The time now is 08:06 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy