Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

delete line after pattern

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting delete line after pattern
# 1  
Old 05-13-2010
delete line after pattern
Hi,
Before insert, delete everything. If ' available before insert, then we need to keep this.

Input:
====
Code:
l_s := '    INSERT INTO TEST1'
INSERT INTO TEST2

Output:
====
Code:
'INSERT INTO TEST'
INSERT INTO TEST2

Last edited by vgersh99; 05-13-2010 at 12:23 PM.. Reason: code tags, please!
# 2  
Old 05-13-2010
Code:
sed "s/.*\(['] *\)INSERT/\1INSERT/" myInput

# 3  
Old 05-13-2010
Input
======================
l_s := ' INSERT INTO TEST'
l_P PD := ' UPDATE INTO TEST'
l_D := ' DELETE INTO TEST'
This is test

Input
======================
'INSERT INTO TEST'
'UPDATE INTO TEST'
'DELETE INTO TEST'
This is test
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed command to grep multiple pattern present in single line and delete that line

here is what i want to achieve.. i have a file with below contents cat fileName blah blah blah . .DROP this REJECT that . --sport 7800 -j REJECT --reject-with icmp-port-unreachable --dport 7800 -j REJECT --reject-with icmp-port-unreachable . . . more blah blah blah --dport 3306... (14 Replies)
Discussion started by: vivek d r
14 Replies

2. Shell Programming and Scripting

Delete line contains pattern

Hi all, I'm trying to delete line contains pattern from file using ex editor I have tried something like this user@host ~ $/usr/bin/echo "/$pattern/d\nwq!"| /usr/bin/ex -s file.txt This line is from script but it doesn't work any idea (4 Replies)
Discussion started by: h@foorsa.biz
4 Replies

3. Shell Programming and Scripting

delete next line of the given pattern

How to delete the next lines of the below pattern matches a certain criteria using sed it is rainy heavily<name> <name> how is it there <name> gfhafje qwfwfqw eeqewqrt <name> there is heavy raining <name> so that the output will be it is rainy heavily<name> gfhafje qwfwfqw... (2 Replies)
Discussion started by: tkmmelvin
2 Replies

4. Homework & Coursework Questions

delete line containing a pattern!!!

if the given pattern exists in the file with the very next line starting and ending with the same pattern , delete the line that starts and ends with the given pattern. So upon running on this file ===================== hai people<PATTERN> we had <PATTERN>a lot of fun<PATTERN> ... (1 Reply)
Discussion started by: jacky29
1 Replies

5. Shell Programming and Scripting

delete line containing a pattern!!!

if the given pattern exists in the file with the very next line starting and ending with the same pattern , delete the line that starts and ends with the given pattern. So upon running on this file ===================== hai people<PATTERN> we had <PATTERN>a lot of fun<PATTERN> ... (1 Reply)
Discussion started by: jacky29
1 Replies

6. Shell Programming and Scripting

Delete line before pattern

Hi All, I want to delete partial line before the INSERT. Input: l_s := ' INSERT INTO TEST' Output: INSERT INTO TEST' (3 Replies)
Discussion started by: saurabhbaisakhi
3 Replies

7. UNIX for Dummies Questions & Answers

Find Pattern delete line and next line

I am trying to delete the line with pattern and the next line. Found the below command in forum which also deleted the previous line. how should i modify that to make sure that only the line with pattern and the next line are deleted but not the previous line? awk '/key... (1 Reply)
Discussion started by: rdhanek
1 Replies

8. Shell Programming and Scripting

find pattern, delete line with pattern and line above and line below

I have a file that will sometimes contain a pattern. The pattern is this: FRM CHK 0000 I want to find any lines with this pattern, delete those lines, and also delete the line above and the line below. (4 Replies)
Discussion started by: nickg
4 Replies

9. UNIX for Dummies Questions & Answers

find pattern delete line with pattern and line above and line below

I have a file that will sometimes contain a pattern. The pattern is this: W/D FRM CHK 00 I want to find any lines with this pattern, delete those lines, and also delete the line above and the line below. (1 Reply)
Discussion started by: nickg
1 Replies

10. Shell Programming and Scripting

comment/delete a particular pattern starting from second line of the matching pattern

Hi, I have file 1.txt with following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433 ** ** ** In file 2.txt I have the following entries as shown: 0152364|134444|10.20.30.40|015236433 0233654|122555|10.20.30.50|023365433... (4 Replies)
Discussion started by: imas
4 Replies
Login or Register to Ask a Question