Hi,

Iam having the two files as follows:

file1:

ASQWEDFR09876543121234512
POIUYTREW09876512345676788
ZXCVBNMKS1209888888888888

file2:
ASQWEDFR09876543121234516 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----
CXADFGTU09876543121234789 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----
KLOPIUYRE09876541234234516 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----
ZXSDCVFG09876512345634516 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----


i WANT TO update the contents in file1 to file2 and remove the other lines.

example.:

ASQWEDFR09876543121234516 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----
POIUYTREW0987651234567678 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----
ZXCVBNMKS1209888888888888 asdcvfgbtg@abc.com 0000000-90-1239--2008 8990----

paste file_update file_to_be_updated | awk ' { print $1" " $3" "$4}' > final
cat final > file_to_be_updated

grep -f file1 file2 > out.txt

Hi,

Thanks for your reply. It is working fine, but iam having the file 2 as follows:

file 2

QWERTYUI098765432112345  abc@soft.com                                                                            2007-09-260012275.80 0000924 00245.00 2007-10-25ASDFRESS,POIU                                                 S                                000000000000015.52 000000000000000.00 CBB00010000000906

QWERTYUI098765432112345
QWIUYTUI098765432112345
CDXRTYUI098765432112345

Here also in file 2 , there is 40 spaces in between the email id and the next number. while copying it is not correctly pasted.

Thanks

use vB Codes when posting code or data samples.

how to use this vb codes??