You need to sign in to do that
Don't have an account?

How to remove unwanted comma getting during "rocky-1,james-2" ..
I have field called adjuster history with record 'rocky-1,james-2,John-3' for getting first string record used formula as"LEFT(Cust_field__c, FIND("-", Cust_field__c)-1)" but if i removed rocky from database then adjuster history is like ',james-2,John-3' and i get result as ",James-2 " how do i remove unwanted comma from the result.??????
Something like this:
As a common practice, if your question is answered, please choose 1 best answer.
But you can give every answer a thumb up if that answer is helpful to you.
Thanks