How to replace pattern?

Login or Register to Ask a Question and Join Our Community

How to replace pattern?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to replace pattern?

02-08-2018

Registered User

81, 3

Join Date: Sep 2017

Last Activity: 3 October 2019, 8:02 AM EDT

Location: Bangalore, India

Posts: 81

Thanks Given: 63

Thanked 3 Times in 3 Posts

How to replace pattern?

Code:

1 | HTTP | ^~
1 | HTTP | ^~&<?1;?;-unp~xn~lP4WM}~!0%#8?;+5vl9`#ep3q6X1772goci3fj`nc7M1?`"*"#&1 ?;?=>k4NQ="#$3(> | 20180115 | 17
1 | HTTP| ^~�3�������������󬩵���粷�����������𶯰����ܬ�� | 20180123 | 07
1 | HTTP | 5g | 20180123 | 09
1 | HTTP | `6$pct{z`ChagykbmsvDlbeu0)d&`{f/d80l18m`29VYei1&49dw1/g~fOvt!%3iv"3U;9(!>%4pfbbyn | 20180117 | 14
1 | HTTP | ^~!7c{cxg | 20180117 | 11
1 | HTTP | ^~89>0&9fjefdT\3=2&=86sgzd | 20180117 | 12
1 | HTTP | ^~8)rzk)+tar.8?0,%:?&3&<)>4.81;1#++(pqzwglgl:*fq05nfu13;1p17:g&hal5u?b<a&<bm`%++(cxnhzk`aj | 20180115 | 12
1 | HTTP | `a`ih$mmdzb | 20180117 | 17
1 | HTTP | ^~�a>mj[^RTYU\oe#WRNEH]C_D | 20180123 | 12
1 | HTTP | ^~Cookie:**** | 20180117 | 13
1 | HTTP | ^~Cookie:***�H�O��:��pd�����L]��Ie(���T��MT��(���� | 20180117 | 18
1 | HTTP | ^~Cookie:****N:^L:��4R�W0�{б�#��Z��r | 20180118 | 00
1 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=17) | 22974464 | 24
1 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=17) | 35905339 | 66
1 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=17) | 40861664 | 30
1 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=18) | 03727721 | 39
2 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=19) | 20170727 | 12
9 | HTTP | Rejection Reason": "Malformed line with incorrect number of fields (expected=35,actual=19) | 20180115 | 00

Tried gsub to eliminate but it is not working.

Code:

 awk -F '[|]' '{gsub(/^~*/,"",$3)}; {print $3}' filename

Please guide how should i handled the regex pattern strings.

Last edited by RudiC; 02-08-2018 at 03:42 AM.. Reason: Changed [PHP] to [CODE] tags

sadique.manzar

View Public Profile for sadique.manzar

Find all posts by sadique.manzar

02-08-2018

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Which pattern? Please be way more specific and precise.

RudiC

View Public Profile for RudiC

Find all posts by RudiC

02-08-2018

Registered User

5,091, 1,931

Join Date: May 2012

Last Activity: 15 July 2020, 4:46 AM EDT

Location: Simplicity

Posts: 5,091

Thanks Given: 565

Thanked 1,931 Times in 1,668 Posts

At the beginning of a regular expression the ^ has the special meaning "at the very beginning".
Needs to be escaped

Code:

gsub(/\^~/,"",$3)

The following has the special and the literal ^

Code:

gsub(/^ \^~/,"",$3)

Meaning: at the very beginning of field 3 there must be a space then a ^ then a ~
Because all what matches is substituted, the space is also substituted. Can be added in the substitution string.

This User Gave Thanks to MadeInGermany For This Post:

MadeInGermany

View Public Profile for MadeInGermany

Find all posts by MadeInGermany

02-08-2018

Registered User

81, 3

Join Date: Sep 2017

Last Activity: 3 October 2019, 8:02 AM EDT

Location: Bangalore, India

Posts: 81

Thanks Given: 63

Thanked 3 Times in 3 Posts

strings for field $3 with start with ^~ should be replaced by "Unkown Reason"

sadique.manzar

View Public Profile for sadique.manzar

Find all posts by sadique.manzar

02-08-2018

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

As MadeInGermany already suggested, try:

Code:

awk '{sub(/^ \^~/," Unknown Reason",$3)}1' FS=\| OFS=\| file

