Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to copy multiple lines from a file to another using AWK?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to copy multiple lines from a file to another using AWK?
# 1  
Old 01-08-2008
How to copy multiple lines from a file to another using AWK?
Hi,

I have a abc.txt file.

In this file there is a SQL query which Iwant to copy and print it on another file.The query (for eg) is written like this:

SELECT field1,
field2,
field3
from table1,table2
where <conditions>
END

I want to copy this query to another file using AWK.Its very urgent .Can someone help me in this.

Thanks in advance.
JS
# 2  
Old 01-08-2008
Quote:
Originally Posted by jisha
Hi,

I have a abc.txt file.

In this file there is a SQL query which Iwant to copy and print it on another file.The query (for eg) is written like this:

SELECT field1,
field2,
field3
from table1,table2
where <conditions>
END

I want to copy this query to another file using AWK.Its very urgent .Can someone help me in this.

Thanks in advance.
JS
Code:
awk '/SELECT/,/END/{print}' abc.txt > newfile

# 3  
Old 01-08-2008
Thanku so much its working perfectly !!
# 4  
Old 01-08-2008
Quote:
Originally Posted by jisha
Thanku so much its working perfectly !!
What If i dont want to print the first and the last line but everthing else?
For eg : I dont want to print the SELECT and Last line, END but have to print all lines in between these two?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk,sed,shell copy ID in new lines

Hi all i want table file in pattern like under ID(digits and underline) phonetic begin_byte(only plus number) end_byte(only plus number) but ID loose in next lines of my file my input file like this: input 001_1_174 474536 482492 mo 482492 504062 'er/ 504062 517352 ruze 517352... (1 Reply)
Discussion started by: alii
1 Replies

2. Shell Programming and Scripting

awk copy first column in new lines

Hi all i have table like this input001_1_174 j 474536 482492 mo001_1_175 j 960192 966656 .ire 966656 984416 .uf/i want copy number of first line to other line... (10 Replies)
Discussion started by: alii
10 Replies

3. Shell Programming and Scripting

Removing multiple lines from input file, if multiple lines match a pattern.

GM, I have an issue at work, which requires a simple solution. But, after multiple attempts, I have not been able to hit on the code needed. I am assuming that sed, awk or even perl could do what I need. I have an application that adds extra blank page feeds, for multiple reports, when... (7 Replies)
Discussion started by: jxfish2
7 Replies

4. Shell Programming and Scripting

Merging multiple lines to columns with awk, while inserting commas for missing lines

Hello all, I have a large csv file where there are four types of rows I need to merge into one row per person, where there is a column for each possible code / type of row, even if that code/row isn't there for that person. In the csv, a person may be listed from one to four times... (9 Replies)
Discussion started by: RalphNY
9 Replies

5. Shell Programming and Scripting

Merge multiple lines in same file with common key using awk

I've been a Unix admin for nearly 30 years and never learned AWK. I've seen several similar posts here, but haven't been able to adapt the answers to my situation. AWK is so damn cryptic! ;) I have a single file with ~900 lines (CSV list). Each line starts with an ID, but with different stuff... (6 Replies)
Discussion started by: protosd
6 Replies

6. Shell Programming and Scripting

Combine multiple unique lines from event log text file into one line, use PERL or AWK?

I can't decide if I should use AWK or PERL after pouring over these forums for hours today I decided I'd post something and see if I couldn't get some advice. I've got a text file full of hundreds of events in this format: Record Number : 1 Records in Seq : ... (3 Replies)
Discussion started by: Mayday22
3 Replies

7. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

8. Shell Programming and Scripting

Awk to Break lines to multiple lines.

Input File: nawk -F "|" '{ for(i=1;i<=NF;i++) { if (i == 2) {gsub(",","#",$i);z=split($i,a,"")} else if (i == 3) {gsub(",","#",$i);z=split($i,b,"")} } if(z > 0) for(i=1;i<=z;i++) print $1,a,"Test"; if(w > 0) for(j=1;j<=w;j++) ... (1 Reply)
Discussion started by: pinnacle
1 Replies

9. Shell Programming and Scripting

awk/grep copy and paste and insert in between lines.

Hi all, I'm a unix newb andI'm trying to write a script that can copy some text paste it in a certian place and then add a number. It's not really clear but I'll show an example. what the file looks like right now: Linux 2.6.24-24-generic (abc) 07/15/09 23:25:01 CPU ... (6 Replies)
Discussion started by: the1hand3r
6 Replies

10. Shell Programming and Scripting

copy value to multiple lines

Hello, does anyone know how sed can convert a file like the one shown below. I have a file that contains data like this: Nov-12-2007 line1 line2 line3 Nov-13-2007 line5 line6 Nov-14-2007 line8 line9 line10 and what I want is this: Nov-12-2007,line1 Nov-12-2007,line2 (4 Replies)
Discussion started by: rko
4 Replies
Login or Register to Ask a Question