finding data in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting finding data in a file
# 1  
Old 12-23-2004
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
Thursday: x
Friday: x
Precipitation
Monday: x
Tuesday: x
Wednesday: 50%
Thursday: x
Friday: x
..

I need to extract the Precipitation for Wednesday (I just need the 50%). Position of Precipitation is not always the same in the file. I have tried to use grep and awk, but have not been successful so far, probably because I haven't used awk before now.

Does anyone have any ideas? If so, please help.

Thank you in advance,

Selma
# 2  
Old 12-23-2004
Hammer & Screwdriver

try something like :
IFS=:
awk -F '{print $2}' input file | grep -v 'x'
should work!!
moxxx68
# 3  
Old 12-23-2004
Thanks for the quick reply. Could you please explain it a little bit more? I do not see where in this command does it say "search for 'precipitation'".
# 4  
Old 12-23-2004
-> Wednesday: 50%
-> Thursday: x

awk -F '{print $2}' input file = recupere the second word (50% and x)

|grep -v 'x' = exlude the character "x"

Also you could used :
awk -F '{print $2}' input file | grep %
you recupere only the %

It is the same result
# 5  
Old 12-23-2004
Yes, that's how I understood it as well. But this doesn't help me with my problem. Xs were there just in place of some other numbers, I don't acutally get Xs in the file I need to parse, so if for example I have:

Sunny
Monday: 10
Tuesday: 15
Wednesday: 53
Thursday: 57
Friday: 8
Cloudy
Monday: 35
Tuesday: 7
Wednesday: 95
Thursday: 68
Friday: 98
Precipitation
Monday: 15
Tuesday: 29
Wednesday: 50
Thursday: 26
Friday: 1
...

then the suggested command would return all of the numbers in the second column if I understand this correctly.
The point here is that I need to find the Precipitation category first, and then get data for Wednesday only. Can you help me with that?

Sorry if my first example was confusing.

Thank you.
# 6  
Old 12-23-2004
try
IFS=:
grep -nA7 'Precipitation' | awk -F '/Wednesday/{print $2)
should work..
or alternately
grep -nA7 'Precipitation' | awk '-F /Wednesday/{print, "Precipitation:" $2)
hope that solves the problem
moxxx68
# 7  
Old 12-23-2004
I'd personally use sed

Code:
#!/bin/sed -nf

/Precipitation/,/^[^:]*$/ {
   /Wednesday/p
}

Then invoke with
foo.sed filename_here

Cheers
ZB
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Finding Data in the file

Hi All I have a file having columns such as AAA,BBB,CCC,Aug 13 2013 AAA,BBB,CCC,Aug 11 2013 AAA,BBB,CCC,Aug 12 2013 AAA,BBB,CCC,Aug 13 2013 Now I need to extract the records which are not of todays date (Considering Today date is 13-Aug-2013 So I should get below records... (10 Replies)
Discussion started by: Prashantckc
10 Replies

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

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
Login or Register to Ask a Question