Break up a string of text and variables

[csutter2002]

Hi, I am looking at a table with many "columns" of data actually being just one cell that looks like it has many. Parts of that returned cell I need to make a variable.

So the first thing I need to do is to grab the variable items out of the sentence and then put the sentence back together and check it? Or should I check the 1st part of the sentence, a variable, the 2nd part of the sentence, the 2nd variable and the 3rd part of the sentence?

So here is an example of what I am trying to parse:

"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"

Taken apart it would like this:
"WebTableTitle
Product :TypeOfProduct
Expiration :N/A
Order Status :Order Initiation
Project Id :<variable number>
Opportunity Id :N/A
Request Id :<variable number>
Brand :N/A
Term :N/A
Commitment :N/A"

Thanks for any help you can give me.