Recursive replacement of search string using sed


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Recursive replacement of search string using sed
# 1  
Old 09-01-2014
Recursive replacement of search string using sed

Dear Unix Forum Group Members,

Please do let me know how I can replace the double pipe with single pipe recursively on single record.

Sample Input Data:
Code:
 DN set|Call prefix||| Called number address nature
 0||| *789|||||||ALL number types
 0||| 00||||||||ALL number types
10|| 001||||||||International Destination

Expected Output:
Code:
 DN set|Call prefix| Called number address nature
 0| *789|ALL number types
 0| 00|ALL number types
10| 001|International Destination

Below is the script which I'm using now. There may be chances that consecutive pipe count can be increased.

Code:
cat test.txt |sed -e 's/  /|/g' -e 's/||/|/g' -e 's/||/|/g' -e 's/||/|/g' -e 's/||/|/g' -e 's/||/|/g' -e 's/||/|/g'

Thanks in advance!

Thanks,
Reddy

Last edited by Scrutinizer; 09-01-2014 at 06:08 AM.. Reason: CODE tags
# 2  
Old 09-01-2014
Why so many? One should suffice?
Code:
sed 's/||/|/g' file

# 3  
Old 09-01-2014
I want all consecutive pipelines (two or more than two pipe's) should be replaced with single pipe only.
# 4  
Old 09-01-2014
Hello Srinu,

Welcome to forum, please use code tags while posting any commands or code as per forum rules. Here is an awk solution which can help.


Code:
awk '{gsub(/\|+/,"|",$0);print}' filename

Output will be as follows.

Code:
DN set|Call prefix| Called number address nature
0| *789|ALL number types
0| 00|ALL number types
10| 001|International Destination


Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
# 5  
Old 09-01-2014
Quote:
Originally Posted by srinu.kadem
I want all consecutive pipelines (two or more than two pipe's) should be replaced with single pipe only.
Ow yes, I meant:
Code:
sed 's/||*/|/g' file

This User Gave Thanks to Scrutinizer For This Post:
# 6  
Old 09-01-2014
If your tr has the -s (squeeze) option:
Code:
tr -s '|' '|' <file3
 DN set|Call prefix| Called number address nature
 0| *789|ALL number types
 0| 00|ALL number types
10| 001|International Destination

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Recursive search for string in file with Loop condition

Hi, Need some help... I want to execute sequence commands, like below test1.sh test2.sh ...etc test1.sh file will generate log file, we need to search for 'complete' string on test1.sh file, once that condition success and then it should go to test2.sh file, each .sh scripts will take... (5 Replies)
Discussion started by: rkrish123
5 Replies

2. UNIX for Advanced & Expert Users

Full System Recursive Search for a String - Not Finishing

Using grep -r -H "foobar" / > result to give all files that contain the string "foobar" Half way , its waiting for some thing and does not end Not Sure whats happening. Any help is much appreciated Thank you (2 Replies)
Discussion started by: shorn
2 Replies

3. Shell Programming and Scripting

Use regex in replacement string in SED

Hi, I need to use the regex in the replacement string in SED command. something like sed -e ' s/\(^\{5\}\).\{150\}\(.*\)$/\10\{30\}1\{30\}A\{60\}B\{30\}\2/' abc which means for all the lines in file abc that starts with 5 characters, I need to replace character 6-151... (6 Replies)
Discussion started by: snowline84
6 Replies

4. UNIX for Dummies Questions & Answers

sed string replacement question

Hey everybody. I've got a simple problem but am unsure how to resolve it. I am using a script to edit multiple files at once. Inside the script I am using an sed command to make the changes. My problem is that I can only get it to work for stings that contain a word or words. How can I modify it to... (1 Reply)
Discussion started by: iwatk003
1 Replies

5. Shell Programming and Scripting

Exact String replacement with sed

Hi, What should be the syntax to match and replace an exact string using sed? And not replacing any string that contain the value? Eg. testtest etstetst testetst testtttt etsttest testtesttest testtest I only want to replace the line with exact string "testtest" with "123456" ... (2 Replies)
Discussion started by: srage
2 Replies

6. Shell Programming and Scripting

SED complex string replacement

sed -i 's:"ps -ef | grep $(cat $PID_FILE) | grep -v grep":"ps -C java -o pid,cmd | grep ${SERVER_NAME} | cut -d' ' -f1 | grep -v grep":g' scriptName That's what I'm attempting to do. I'm attempting to replace this: ps -ef | grep $(cat $PID_FILE) | grep -v grep with this: ps -C java -o... (5 Replies)
Discussion started by: cbo0485
5 Replies

7. Shell Programming and Scripting

String replacement using sed

I need to search and replace a particular string in a file. Only the exact match of the string should be replaced. eg: File contents : abc abcd abcdef --> Replace only 'abc' with 'xyz', but it should not replace abcd with xyzd. So the o/p should be: xyz abcd abcdef. How can this be done? I... (5 Replies)
Discussion started by: sngk
5 Replies

8. Shell Programming and Scripting

sed script for search and replacement

New to scripting.. think i need sed to do the following but need help. have a properties files with variable i need to replace using substitution for e.g in x.properties xslt.root.dir=/apps1/test/cs.war/presentation/xsl have a shell script with following echo "Edit... (3 Replies)
Discussion started by: cookie23patel
3 Replies

9. Shell Programming and Scripting

Recursive Search and replace only when found string

Hello all ( again ) I will like to search and replace string in text file ok I can loop throw the files like : foreach f ( ` find . -name "*."`) .. but here I like to examine the file if in contain the desired string and so do the sed -e 's/blah/foo/g' thingy on it or there is better way... (1 Reply)
Discussion started by: umen
1 Replies

10. Shell Programming and Scripting

sed problem - replacement string should be same length as matching string.

Hi guys, I hope you can help me with my problem. I have a text file that contains lines like this: 78 ANGELO -809.05 79 ANGELO2 -5,000.06 I need to find all occurences of amounts that are negative and replace them with x's 78 ANGELO xxxxxxx 79... (4 Replies)
Discussion started by: amangeles
4 Replies
Login or Register to Ask a Question

Featured Tech Videos