or

Code:

awk '$3~/^\^~/{$3="Unknown Reason"}1' FS=' *\\| *' OFS=' | ' file

or

Code:

awk '$3~/^ \^~/{$3=" Unknown Reason"}1' FS=\| OFS=\| file

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

02-08-2018

Moderator

1,484, 567

Join Date: Mar 2011

Last Activity: 28 November 2020, 9:34 AM EST

Posts: 1,484

Thanks Given: 68

Thanked 567 Times in 444 Posts

Misread the requirement, apologize.

Regards
Peasant.

Peasant

View Public Profile for Peasant

Find all posts by Peasant

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Rearrange or replace only the second line after pattern match or pattern match

Im using the command below , but thats not the output that i want. it only prints the odd and even numbers. awk '{if(NR%2){print $0 > "1"}else{print $0 > "2"}}' Im hoping for something like this file1: Text hi this is just a test text1 text2 text3 text4 text5 text6 Text hi...

2. Shell Programming and Scripting

sed command to replace two character pattern with another pattern

Not able to paste my content. Please see the attachment :-(

3. Shell Programming and Scripting

Replace pattern with new one

Hi, I have file as follows. And i want to remove {,} and ' from the line with :4488: to :-}. INPUT FILE :2020:WITCH13288008772 :4488:20131015INR250000,03 :5500:00000060020001752 {Mr. Chintan ' Add1} . { } Add2 :5518:WITC0000822 -} OUTPUT FILE :2020:WITCH13288008772...

4. Shell Programming and Scripting

Linux: replace pattern with pattern

Hi, I am a rookie of Linux. I have a problem on how can I replace a certain pattern in Linux with nothing. Can anyone help me?:( sample.txt: <binding>App189 ABC SampleMachine1 ABC XXX YYY ZZZ </binding> <binding>App190 ABC SampleMachine2 ABC XXX YYY ZZZ </binding> <binding>App191...

5. Shell Programming and Scripting

pattern match and replace another pattern in same line

I have a pattern username:x:32005:32006::/usr/local/user:/bin/bash I need to match the line containing username and replace /bin/bash with /usr/local/my/bin/noshell So it becomes username:x:32005:32006::/usr/local/user:/usr/local/my/bin/noshell

6. Shell Programming and Scripting

replace pattern after the first pattern match

I need this. aaa OOOOO bbb ccc OOOOO ddd fff ggg OOOOO iii OOOOO I need all OOOOO replaced with PPPPP, but only change after the pattern ggg. So the first two OOOOO should not be changed. OUTPUT should be :- aaa

7. Shell Programming and Scripting

How to replace anything before a pattern?

Hi, I have the following text file: facdat=$SPDR_SHARED_SCRIPTS/mdb_facdat.pl -s fnma; upddte=$AGENCY_SCRIPTS/get_upddte.pl -f $EMBS_DAILY_DIR/$filenm $SASRUN $AGENCY_SCRIPTS/fnma_daily_factors.sas -sysparm "$facdat $upddte" $SASRUN $AGENCY_SCRIPTS/fnma_daily_addtn.sas -sysparm "$facdat...

8. Shell Programming and Scripting

How to replace pattern

Hello EveryOne, I have a file "test" with following entry. this is test prtestad yes this is test . Above i have colored pr and ad . Actually requirement is to replace all words starts with pr and ends with ad should be replaced by word prahlad . Means after changes...

9. Shell Programming and Scripting

perl:: search for tow pattern and replace the third pattern

Hi i want to search two pattern on same line and replace onther pattern.. INPut file aaaa bbbbb nnnnnn ttttt cccc bbbbb nnnnnn ppppp dddd ccccc nnnnnn ttttt ffff bbbbb oooooo ttttt now i want replace this matrix like.. i want search for "bbbbb","nnnnnn" and search and replace for...

10. Shell Programming and Scripting

SED Search Pattern and Replace with the Pattern

Hello All, I have a string "CP_STATUS OSSRC_R6_0_Shipment_R1H_CU AOM_901046 R1H_LLSV1_2008031", and I just want to extract LLSV1, but I dont get the expected result when using the sed command below. # echo "CP_STATUS OSSRC_R6_0_Shipment_R1H_CU AOM_901046 R1H_LLSV1_2008031" | awk '{print...

Login or Register to Ask a Question