Replace string at end of matching line 2

[RFC1795]

Hi all,

This is probably simple but for some reason I'm struggling to find an answer.

I'm hoping to use sed to replace a random string in a file that matches a string with something else.

Example, in the file.txt it contains various lines of text and also the lines I wish to change:

text
Telephone number 1 555-3232
more text
Telephone number 1 3432223
Fax number 1 4645787-344
more text etc

I'm looking to replace the last string in any lines matching: "string 'number 1' <string_to_be_replaced>"

So I want to come out with something like this:

text
Telephone number 1 XXXXXXX
more text
Telephone number 1 XXXXXXX
Fax number 1 XXXXXXX
more text etc

Hope that makes sense.

Thanks... T

 

[feherke]

Hi

Like this ?

sed '/number 1/s/\S*$/XXXXXXX/' /input/file

Feherke.

http://rootshell.be/~feherke/

 

[RFC1795]

Hi Feherke

Thanks, that's pretty close to what I need, except I still see the numbers.

Output appears as so using your example:

text
Telephone number 1 555-3232XXXXXXX
more text
Telephone number 1 3432223XXXXXXX
Fax number 1 4645787-344XXXXXXX
more text etc

I'll have a play around with what you suggested and see how I get on.

Thanks... T

 

[feherke]

Hi

I forgot the usual blah-blah : tested with GNU [tt]sed[/tt].

Try this :

sed '/number 1/s/[0-9-]*$/XXXXXXX/' /input/file

Feherke.

http://rootshell.be/~feherke/

 

[RFC1795]

Hi Feherke

That does look a whole lot better

Thanks a lot for your help there!!

Cheers... T

 

[RFC1795]

BTW, why when I click the " Thank feherke
for this valuable post!" does nothing happen?

No message saying a window been blocked and I've got full jave enabled.

Strange?

 

[RFC1795]

Never mind ... I figured out the voting issue. Window was open and hidden under the piles of other ones hehe.

However, I've been thinking of using the above line in another area for another file containing passwords.

I applied the following to my test file:

sed '/password/s/[0-9 A-Z-]*$/ XXXXXXXXXXXX/'

However, the password contains various other characters eg:

$1$LuDC$b/siw3\*&sw.{]%sdjhakw83q2

Is this also something easily adjusted in the above line? I tried some options but gave up as it's not urgent really.

Thanks T

 

[Annihilannic]

Rather than trying to list all possible encrypted password characters in your character class, you can instead use an exclusion list based on the field separator. If the syntax of the file just uses space separators, e.g.:

password $1$LuDC$b/siw3\*&sw.{]%sdjhakw83q2

Then this should do it:

sed '/password/s/ [^ ]*/ XXXXXXXXXXXX /'

If that's not the syntax of the file and you can't figure out how to change it, please post an example of the file content.


Annihilannic.

 

[feherke]

Hi

I think RFC1795 actually posted an example of file content :

 [red]ID[/red] [green]username[/green]     [blue]password[/blue]
 [red]|[/red]  [green]|_[/green]   [blue]___________|____________[/blue]
 [red]|[/red] [green]/[/green]  [green]\[/green] [blue]/[/blue]                        [blue]\[/blue]
[gray]$[/gray][red]1[/red][gray]$[/gray][green]LuDC[/green][gray]$[/gray][blue]b/siw3\*&sw.{]%sdjhakw83q2[/blue]
[gray]|[/gray] [gray]|[/gray]    [gray]|[/gray]
[gray]+-+----+--- delimiter[/gray]

In which case Annihilannic's code needs just minor modifications :

sed 's/\$[^$]*$/$XXXXXXXXXXXX/'

Feherke.

http://rootshell.be/~feherke/

 

[RFC1795]

Hi chaps

Thanks both for taking the time to help and explain this one for me

I've tried both examples you provided. Annihilannic one replaced the word password with X's
And Feherke's one replaced some of it exactlly as described it would.

The thing is, that whole string is the actual password in its encrypted format:

$1$LuDC$b/siw3\*&sw.{]%sdjhakw83q2

Maybe it would be better to work it this way; replace the whole string after the word password as i'm sure it will always be only that (I hope anyway)

I'm just struggling to understand the deliminator syntax to make it work.

 

[PHV]

What about this ?

sed '/password/s/ [^ ]*$/ XXXXXXXXXXXX/'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RFC1795]

Thanks PHV - works 100% that

Thanks all for the help as usual .. one day all these bits and pieces of puzzling bits will fall into place in my head hehe.

Cheers... T