Skip to content

Instantly share code, notes, and snippets.

@swapnilshrikhande

swapnilshrikhande/sf_formula_reverse_str_wrds

Created September 11, 2014 11:43
Show Gist options
  • Save swapnilshrikhande/8654bd64ba5a3aad757e to your computer and use it in GitHub Desktop.
Save swapnilshrikhande/8654bd64ba5a3aad757e to your computer and use it in GitHub Desktop.
Download ZIP
SF formula reverse string words
Raw
sf_formula_reverse_str_wrds
RIGHT(TRIM(BLANKVALUE(Nickname__c, '')),( LEN(TRIM(BLANKVALUE(Nickname__c, ''))) - FIND(' ',TRIM(BLANKVALUE(Nickname__c, ''))) )- 1)
+' '
LEFT(TRIM(BLANKVALUE(Nickname__c, '')), FIND(' ',TRIM(BLANKVALUE(Nickname__c, ''))))
@swapnilshrikhande
Copy link
Author

where Nickname__c = word1 word 2 , then formula = word2 word1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment