Visit Our UNIX and Linux User Community


Replace Pattern with another that has Special Characters


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Replace Pattern with another that has Special Characters
# 1  
Old 04-03-2019
Replace Pattern with another that has Special Characters

Hello Team,

Any help would be much appreciated for the below scenario:

I have a sed command below where I am trying to replace the contents of 'old_pkey' variable with 'new_pkey' variable in a Soap request file (delete_request.txt). This works fine for regular string values, but this new_pkey has '/' that is breaking my sed command (sed: -e expression #1, char 122: unknown option to `s').

What I want to achieve is to replace the
Code:
'13670163|Customer|Home|Ask||MONTGOMERY|AL|36116'

with
Code:
'2141899|Customer|Home|N/A||N/A|NY|N/A' in the file delete_request.txt

Code:
old_pkey='13670163|Customer|Home|Ask||MONTGOMERY|AL|36116'
new_pkey='2141899|Customer|Home|N/A||N/A|NY|N/A'

sed "s/<urn:sourceKey>$old_pkey<\/urn:sourceKey>/<urn:sourceKey>$new_pkey<\/urn:sourceKey>/g" delete_request.txt

# 2  
Old 04-03-2019
If your script is written in bash or ksh you could try the following parameter substitution:
Code:
${pnewkey//\//\\\/}

It may be more readable to use a different delimiter in the sed expression:
Code:
sed s^to_change^new/text^g

It's what I would normally suggest, but what if your new delimiter is required next time?

Andrew
# 3  
Old 04-03-2019
Sorry, forgot to mention, it is in bash.

--- Post updated at 02:49 PM ---

This works for '/'. Thanks. What about characters like \ ] * [

Code:
sed "s^<urn:sourceKey>$old_pkey<\/urn:sourceKey>^<urn:sourceKey>$new_pkey<\/urn:sourceKey>^g" delete_request.txt

# 4  
Old 04-03-2019
You are quite free in selecting delimiters for sed's s command:
info sed:
Quote:
The '/' characters may be uniformly replaced by any other single character within any given 's' command. The '/' character (or whatever other character is used in its stead) can appear in the REGEXP or REPLACEMENT only if it is preceded by a '\' character.
so the / don't need to be escaped any more.



But, as apmcd47 already pointed out, you need to make sure that the selected delimiter doesn't show up explicitly in your regex nor replacement, nor does any character with a special meaning in regexes, like the ones you mentioned.
For single special chars, you might fall back to your shell's "Parameter Expansion / Pattern substitution" as alluded to by apmcd47, so your command would look like

Code:
sed "s^<urn:sourceKey>${old_pkey//[/\\[}</urn:sourceKey>^<urn:sourceKey>${new_pkey//[/\\[}</urn:sourceKey>^g" delete_request.txt

If you expect more than one special char, it might be easier to create a small sed command on the fly, using another sed invocation.
# 5  
Old 04-04-2019
Hi, does it have to be sed? Try using literal strings instead of regex substitution :

Code:
awk -v old="$old_pkey" -v new="$new_pkey" '{while(i=index($0,old)) $0=substr($0, 1, i-1) new substr($0, i+length(old))}1' file

or

Code:
perl -spe 's/\Q$old/$new/g' -- -old="$old_pkey" -new="$new_pkey" file


Last edited by Scrutinizer; 04-04-2019 at 10:19 AM..
This User Gave Thanks to Scrutinizer For This Post:
# 6  
Old 04-04-2019
Wow, an example with perl -s Smilie
# 7  
Old 04-04-2019
As RudiC said, you can use characters other than "/" as the field delimiter in sed, but there are two characters that the standards say cannot be used: a <newline> character and a <null> character are not allowed as the field delimiter.

Note that nothing says that the delimiter has to be a printable character. If you're in a single person office, using ctl-g (i.e., hold down the control key and then hit the "g" key) uses the terminal's alert character as your field delimiter. On many terminals the alert character is a bell sound (which is why I only suggest using it if you do not have an office mate).

If you do this in a script you will need to heavily comment it since if someone uses cat or lpr to look at your script, it will be unreadable. In vi it will display as ^G.
This User Gave Thanks to Don Cragun For This Post:

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to replace special characters?

Hi Team, I have data like this. |*|.5|*|0.2|*|A.B|*| Would like to add zero (0) before the decimal point where there is no zero as |*|0.5|*|0.2|*|A.B|*| How to replace |*|. with |*|0. I tried below command which didn't work echo '|*|.5|*|0.2|*|A.B|*' | sed... (4 Replies)
Discussion started by: Ravi.K
4 Replies

2. Shell Programming and Scripting

Help to replace the string with special characters

{"name":"alR_pl-ENVIRONMENT_192_168_211_123_sDK_PROVISION_7","description":"aLR_pl-ENVIRONMENT_192_168_211_123_sDK_PROVISION_7","json_class":"Chef::Role","default_attributes":{},"override_attributes":{"yoapp":{"jboss":"5.1.0","port":"2243","warname":"soap","datacenter":"alR","ip":"192.168.211.123","... (3 Replies)
Discussion started by: nikhil jain
3 Replies

3. Shell Programming and Scripting

How to replace special characters?

Hi Unix Guru, I have an requirement for replace some specail characters in a file, my file came from mainframe. please see below example: when open it with vi 17896660|89059215|04/24/1998 00:00:00.000000| abc 123-453-1312^M<85>^M<85>|124557 if I run cat -v I got following:... (25 Replies)
Discussion started by: ken002
25 Replies

4. Shell Programming and Scripting

Replace special characters with Escape characters?

i need to replace the any special characters with escape characters like below. test!=123-> test\!\=123 !@#$%^&*()-= to be replaced by \!\@\#\$\%\^\&\*\(\)\-\= (8 Replies)
Discussion started by: laknar
8 Replies

5. Shell Programming and Scripting

Replace special characters

I have a line ending with special character and 0 The special character is the field separator for this line in VI mode the file will look like below, but while cat the special character wont display i know the hexa code for the special character ^_ is \x1f and ascii code is \0037, ... (0 Replies)
Discussion started by: ratheeshjulk
0 Replies

6. Solaris

How to replace special characters in vi?

Hi , I want to replace the special characters in the file. For eg: cat abc 1234/4455/acb 234/k/lll/ 234`fs`fd I want to replace / and ` with the letter a and the output should like below. How to achieve this. 1234a4455aacb 234akallla 234afsafd (2 Replies)
Discussion started by: rogerben
2 Replies

7. Shell Programming and Scripting

Using sed to replace special characters

Hi everyone I have file1 contains: '7832' ' 8765 6543 I want a sed command that will format as: '7832' , '8765' , '6543' I tried sed -e s/\'//g -e 's/^*//;s/*$//' file1 > file2 sed -e :a -e '$!N; s/\n/ /; ta' file2 which gives: 7832 8765 6543 I need some help to continue with... (5 Replies)
Discussion started by: nimo
5 Replies

8. Shell Programming and Scripting

awk search pattern with special characters passed from CL

I'm very new to awk and sed and I've been struggling with this for a while. I'm trying to search a file for a string with special characters and this string is a command line argument to a simple script. ./myscript "searchpattern" file #!/bin/sh awk "/$1/" $2 > dupelistfilter.txt sed... (6 Replies)
Discussion started by: cue
6 Replies

9. Shell Programming and Scripting

sed delete pattern with special characters

Hi all, I have the following lines <b>A gtwrhwrthwr text hghthwrhtwrtw </b><font color='#06C'>; text text (text) <b>B gtwrhwrthwr text hghthwrhtwrtw </b><font color='#06C'>; text text (text) <b>J gtwrhwrthwr text hghthwrhtwrtw </b><font color='#06C'>; text text (text) and I would like to... (5 Replies)
Discussion started by: stinkefisch
5 Replies

10. UNIX for Dummies Questions & Answers

Replace Special characters in a file

Hi, I have a data like this in a file, 402003279034002000100147626030003300010000000000002000029000000 r^M^\MW^H I need to replace those special char to some other char like # or $ Is there any ways to do it... I tried commands tr,sed and many but it was not able to replace because... (1 Reply)
Discussion started by: solai
1 Replies

Featured Tech Videos