in reply to Get the string value from one column and append to another column
Try the following approach
Probably you need some fine-tuning with the regular expressions ;-)