with_out_user
asked on
VLookUP by vbscript
If I have 2 CSV file as following:
File 1:
aaa,111
bbb,222
ccc,333
ddd,444
Fille2 as following
C1,C2,aaa,C3,C4
C1,C2,ddd,C3,C4
C1,C2,aaa,C3,C4
C1,C2,ccc,C3,C4
C1,C2,bbb,C3,C4
C1,C2,aaa,C3,C4
C1,C2,bbb,C3,C4
C1,C2,aaa,C3,C4
C1,C2,aaa,C3,C4
C1,C2,ccc,C3,C4
I want vbscript to open both csv file and create new csv. the new csv file will be like file2 but script will add new colmun wich will convet aaa to 111 and bbb to 222 which take from file 1
C1,C2,aaa,111,C3,C4
C1,C2,ddd,444,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,ccc,333,C3,C4
C1,C2,bbb,222,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,bbb,222,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,ccc,333,C3,C4
Thank you
File 1:
aaa,111
bbb,222
ccc,333
ddd,444
Fille2 as following
C1,C2,aaa,C3,C4
C1,C2,ddd,C3,C4
C1,C2,aaa,C3,C4
C1,C2,ccc,C3,C4
C1,C2,bbb,C3,C4
C1,C2,aaa,C3,C4
C1,C2,bbb,C3,C4
C1,C2,aaa,C3,C4
C1,C2,aaa,C3,C4
C1,C2,ccc,C3,C4
I want vbscript to open both csv file and create new csv. the new csv file will be like file2 but script will add new colmun wich will convet aaa to 111 and bbb to 222 which take from file 1
C1,C2,aaa,111,C3,C4
C1,C2,ddd,444,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,ccc,333,C3,C4
C1,C2,bbb,222,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,bbb,222,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,aaa,111,C3,C4
C1,C2,ccc,333,C3,C4
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you alot,
I will check it and reply with result
I will check it and reply with result
ASKER
Thank you
Work Fine and as i need
Work Fine and as i need
Great, glad that was useful. Thanks.
~bp
~bp
Open in new window