Extracting words and lines based on keywords


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extracting words and lines based on keywords
# 1  
Old 06-09-2013
Extracting words and lines based on keywords

Hello!

I'm trying to process a text file and am stuck at 2 extractions. Hoping someone can help me here:

1. Given a line in a text file and given a keyword, how can I extract the word preceeding the keyword using a shell command/script?

For example: Given a keyword "world" in the line:
"This really beautiful world goes round and round".

How can I extract the word "beautiful"? it can occur either as 2 separate terms as above "Beautiful World" or a conjoined word as "Beautiful-world". I need to extract Beautiful in either of the cases.
[I tried to get the position of the word, "World" and tried to extract the word before that. But it did gave me the entire piece of string from the beginning. However, I only need to extract the word "Beautiful"
]


2. Given a keyword, say, "design", how can I extract the first paragraph under it?
For example, in the text file, I have the below:
Design:
"This is the design for the experiment to be conducted in July. The requirements have already been signed off by the business. Prior to starting the design phase, ensure that the current design document is available for all departments."

para 2

para 3

I need to extract only the paragraph immediately below design. Is there a way I can do this using Shell commands/script?

Thanks so much in advance.

Regards,
seemad
# 2  
Old 06-09-2013
AWK approach based on some assumptions

To print word before world:
Code:
awk '
        /world/ {
                n = match ( $0, /[^ ]*[ -]*world/ )
                s = substr ( $0, n, RLENGTH - 5 )
                sub ( /[ -]/, X, s )
                print s
        }
' file

To print paragraph after design:
Code:
awk '
        /design/ {
                f = 1
                next
        }
        f && NF {
                print $0
                exit
}'  file

# 3  
Old 06-09-2013
Great! Thanks this works. Although, for the second one, I realise it hits the Table of Contents first which I don't want to extract from.

Guess I'll have to remove the table of contents from the actual text file.

Thanks again!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting lines based on condition and copy to another file

hi i have an input file that contains some thing like this aaa acc aa abc1 1232 aaa abc2.... poo awq aa abc1 aaa aaa abc2 bbb bcc bb abc1 3214 bbb abc3.... bab bbc bz abc1 3214 bbb abc3.... vvv ssa as abc1 o09 aaa abc4.... azx aaq aa abc1 900 aqq abc19.... aaa aa aaaa abc1 899 aa... (8 Replies)
Discussion started by: anurupa777
8 Replies

2. Shell Programming and Scripting

copy range of lines in a file based on keywords from another file

Hi Guys, I have the following problem. I have original file (org.txt) that looks like this module v_1(.....) //arbitrary number of text lines endmodule module v_2(....) //arbitrary number of text lines endmodule module v_3(...) //arbitrary number of text lines endmodule module... (6 Replies)
Discussion started by: kaaliakahn
6 Replies

3. Shell Programming and Scripting

Sorting lines based on keywords for MySQL script

the thing which i require is very very complex.. i tried hard to find the solution but couldnt.. the thing i need to achieve is say i have a file cat delta.sql CREATE VIEW Austin Etc etc . . . CREATE VIEW Barabara AS SELECT blah blah blah FROM Austin z, Cluster s, Instance i WHERE... (4 Replies)
Discussion started by: vivek d r
4 Replies

4. Shell Programming and Scripting

Extracting lines based on identifiers into multiple files respectively

consider the following is the contents of the file cat 11.sql drop procedure if exists hoop1 ; Delimiter $$ CREATE PROCEDURE hoop1(id int) BEGIN END $$ Delimiter ; . . . . drop procedure if exists hoop2; Delimiter $$ CREATE PROCEDURE hoop2(id int) BEGIN END $$ (8 Replies)
Discussion started by: vivek d r
8 Replies

5. Shell Programming and Scripting

Extracting few lines from a file based on identifiers dynamically

i have something like this in a file called mysqldump.sql -- -- Table structure for table `Table11` -- DROP TABLE IF EXISTS `Table11`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Table11` ( `id` int(11) NOT NULL... (14 Replies)
Discussion started by: vivek d r
14 Replies

6. Shell Programming and Scripting

Extracting specific lines of data from a file and related lines of data based on a grep value range?

Hi, I have one file, say file 1, that has data like below where 19900107 is the date, 19900107 12 144 129 0.7380047 19900108 12 168 129 0.3149017 19900109 12 192 129 3.2766666E-02 ... (3 Replies)
Discussion started by: Wynner
3 Replies

7. Shell Programming and Scripting

awk : extracting unique lines based on columns

Hi, snp.txt CHR_A SNP_A BP_A_st BP_A_End CHR_B BP_B SNP_B R2 p-SNP_A p-SNP_B 5 rs1988728 74904317 74904318 5 74960646 rs1427924 0.377333 0.000740085 0.013930081 5 ... (12 Replies)
Discussion started by: genehunter
12 Replies

8. Shell Programming and Scripting

Extracting lines in file based on time

Hi, anyone has any ideas on how do we extract lines from a file with format similiar to this: (based on current time) Jun 18 00:16:50 .......... ............. ............ Jun 18 00:17:59 .......... ............. ............ Jun 18 01:17:20 .......... ............. ............ Jun 18... (5 Replies)
Discussion started by: faelric
5 Replies

9. Shell Programming and Scripting

Capture lines based on keywords

Hello everyone, I am trying to write a script that will capture few lines from a text file based on 2 keywords in the first line and 1 keyword in the last one. It could also be based on the first line only + the folllowing 3 lines. Could some one help or give directions. Thanks. (4 Replies)
Discussion started by: nimo
4 Replies

10. Shell Programming and Scripting

Search and replace words between two keywords

Hi, I have a file which contains the following : select * from test where test_id=1; select id from test1, test2 where test_id=1 and test_id=2; select * from test1, test2, test3 where test_id=4 and test2_id where in (select test2_id from test2); select id1, id2 from test ... (6 Replies)
Discussion started by: vrrajeeb
6 Replies
Login or Register to Ask a Question