how to replace strings in file based on values from another file? (example inside)

Question

how to replace strings in file, based on values from another file.

Example, 2 files - input, output

input:

12345 1

output:

(1,'a lot of text', 'some other info',0,null, 12345),
(2,'a lot of text', 'some other info',0,null, 12345),
(3,'a lot of text', 'some other info',0,null, 12345),
(4,'a lot of text', 'some other info',0,null, 12345),
(5,'a lot of text', 'some other info',0,null, 12345);

Needs to be done:

read values from file 'input', and replace all '12345' with '1' in file 'output'. Thanks for help in advance

Beta · Accepted Answer · 2011-03-12 17:08:52Z

4

How about:

sed `sed 's|\(.*\) \(.*\)|s/\1/\2/|' input` output

answered Mar 12, 2011 at 17:08

Beta

99.5k18 gold badges159 silver badges156 bronze badges

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

Comments

Dennis Williamson · Accepted Answer · 2011-03-12 18:59:41Z

2

No need to have AWK repeatedly call sed. Just have AWK read the first file into an array:

awk -F "[ )]" 'NR == FNR {a[$1] = $2; next} {sub($(NF-1), a[$(NF-1)]); print}' key-value-file main-file

answered Mar 12, 2011 at 18:59

Dennis Williamson

364k95 gold badges386 silver badges446 bronze badges

Comments

Erik · Accepted Answer · 2011-03-12 16:22:01Z

0

cat input | while read src rep
do
  sed -i "s, $src), $rep),g" output
done

Remember to make a backup of "output".

EDIT: Also note that if "input" contains characters that are special to sed, this will fail. For plain letters/digits it'll work fine.

edited Mar 12, 2011 at 16:22

answered Mar 12, 2011 at 16:16

Erik

91.8k13 gold badges203 silver badges192 bronze badges

2 Comments

Ben Over a year ago

Also consider perl -pe as a general purpose, more powerful sed.

Alex Kurkin Over a year ago

Thanks, I'd found solution like you suggested, but I couldn't use it because of error: bash: syntax error near unexpected token `done'

Alex Kurkin · Accepted Answer · 2011-03-12 17:03:04Z

0

ok, I came across this solution:

cat input | awk '{ cmd = "sed s/," $1 ",/," $2 ",/g" " output > output.new"; print system(cmd) }'

answered Mar 12, 2011 at 17:03

Alex Kurkin

1,06910 silver badges17 bronze badges

1 Comment

John Zwinck Over a year ago

No need for the cat; just give the file to awk.

Collectives™ on Stack Overflow

how to replace strings in file based on values from another file? (example inside)

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related