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

amangeles · #1 (**permalink**) 01-10-2006

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 ANGELO2 xxxxxxxxx

Note that the number of x's should match the number of characters replaced, that is, since -809.05 is 7 chars long, it should be replaced by 7x's. The x's should also be in the same position as where the original negative sign was to preserve the line spacing of the file.

Any idea how to do this? Thanks for your help.

tmarikle · #2 (**permalink**) 01-10-2006

There is probably a more effecient way but this was easy:

Code:

awk '$NF >= 0 {print}
     $NF < 0 {gsub(/./,"x",$NF) ; print}' yourdata

zazzybob · #3 (**permalink**) 01-10-2006

How about just using bash builtins?

Code:

# ./amangeles.sh
78 ANGELO xxxxxxx
79 ANGELO2 xxxxxxxxx
# cat ./amangeles.sh
#! /bin/bash

while read line; do
   set -- ${line}
   echo "${1} ${2} ${3//?/x}"
done < amangeles.txt

exit 0

Cheers
ZB

vino · #4 (**permalink**) 01-11-2006

Quote:

Originally Posted by zazzybob

How about just using bash builtins?

Code:

# ./amangeles.sh
78 ANGELO xxxxxxx
79 ANGELO2 xxxxxxxxx
# cat ./amangeles.sh
#! /bin/bash

while read line; do
   set -- ${line}
   echo "${1} ${2} ${3//?/x}"
done < amangeles.txt

exit 0

Cheers
ZB

ZB, your script will replace the numbers irrespective of whether they are positive or negative. Your script enhanced..

Code:

[/tmp]$ cat sub.txt
78 ANGELO -809.05
77 ANGELO2 5,000.06 
79 ANGELO2 -5,000.06 
[/tmp]$ ./sub.sh 
78 ANGELO xxxxxxx
77 ANGELO2 5,000.06
79 ANGELO2 xxxxxxxxx
[/tmp]$ cat sub.sh
#! /bin/sh

while read line; do
   set -- ${line}
   [[ "${3}" == *-* ]] && echo "${1} ${2} ${3//?/x}" || echo "${line}"
done < sub.txt
[/tmp]$

Cheers'
Vino

zazzybob · #5 (**permalink**) 01-11-2006

Good catch Vino - my bad there - didn't read the original post properly

Cheers
ZB

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
String Replacement Script	jbud	Shell Programming and Scripting	6	11-15-2007 06:37 AM
Need shell/sed script for grep+string replacement	pranavagarwal	Shell Programming and Scripting	3	11-15-2007 06:35 AM
read string, check string length and cut	ozzy80	Shell Programming and Scripting	9	03-21-2007 05:56 PM
String Replacement with Perl	Lindarella	Shell Programming and Scripting	4	09-29-2006 02:05 PM
String replacement in multiple files	WABonnett	Shell Programming and Scripting	2	02-17-2004 03:49 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by