Skip to main content
Salesforce

Return to Question

edited tags
Link
Derek F
Derek F
  • 64.1k
  • 15
  • 55
  • 104
added 9 characters in body
Source Link
Ostap
Ostap
  • 1
  • 2

Coud you please help?

I need convert this SQL code to Salesforce Forula leftFormula

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?

Coud you please help?

I need convert this SQL code to Salesforce Forula 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?

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?

Source Link
Ostap
Ostap
  • 1
  • 2

Could you please help me to write a formula Salesforce

Coud you please help?

I need convert this SQL code to Salesforce Forula 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?