Coud you please help?

I need convert this SQL code to Salesforce Formula

left(Price_Lookup_Id, case when charindex(':', Price_Lookup_Id) = 0 then len(Price_Lookup_Id) else charindex(':', Price_Lookup_Id)-1 end

Do you have any idea how to rewrite to formulas sytnax?