Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Delete values between 2 patterns

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Delete values between 2 patterns
# 8  
Old 05-23-2014
Hi Alister,

yes, the file only contains 2 columns and it is tab delimited. and yes, your codes worked great. Thanks

---------- Post updated at 03:14 PM ---------- Previous update was at 03:12 PM ----------

Hi protocomm,

tried your codes but unfortunately it didn't give me any result. thanks Smilie
# 9  
Old 05-23-2014
Quote:
Originally Posted by redse171
Hi Alister,

yes, the file only contains 2 columns and it is tab delimited. and yes, your codes worked great. Thanks

---------- Post updated at 03:14 PM ---------- Previous update was at 03:12 PM ----------

Hi protocomm,

tried your codes but unfortunately it didn't give me any result. thanks Smilie
My code works on my mac, i use bash.

sorry.
This User Gave Thanks to protocomm For This Post:
redse171
# 10  
Old 05-23-2014
Hi!

if you have gnu awk you may try this also

Code:
$ awk --re-interval '{match($0,/[^.]+(\.[^.]+){2}/);$0 = substr($0,RSTART,RLENGTH) substr($0,length($1)+1)}1'   file 

192.1.1      blablabala
23.1.A        blablabalbl
5.4.1        blablaba

---------- Post updated at 02:17 AM ---------- Previous update was at 02:11 AM ----------

else we can modify something like this

Code:
$ awk '{split($1,A,/\./);$0= A[1]"."A[2]"."A[3] substr($0,length($1)+1)}1' file

This User Gave Thanks to Akshay Hegde For This Post:
redse171
# 11  
Old 05-23-2014
Hi Akshay Hedge,

I dont have gnu awk. i tried your second codes and it worked perfectly. Thanks
# 12  
Old 05-23-2014
Quote:
Originally Posted by redse171
Hi Akshay Hedge,

I dont have gnu awk. i tried your second codes and it worked perfectly. Thanks
If you would tell us what system you're using, we'd have a better chance of giving you working code. There are significant differences between how sed behaves with back references depending on which sed you're using.

Apparently you are not using Mac OS X and you are not using any version of Linux. What OS are you using?
# 13  
Old 05-23-2014
Quote:
Originally Posted by Don Cragun
If you would tell us what system you're using, we'd have a better chance of giving you working code. There are significant differences between how sed behaves with back references depending on which sed you're using.

Apparently you are not using Mac OS X and you are not using any version of Linux. What OS are you using?
I am using linux (ubuntu).
# 14  
Old 05-23-2014
Quote:
Originally Posted by Don Cragun
There are significant differences between how sed behaves with back references depending on which sed you're using.
Hi, Don. Can you elaborate?

Regards,
Alister

---------- Post updated at 05:56 PM ---------- Previous update was at 05:52 PM ----------

Quote:
Originally Posted by redse171
Hi Akshay Hedge,

I dont have gnu awk. i tried your second codes and it worked perfectly. Thanks
Quote:
Originally Posted by alister
Code:
sed 's/\./\t/3; s/\t.*\t/\t/' file

That isn't portable sed, because \t is primarily a GNU extension.
Quote:
Originally Posted by redse171
Hi Alister,

yes, the file only contains 2 columns and it is tab delimited. and yes, your codes worked great. Thanks
Quote:
Originally Posted by redse171
I am using linux (ubuntu).
Makes sense. Last I heard, default sed on Ubuntu is GNU sed and default AWK is mawk.

Regards,
Alister
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete patterns matching

Delete patterns matching OS version: RHEL 7.3 Shell : Bash I have a file like below (pattern.txt). I need to delete all lines starting with the following words (words separated by comma below) and ) character. LOGGING, NOCOMPRESS, TABLESPACE , PCTFREE, INITRANS, MAXTRANS, STORAGE,... (3 Replies)
Discussion started by: John K
3 Replies

2. Shell Programming and Scripting

Add values of similar patterns with awk

so my output is this: session_closed=157 session_opened=151 session_closed=18 session_opened=17 there are two patterns here, but with different values. the two patterns are "session_opened" and "session_closed". i expect there will be many more other patterns. what i want to do is... (8 Replies)
Discussion started by: SkySmart
8 Replies

3. Shell Programming and Scripting

Find files not matching multiple patterns and then delete anything older than 10 days

Hi, I have multiple files in my log folder. e.g: a_m1.log b_1.log c_1.log d_1.log b_2.log c_2.log d_2.log e_m1.log a_m2.log e_m2.log I need to keep latest 10 instances of each file. I can write multiple find commands but looking if it is possible in one line. m file are monthly... (4 Replies)
Discussion started by: wahi80
4 Replies

4. Shell Programming and Scripting

Delete lines and the first pattern between 2 matched patterns

Hi, i need help to delete all the lines between 2 matched patterns and the first pattern must be deleted too. sample as follows: inputfile.txt >kump_1 ........................... ........................... >start_0124 dgfhghgfh fgfdgfh fdgfdh >kump_2 ............................. (7 Replies)
Discussion started by: redse171
7 Replies

5. Shell Programming and Scripting

Match paragraph between two patterns, delete the duplicate paragraphs

Hello all I have a file my DNS server where there are duplicate paragrapsh like below. How can I remove the duplicate paragraph so that only one paragraph remains. BEGIN; replace into domains (name,type) values ('225.168.192.in-addr.arpa','MASTER'); replace into records (domain_id,... (2 Replies)
Discussion started by: sb245
2 Replies

6. Shell Programming and Scripting

Delete line breaks and extra spaces between patterns

Hi, if in between strings "<section" and "</section>" across multiple lines there occurs the string "ole-present", delete all line breaks and replace any tabs or multiple spaces with a single space. Looking for an AWK or SED solution. Thank you. <section ... status = "ole-present" ...... (2 Replies)
Discussion started by: pioavi
2 Replies

7. Shell Programming and Scripting

Capture values using multiple regex patterns

I have to read the file, in each line of file i need to get 2 values using more than one search pattern. ex: <0112 02:12:20 def > /some string/some string||some string||124 i donot have same delimiter in the line, I have to read '0112 02:12:20' which is timestamp, and last field '124' which is... (4 Replies)
Discussion started by: adars1
4 Replies

8. Shell Programming and Scripting

delete lines between patterns

Hi, I've searched in this forum all day long but was not able to find enough codes to help me do a task. The only code that I can come up with is this: sed '/ /,/ /{//p;d;}' inputfile > outputfile I would like to sed/awk/grep a file for two patterns and then delete the lines between... (4 Replies)
Discussion started by: shamushamu
4 Replies

9. Shell Programming and Scripting

delete two patterns and remove one pattern

Friends, I have .txt file with following format. START ABC|Prashant1|Patel1 ABC|Prashant2|Patel2 ABC|Prashant1|Patel1 ABC|Prashant2|Patel2 END I would like to do: 1) Delete line with START 2) Delete line with END 3) Remove ABC| 4) Delete duplicate records The following command... (7 Replies)
Discussion started by: ppat7046
7 Replies

10. Shell Programming and Scripting

Delete lines between two patterns without deleting the second pattern

I want to delete lines like this sed '/FROM_HERE/,/TO_HERE/d' but I would like to *not* delete the second match, i.e. the TO_HERE line. How can I achieve this? Thank you! (1 Reply)
Discussion started by: Ilja
1 Replies
Login or Register to Ask a Question