Grepping a timestamp range and assigning it to a constant Post: 302994583

Sponsored Content

Top Forums Shell Programming and Scripting Grepping a timestamp range and assigning it to a constant Post 302994583 by Corona688 on Friday 24th of March 2017 02:28:58 PM

03-24-2017

Registered User

This version only prints lines with a matching 'CUT N'.

Code:

awk -F"[,:]" -v OFS="," '{
        sub(/^0/, "", $2);      # Remove leading zero
        C=$2 + 0
        N=0
        if( (C >= (12+3)) && (C <= (12+5))) N=1;
        else if( (C >= (12+6)) && (C <= (12+10))) N=2;
        else if( (C >= 0) && (C <= 2)) N=3;
        $3=sprintf("CUT %d", N);# Set column 2 to "CUT N"
        NF=3                    # Set number of columns to 2
} N' data3

This version generates 'CUT 0' for all others.

Code:

awk -F"[,:]" -v OFS="," '{
        sub(/^0/, "", $2);      # Remove leading zero
        C=$2 + 0
        N=0
        if( (C >= (12+3)) && (C <= (12+5))) N=1;
        else if( (C >= (12+6)) && (C <= (12+10))) N=2;
        else if( (C >= 0) && (C <= 2)) N=3;
        $3=sprintf("CUT %d", N);# Set column 2 to "CUT N"
        NF=3                    # Set number of columns to 2
}' data3

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve...

2. Programming

grepping a range of values

I need to return all records in a file starting with a row that says TABLE: <tabl name> lists of hexadecimal records TABLE: <some table> TABLe is a key word in the file. I know the name of the table I want to start with. I do not know the name of the table that I will end with. I just...

3. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends, I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only I can get the...

4. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of...

5. IP Networking

IP Range Assigning

Hi All, I'm a bit confused about assigning IP address from IP Ranges. I am using this scenario below to understand. Scenario Adatum.com an international IT solutions company, is launching 12 new branches in a new country where they currently have no existing branches. The sWin CIO has asked...

6. Homework & Coursework Questions

IP Range Assigning

THIS IS A SAMPLE PRACTICAL EXAM QUESTION, COMPLETE FILE HAS BEEN ATTACHED AS WELL. Hi All, I'm a bit confused about assigning IP address from IP Ranges. I am using this scenario below to understand. Scenario Adatum.com an international IT solutions company, is launching 12 new branches in a...

7. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ...

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Discussion started by: mailsara

2. Programming

grepping a range of values

Discussion started by: guessingo

3. Shell Programming and Scripting

To check timestamp in logfile and display lines upto 3 hours before current timestamp

Discussion started by: srkmish

4. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Discussion started by: rahul2662

5. IP Networking

IP Range Assigning

Discussion started by: TryllZ

6. Homework & Coursework Questions

IP Range Assigning

Discussion started by: TryllZ

7. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

Discussion started by: nms