[Lakshmipathi]

Hi all,
I got two files say,
file1.txt and
file2.txt

file1.txt content (two fields)

page=node_1_0_1  category
page=node_1_0_2  brand

file2.txt content (only one field)

page=node_1_0_1
page=node_1_0_2

Now i want to replace file2.txt with the second field of file1.txt

I need output like,

page=category
page=brand

How to do this??Any ideas?
Thanks

[Franklin52]

Something like this:

awk 'FNR==NR{arr[$1]=$1;next} arr[$1]==$1{print}' "file2" "file1"

Regards

[Lakshmipathi]

Hi thanks for ur reply,but i'm not getting expected results.

[oss@pc021698 JAVA]$ awk 'FNR==NR{arr[$1]=$1;next} arr[$1]==$1{print}' "file2.txt" "file1.txt"
page=node_1_0_1 category
page=node_1_0_2 brand

[oss@pc021698 JAVA]$ cat file1.txt
page=node_1_0_1 category
page=node_1_0_2 brand
[oss@pc021698 JAVA]$ cat file2.txt
page=node_1_0_1
page=node_1_0_2

[Franklin52]

I think I misread something, to print only lines of file2 if the line exists in file1 try this:

awk '
FNR==NR{arr[$1]=$1;next} 
arr[$1]==$1 && $2{split($1,s"=");{print s[1],$2}
' file2 file1

Regards

[Lakshmipathi]

sorry again ,
it shows errors,unexpected new line or end of string

awk: cmd. line:4: arr[$1]==$1 && $2{split($1,s"=");{print s[1],$2}
awk: cmd. line:4:                                                 ^ unexpected newline or end of string

[Franklin52]

I apologise, a typo, remove the { before the print statement:

awk '
FNR==NR{arr[$1]=$1;next} 
arr[$1]==$1 && $2{split($1,s,"=");print s[1],$2}
' file2 file1

Regards

[Lakshmipathi]

Sorry again ...still not solved....some error in split cmd

awk: cmd. line:3: (FILENAME=file1 FNR=1) fatal: split: second argument is not an array

[Franklin52]

Sorry again, I'm just awaked, it must be:

split($1,s,"=")

Regards

[Lakshmipathi]

it works now
Thanks Franklin .. Thanks for your patience