I have a text field called "User_Edition__c". This field could have a one of three type of values.
- It could have a full text string in it like "Unlimited"
- It could have a full number like "100".
- It could have a partial number, partial text string like "100 Users".
I need a calculated field that pulls out just the number when applicable. So far I have this:
IF((User_Edition__c=='Unlimited'), 10001,
IF((ISNUMBER(User_Edition__c)), VALUE( User_Edition__c ),
IF((ISNUMBER((LEFT(User_Edition__c,FIND(" ", User_Edition__c))))), VALUE(LEFT(User_Edition__c,FIND(" ", User_Edition__c))),
NULL
)))
The first two situations work fine, the third one does not. Im logic is to split on the space in "10 Users" and check if the left side is a number. If it is then return left side as a number. At the moment it fails this and just returns NULL. Any idea why this isn't working?