Find then If then Replace

C

cisq1

hi , i have 2 x files
file 1
col1 col2 col3 col4
abc 123 text1a
def 456 text2a
def 789 text3a
ghj 456 text4a

file2
col1 col2 col3 col4
abc 123 text1
def 456 text2
def 789 text3
ghj 456 text4

after i combine them i am trying to
1. if data in col1 and col2 are the same then take data in col3 (was from
file2) and replace it into col3 of file 1.
2.then delete that row (ie the row originally from file2)
end result like this
file 1
col1 col2 col3 col4
abc 123 text1 text1a
def 456 text2 text2a
def 789 text3 text3a
ghj 456 text4 text4a

hope that makes sense .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top