subsitute parts from a file (information in a string)

[ansir]

Hello,

I've file, with following content

sys      true    hide    Basesystem
desktop      true    show    Xserver, Gnome, Kde, ...
office       true    show    Openoffice, TeX, Acroread, Groupwise, ...
science      false   show    gnuplot, xmgrace, octave, R, ...

Then I've string in a file
"desktop" "science"

With the information of that file I want change the previous file, in each line where the key word is in the string I want "true" in the second column, otherwise there should bei false...

in this example

sys  false   hide    Basesystem
desktop      true    show    Xserver, Gnome
office       false    show    openoffice, TeX, 
science      true   show    xmgrace, octave, R, ...

(the seperator is tab ...)

How can I do this ( in a nice way)?

Ansir

[Franklin52]

Try:

awk 'NR==FNR{p=$1;s=$2;next}$1==p{$2=s}1' OFS="\t" file_with_string mainfile

[ansir]

thank your for the answer, but i think it doesn't work for me (or my question was not clear enough)

mainfile

sys	true	hide	Basesystem
desktop	false	show	Xserver, Gnome, Kde, ...
office	true	show	Openoffice, Groupwise, ...
science	false	show	gnuplot, xmgrace, R, ..

then I have a file dat.tmp

"desktop" "office"

nothing happens

when I remove the '"' an try

awk 'NR==FNR{p=$1;s=$2;next}$1==p{$2=s}1' dat.tmp mainfile

sys     true    hide    Basesystem
desktop office show Xserver, Gnome, Kde, ...
office  true    show    Openoffice, Groupwise, ...
science false   show    gnuplot, xmgrace, R, ..

In the line of desktop there appears "office"....

but I want the following

mainfile

sys	false	hide	Basesystem
desktop	true	show	Xserver, Gnome, Kde, ...
office	true	show	Openoffice, Groupwise, ...
science	false	show	gnuplot, xmgrace, R, ..

the second column should be "true" when one can find a element of the string in it, otherwise the second column should bei false

Ansir

[Franklin52]

I'm sorry, misread something, try this one:

awk '
NR==FNR{
  gsub("\"","")
  p=$1;s=$2
  next
}
$1==p || $1==s{$2="true"}
1' OFS="\t" dat.temp mainfile