Extract a block of text


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Extract a block of text
# 8  
Old 03-07-2013
Okay, so each table is prefixed by a 'Statements for table' comment. This should put them in numbered files.

Code:
nawk '/Statements for table/ { ++FILE }; { print > sprintf("file%04d", FILE) }' FILE=0 RS="" ORS="\n\n" FS="\n" inputfile

# 9  
Old 03-08-2013
Extract a block of text

There is an equivalent command using awk instead of nawk? I am receiving the following error when I launch the script:

Code:
tddemo2:~/test/scripts # ./test.ksh input.txt
./test.ksh[84]: nawk: not found [No such file or directory]

I am working on the following version of Linux:
Code:
tddemo2:~/test/scripts # uname -a
Linux 2.6.16.54-0.2.12-smp #1 SMP x86_64 GNU/Linux

# 10  
Old 03-08-2013
Hope this is what you are looking for..



Code:
awk '/^CREATE TABLE/,/^[ \t]*IN/ { print }' input.txt

# 11  
Old 03-08-2013
Extract a block of text

Yes busyboy, you are great - this is what I was searching for. Now all I have to do is to split the output file into small ones - one for each table. Thank you!
# 12  
Old 03-08-2013
Quote:
Originally Posted by kiki_riki_miki
There is an equivalent command using awk instead of nawk?
If you are on Linux, awk is nawk.

If you're on Solaris or AIX or some other kinds of UNIX, 'awk' is 'old awk', kept for compatibility reasons, and 'nawk' is what you really want.

Last edited by Corona688; 03-08-2013 at 01:00 PM..
# 13  
Old 03-13-2013
sorry for late response.

hope this may help.

Code:
awk  '/^CREATE TABLE/,/^[ \t]*IN/ { if($0 ~ /^CREATE TABLE/)  { TBDB=$0; gsub(/CREATE TABLE|\"|\(|[ ]/,"",TBDB);   }; print > "TABLE."TBDB".txt" }' input.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grepping text block by block by using for loop

Hei buddies, Need ur help once again. I have a file which has bunch of lines which starts from a fixed pattern and ends with another fixed pattern. I want to make use of these fixed starting and ending patterns to select the bunch, one at a time. The input file is as follows. Hi welcome... (12 Replies)
Discussion started by: anushree.a
12 Replies

2. Shell Programming and Scripting

How to extract block from a file?

I have siebel log file as following EventContext ....... 123 ....... SELECT ... .. EventConext <---- Question 1 , I should get this line 345 ...... SELECT <----- Question 2 , print this line Test..... <----- Question 2 , print this line .... <----- Question 2 , print... (5 Replies)
Discussion started by: ran123
5 Replies

3. Shell Programming and Scripting

[Awk] Extract block of with a particular pattern

Hi, I have some CVS log files, which are divided into blocks. Each block has many fields of information and I want to extract those blocks with a pattern. Here is the sample input. RCS file: /cvsroot/eclipse/org.eclipse.debug.core/core/org/eclipse/debug/core/DebugPlugin.java,v head: 1.174... (7 Replies)
Discussion started by: sandeepk1611
7 Replies

4. Shell Programming and Scripting

Extract a block of text??

Hello all, I have a large output file from which I would like to extract a single block of text. An example block of text is shown below: ***** EQUILIBRIUM GEOMETRY LOCATED ***** COORDINATES OF ALL ATOMS ARE (ANGS) ATOM CHARGE X Y Z ... (10 Replies)
Discussion started by: marcozd
10 Replies

5. Shell Programming and Scripting

Extract selective block from XML file

Hi, There's an xml file produced from a front-end tool as shown below: <INPUT DATABASE ="ORACLE" DBNAME ="UNIX" NAME ="FACT_TABLE" OWNERNAME ="DIPS"> <INPUTFIELD DATATYPE ="double" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="STORE_KEY" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="15" SCALE... (6 Replies)
Discussion started by: dips_ag
6 Replies

6. Shell Programming and Scripting

Extract value from a text

Hi all, my problem is extract a value from a text, i mean, I have this text: > ala Nr of active alarms are: 16 ================================================================================================ Sever Specific Problem Cause Mo-Reference... (15 Replies)
Discussion started by: marimovo
15 Replies

7. Shell Programming and Scripting

Extract block of data and the error reason too. So so urgent

Hi , this is my first enty in our forum. Problem scenario: Using informatica tool am loding records from source DB to target DB. While loading some records getting rejected due to some reason. Informatica will capture those rejected records in session log file.now the session log ll be... (2 Replies)
Discussion started by: Gopal_Engg
2 Replies

8. Shell Programming and Scripting

Extract particular text

I executed a following sed command => echo "a/b/c/d/e/f/g/h" | sed 's/\/*$//g' a/b/c/d/e/f/g Now what if I want to extract "g" from "a/b/c/d/e/f/g/h" . That is second last string using SED. (4 Replies)
Discussion started by: Shell_Learner
4 Replies

9. Programming

c program to extract text between two delimiters from some text file

needa c program to extract text between two delimiters from some text file. and then storing them in to diffrent variables ? text file like 0: abc.txt ========= aaaaaa|11111111|sssssssssss|333333|ddddddddd|34343454564|asass aaaaaa|11111111|sssssssssss|333333|ddddddddd|34343454564|asass... (7 Replies)
Discussion started by: kukretiabhi13
7 Replies

10. UNIX for Dummies Questions & Answers

extract block in file

I need to extract a particular block from a file whose locations are not known but the only identity is a word. For example in a file I have ABC asdklf asdfk FGH dfdfg asdlfk asdfl ... JHK (5 Replies)
Discussion started by: sskb
5 Replies
Login or Register to Ask a Question