Hi,

I have two columns, COL1 and COL2. COL1 has value like "Birds sitting on $1 and enjoying" and COL2 has value like "the.location_value[/tree,\building]"

I need to update thrid column COL3 with values like "Birds sitting on /tree and enjoying"

i.e. "$1" in 1st column is replaced with "/tree"
which is 1st word from list of comma seperated words with in square brackets [] in COL2
i.e. [/tree,\building]

I wanted to know the best sutable combination of string function to use to achieve this.

Thanks,
-Anand