I have one Text field on Custom Object as follows -
Product_Info__c = 'DESKTOP:10,LAPTOP:20,MOUSE:20,PHONE:25' //sample value
I want to create new formula field as DesktopCount__c which will result value as 10 in above case.
DesktopCount = 10
LAPTOPCount = 10 .. etc
Note: I can do this apex but wanted to check if its possible to do using formulas.