Visit Our UNIX and Linux User Community


Finding Data in the file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Finding Data in the file
# 8  
Old 09-02-2013
The strftime is available, However am Trying to do the below, but not getting the needed result
Code:
awk -F, 'BEGIN{today=strftime("%b %e %Y")} 
{ #print substr($NF,1,11)
  #print today
 (substr($NF,1,11)== today)
}
' infile

The reason being that the NF contains the Time as well (Which is always marked as 00:00:00)
# 9  
Old 09-02-2013
Quote:
Originally Posted by Prashantckc
The strftime is available, However am Trying to do the below, but not getting the needed result
Code:
awk -F, 'BEGIN{today=strftime("%b %e %Y")} 
{ #print substr($NF,1,11)
  #print today
 (substr($NF,1,11)== today)
}
' infile

The reason being that the NF contains the Time as well (Which is always marked as 00:00:00)
First, the input that you showed us in the 1st message in this thread did not contain 00:00:00 in any of the input lines. So, what input are you using now?

Second, you have commented out both print statements in this awk script and the awk statement:
Code:
 (substr($NF,1,11)== today)

should not produce any output. So, what is the needed result?
# 10  
Old 09-02-2013
Hi Don Cragun

The feed is same, only the date in the file is appended in the last column along with the date (Which is always 00:00:00).

Regarding Point 2
The lines which I commented was for testing purpose
Code:
#print substr($NF,1,11)

This I used to get exactly what is returned by substr()
Code:
 #print today

To check what is the exact value which am getting in today

The Last Line which is actually checking the quality is not commented
Code:
 (substr($NF,1,11)== today)

# 11  
Old 09-02-2013
Quote:
Originally Posted by Prashantckc
Hi Don Cragun

... ... ...

The Last Line which is actually checking the quality is not commented
Code:
 (substr($NF,1,11)== today)

It isn't commented, but it evaluates to 0 or to 1 and prints nothing either way. If what you're trying to do is print lines that have today's date and ignore other lines, change your script to:
Code:
awk -F, 'BEGIN{today=strftime("%b %e %Y")} 
substr($NF,1,11) == today
' infile

My awk doesn't include an strftime() function, but the following should also work for you:
Code:
awk -F, 'BEGIN{today=strftime("%b %e %Y 00:00:00")} 
$NF == today
' infile


Previous Thread | Next Thread
Test Your Knowledge in Computers #621
Difficulty: Medium
There is no switch statement in Python.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Finding data value that contains x% of points

Hi, I need help on finding the value of my data that encompasses certain percentage of my total data points (n). Attached is an example of my data, n=30. What I want to do is for instance is find the minimum threshold that still encompasses 60% (n=18), 70% (n=21) and 80% (n=24). manually to... (4 Replies)
Discussion started by: ida1215
4 Replies

2. Shell Programming and Scripting

Finding data in large no. of files

I need to find some data in a large no. of files. The data is in the following format : VALUE A VALUE B VALUE C VALUE D 10 4 65 1 12 4.5 65.5 2 10.75 5.1 ... (2 Replies)
Discussion started by: cooker97
2 Replies

3. Shell Programming and Scripting

Finding standard deviation for all columns in a data file

Hi All, I want someone to modify the below script from this forum so that it can be used for all columns in the file( instead of only printing column 3 mean and standard deviation values). I don't know how to loop around all the columns. ... (3 Replies)
Discussion started by: ks_reddy
3 Replies

4. HP-UX

finding these, whether previous data stored ?

Hi All, On HP Unix, 11.23 can following be checked , Processes which were consuming more 1)CPU 2)Memory 3)page faults For particular Time Frame say Yesterday 7 Am to 7.30 Am and , Yesterday Evening 19.00 Pm to 19.30 Pm Please specify how. whether we need to enable, some... (6 Replies)
Discussion started by: sidharthmellam
6 Replies

5. Shell Programming and Scripting

Parsing chunks of text and finding data

Hi, I need a script that parses and greps data out of a textfile. I have a text file that has this structure: File1 host1.localdomain text random text Found errors this text is random (41123) --- random random at.5165 ---- random random at.5165 ---- random random at.5165 ----... (2 Replies)
Discussion started by: erick_tuk
2 Replies

6. Shell Programming and Scripting

Finding Minimum value per Row range of data

Here is an example of a file I am working with: C 4704 CB 1318 ASP 115 BGRF 1 weak 0.0% 4.33 C 4720 OD 1322 ASP 115 BGRF 1 weak 0.0% 3.71 O 4723 OD 1322 ASP 115 BGRF 1 weak 0.0% 3.48 O 4723 CG 1321 ASP 115 BGRF 1 weak 0.0% 4.34... (3 Replies)
Discussion started by: userix
3 Replies

7. Shell Programming and Scripting

Finding Overlap between two sets of data

Hi everyone, I posted this earlier, but the idea changed since then and I figured it would make more sense if I repost with a clearer idea in hopes someone can help me out. I have two lists of data in file1 and file 2 file1 (tab separated - column1 column2 column 3) 1 91625106 ... (1 Reply)
Discussion started by: labrazil
1 Replies

8. Shell Programming and Scripting

finding null records in data file

I am having a "|" delimited flat file and I have to pick up all the records with the 2nd field having null value. Please suggest. (3 Replies)
Discussion started by: dsravan
3 Replies

9. Shell Programming and Scripting

finding data in a file

Hello, I am new to shell programming, and Unix development overall. I have a following text file with the following contents: .. Sunny Monday: x Tuesday: x Wednesday: x Thursday: x Friday: x Cloudy Monday: x Tuesday: x Wednesday: x ... (11 Replies)
Discussion started by: Selma
11 Replies

10. Shell Programming and Scripting

Finding duplicate data in a file

A pogram named LOGGEDON returns an output of: Ref_num IP Address Logged on User 12000 10.10.12.12 12-02-2002 11:00 john 12004 10.10.12.13 12-03-2002 14:00 mary 12012 10.10.12.14 12-03-2002 11:30 bob 12024 ... (1 Reply)
Discussion started by: dinplant
1 Replies

Featured Tech Videos