Page 1 of 1

Replace the string has the same first value

Posted: Sat Nov 24, 2012 11:35 am
by promanga
Hi All!
I have two datas as below:


DATA1
number1
number2
number3
number4
bumber5
....
DATA2
number1-aaaaaaaaaaaaa
number3-bbbbbbbbbbbbb
number4-ccccccccccccccc
...
I need to replace and to combine in one data like this:

number1-aaaaaaaaaaaaa
number2
number3-bbbbbbbbbbbbb
number4-ccccccccccccccc
bumber5


Can any one provide suggestion for these ?