Replace multiple given string with others

Question

I have a text file like this :

Stone, John
Priya, Ponnappa
Wong, Natalie
Stanbrige, Natalie
Lee-Walsh, Natalie
Li, Natalie
Ithya, Ruveni
French, Tamzyn
Simoes, Salome
Virtue, Jackie
Campbell-Gillies,Jackie
Anderson, John
Kazantzis, John
Blair, Ruveni
Meldrum, Jackie
Smith, Maureen 
Burch, Ruveni
Harry, Verona
Andrews, Ruveni
Ellawala, Ruveni

I was able to do it with sed, but i don't found it pretty :

  sed 's/Ruveni/Ahmed/g' | sed 's/Verona/Sandro/g' | sed 's/Natalie/Chloé/g' | sed 's/John/Holly/g' | sed 's/Jackie/Melissa/g'

This will do the work by replacing the name, is there a more clean way to do it with sed or better with awk ?

Thank you soo much

Check replace text based on a dictionary

Wiktor Stribiżew
– Wiktor Stribiżew

2019-12-20 10:35:23 +00:00
Commented Dec 20, 2019 at 10:35 — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Dec 20, 2019 at 10:35
Is there a way to do it without a dictionary ?

StillLearningHowtodoit
– StillLearningHowtodoit

2019-12-20 10:44:28 +00:00
Commented Dec 20, 2019 at 10:44 — StillLearningHowtodoit
– StillLearningHowtodoit, Commented Dec 20, 2019 at 10:44
No idea what you mean. What do you expect?

Wiktor Stribiżew
– Wiktor Stribiżew

2019-12-20 10:51:00 +00:00
Commented Dec 20, 2019 at 10:51 — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Dec 20, 2019 at 10:51

Walter A · Accepted Answer · 2019-12-22 22:48:36Z

1

In case you want to go with key value pair approach then you could try following.

awk '
BEGIN{
  FS=OFS=", "
  array["Ruveni"]="Ahmed"
  array["Verona"]="Sandro"
  array["Natalie"]="Chlo"
  array["John"]="Holly"
  array["Jackie"]="Melissa"
}
{
  for(i=1;i<=NF;i++){
    $i=$i in array?array[$i]:$i
  }
}
1
' Input_file

OR why not simply combine all your sed substitutions separated with ; like following:

sed '
s/Ruveni/Ahmed/g;
s/Verona/Sandro/g;
s/Natalie/Chlo/g;
s/John/Holly/g;
s/Jackie/Melissa/g;
' Input_file

edited Dec 22, 2019 at 22:48

Walter A

20.2k2 gold badges29 silver badges46 bronze badges

answered Dec 20, 2019 at 10:49

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Replace multiple given string with others

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related