finding data in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting finding data in a file
# 8  
Old 12-23-2004
Question

dear Zazzybob
my sed is a little on the rusty side:
could you please clarify a little.....
/precipitation/,/^[^:]*$/
" /^[^:]*$/" ? (confused!)
also how does the curly bracket play into the syntax..
if you could give an example using curly brackets I would appreciate it..
this is as far as I go with curly brackets and sed..
ex,. sed -e '/foo/{ h; d; }' -e 'N{g}'
other wise i don't know how to apply it the way you did..
moxxx68
ps. I know its a little off the subject but maybe both I and the poster could learn from an example..
# 9  
Old 12-23-2004
It may be easiest if I explain my example

Code:
#!/bin/sed -nf

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

/Precipitation/,/^[^:]*$/

This says find anything between the word Precipitation, and the first line that doesn't contain a colon (therefore, this allows us to grab just the "Precipitation" block plus the next header). Then, the curly braces allow us to group together any commands we want sed to execute when the condition is met. I suppose you could analogise this with awks pattern/action behaviour. So all I want to do is print the line(s) that contain "Wednesday". I have formed the script to allow for a little bit of "free-form" within the file. With some of the examples given in this thread, they rely on a rigid and strict file format.

Cheers
ZB
# 10  
Old 12-23-2004
cheers
# 11  
Old 12-23-2004
Code:
$ awk '/Precipitation/,/Wednesday/{x=$NF}END{print x}' file1
50

# 12  
Old 12-24-2004
These were all very helpful, my problem is solved, and I learned something Smilie

Thank you all very much for your help.

Best regards,

Selma
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