Take out what is inside brackets...

[snowboardr]

What would be the best way to remove the text inside the brackets and the brackets as well..?

I have a bunch of data stored like this:

MyData = "[This is text1...]text1|text2|text3|"

then I split it up like so..

MyDateSplit = Split(MyData, "|&quot

 

[derren]

Do while instr(myData,"[")>0
   mydata=replace(mydata,mid(mydata,instr(myData,"["),instr(myData,"]")-instr(myData,"[")+1))
next ' is it next for this loop? I can never remember!
mydata=replace(mydata,"[","")
mydata=replace(mydata,"]","")

assuming that it is you who is controlling the text insertion in brackets

Derren
[Mediocre talent - spread really thin]