Yea, use the
FIND method coupled with an
IF or two, and you should be on your way.
Example: (decimal) DesktopCount =
If the prefix text is there, grab the MID text between the prefix-text and its delimiter.
I didn't test my function, but the basic idea is there. I want my formula to do the following:
(1) Check if the "prefix-text" is there.
Example: is "Desktop:" in my string?
Available Functions: CONTAINS()
(2) If yes, take the text between the prefix-text and the delimiter
Example: prefix-text="Desktop:"; delimiter=","; result = "10"
Available Functions: MID(), FIND()
(3) If there is a result, convert it to a number
Available Functions: VALUE()
Here's a list of Formula Functions you can use.