Sponsored Content
Homework and Emergencies Homework & Coursework Questions How to use xargs to repeat as a loop to grab date string? Post 302926592 by Corona688 on Tuesday 25th of November 2014 11:02:30 AM
Old 11-25-2014
If you rearrange the date into YYYY/MM/DD HH:MM:SS, it sorts alphabetically and can be compared by simple > >= < <= in awk.
Code:
$ cat dcomp.awk

BEGIN {
        FS="[ \t\\[\\]/:]+"
        split("Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec", A);
        for(X in A)     MON[A[X]]=sprintf("%02d", X);
}

function ymd() {
        return(sprintf("%s/%s/%s %02d:%02d:%02d", $6, MON[$5], $4, $7, $8, $9));
}

(ymd() >= YYYYMMDD" 00:00:00") && (ymd() <= YYYYMMDD" 23:59:59") { C++; }

END {   print C+0       }

$ awk -f dcomp.awk YYYYMMDD="2013/06/10" datafile

10

$

This User Gave Thanks to Corona688 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

String substitution on find results inside exec/xargs

What I'm trying to do is perform a copy, well a ditto actually, on the results of a find command, but some inline string substitution needs to happen. So if I run this code find ./ -name "*.tif" I get back these results. .//1234567.tif .//abcdefg.tif Now the action from exec or xargs I... (2 Replies)
Discussion started by: myndcraft
2 Replies

2. Shell Programming and Scripting

case loop... repeat on bad input?

I'm trying to get a case statement to start over if an undefined option is selected... But I am ata loss on how to actually do it. Here is a quick example of what I have. Echo "1) do this/n 2) Do that/n 3) Quit/n Make a selection/n" Read answer Case answer in 1) Dothid;; 2) Dothat;;... (3 Replies)
Discussion started by: trey85stang
3 Replies

3. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

4. Shell Programming and Scripting

Grab first or second line after a search string

In a shell script, I need to grab the first or second line after a search string in a file. For example: File.out: Random Info Manufacturer: XYZPDQ System Info Manufacturer: Hewlett-Packard Product Name: ProLiant I search for the word FILE, I want to be able to grab the line... (1 Reply)
Discussion started by: jwk1230
1 Replies

5. Shell Programming and Scripting

Matching 2 chars of a string that repeat

Hello Unix gurus, I have a gzipped file where each line contains 2 street addresses in the US. What I want to do is get a count for each state that does not match. What I have so far is: $ gzcat matched_10_09.txt.gz |cut -c 106-107,184-185 | head -5 CTCT CTNY CTCT CTFL CTMA This cuts... (5 Replies)
Discussion started by: sitney
5 Replies

6. Shell Programming and Scripting

Repeat using for loop

I have a file like this 2011-10-10 10:46:00,1-1-13-1-1,151510,ALCLA0A84D2C 2011-10-10 10:46:00,1-1-13-1-1,151520,65537 2011-10-10 10:46:00,1-1-13-1-1,151515,46932 2011-10-10 10:46:00,1-1-13-1-1,151521,32769 2011-10-10 10:46:00,1-1-13-1-1,151522,32769 2011-10-10... (4 Replies)
Discussion started by: LavanyaP
4 Replies

7. Shell Programming and Scripting

Replace string, grab files, rename and move

Hello there! I'm having a lot of trouble writing a script. The script is supposed to: 1) Find all files with the name "Object.mtl" within each folder in the directory: /Users/username/Desktop/convert/Objects 2) Search and replace the string ".bmp" with ".tif" (without the quotations) 3)... (1 Reply)
Discussion started by: Blue Solo
1 Replies

8. Homework & Coursework Questions

How to use loop to repeat task?

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. How can i use loop to repeat task. 2.shirt=15 black=13.50 echo "how many shirt you want" read num echo echo "Please enter a choice" echo "1 ---> normal... (5 Replies)
Discussion started by: Tauatioti
5 Replies

9. Shell Programming and Scripting

Single parse to grab two chunks of string

Hi all, I'm struggling with this task and have done alot of googling but not found the solution or atleast not found a way to combine them, i'm hoping someone here can help me out. I have a file that contains many line of config "below is two lines for an example" 323 => 1111,Terry berry... (3 Replies)
Discussion started by: 3sparky
3 Replies

10. Shell Programming and Scripting

Perl to adjust coordinates based on repeat string

In the file below I am trying to count the given repeats of A,T,C,G in each string of letters. Each sequence is below the > and it is possible for a string of repeats to wrap from the line above. For example, in the first line the last letter is a T and the next lines has 3 more. I think the below... (10 Replies)
Discussion started by: cmccabe
10 Replies
Data::FormValidator::Constraints::Dates(3pm)		User Contributed Perl Documentation	      Data::FormValidator::Constraints::Dates(3pm)

NAME
Data::FormValidator::Constraints::Dates - Validate Dates and Times SYNOPSIS
use Data::FormValidator::Constraints::Dates qw(date_and_time); # In a DFV profile... constraint_methods => { # 'pp' denotes AM|PM for 12 hour representation my_time_field => date_and_time('MM/DD/YYYY hh:mm:ss pp'), } DESCRIPTION
date_and_time Note: This is a new module is a new addition to Data::FormValidator and is should be considered "Beta". This constraint creates a regular expression based on the format string passed in to validate your date against. It understands the following symbols: Y year (numeric) M month (numeric) D day (numeric) h hour m minute s second p AM|PM Other parts of the string become part of the regular expression, so you can do perlish things like this to create more complex expressions: 'MM?/DD?/YYYY|YYYY-MM?-DD?' Internally Date::Calc is used to test the functions. BACKWARDS COMPATIBILITY
This older, more awkward interface is supported: # In a Data::FormValidator Profile: validator_packages => [qw(Data::FormValidator::Constraints::Dates)], constraints => { date_and_time_field => { constraint_method => 'date_and_time', params=>['MM/DD/YYYY hh:mm:ss pp'], # 'pp' denotes AM|PM for 12 hour representation }, } SEE ALSO
o Data::FormValidator o Data::FormValidator::Constraints::DateTime - This alternative features returning dates as DateTime objects and validating against the date formats required for the MySQL and PostgreSQL databases. AUTHOR
Mark Stosberg, <mark@summersault.com> Featuring clever code by Jan Krynicky. COPYRIGHT AND LICENSE
Copyright 2003-2005 by Mark Stosberg This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2011-11-25 Data::FormValidator::Constraints::Dates(3pm)
All times are GMT -4. The time now is 12:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy