Break up a string of text and variables

[basanth27]

What would happen if a charachter is introduced? Probably this would upset if a dynamic text happens to come up.
Honestly, I wasnt quite able to understand completely as to what you intended to do.
Parsing is always an issue and at times requires quite a bit of tweak. Here is one simple example, see if this helps you to achieve what you intend to.

Code:

ostrValue = "WebTableTitleProduct :TypeOfProductExpiration :N/AOrder Status :Order Initiation Project Id :<variable number>Opportunity Id :N/ARequest Id :<variable number>Brand :N/ATerm :N/ACommitment :N/A"
oValue = Split(ostrValue,":")

For i = Lbound(oValue) to Ubound(oValue)
    msgbox oValue(i)
Next