You need to sign in to do that
Don't have an account?
shrey.tyagi88@tcs.com
Shorten text field from left hand side , by looking for specific character in the original value!!- Please help
Hi Everyone,
I have a field called department . Possible values of department are given below . I want to make a formula taht looks for "-" betwwen the words and shortens the value from left hand side for e.g:
Original value : SSES-SPHERE-BHCJ-JSR-PSIS
Final Value: SSES-SPHERE
Original Value: ADM-CFO-FIN-CTLR
Final Value: ADM-CFO
Can anyone help me here please???
Regards
Shrey Tyagi
I have a field called department . Possible values of department are given below . I want to make a formula taht looks for "-" betwwen the words and shortens the value from left hand side for e.g:
Original value : SSES-SPHERE-BHCJ-JSR-PSIS
Final Value: SSES-SPHERE
Original Value: ADM-CFO-FIN-CTLR
Final Value: ADM-CFO
Can anyone help me here please???
Regards
Shrey Tyagi
You can try this apex
String s = 'SSES-SPHERE-BHCJ-JSR-PSIS';
List<String> parts = s.split('-');
String newString = parts[0]+'-'+parts[0];
LEFT(Name,FIND("-",Name,FIND("-",Name)+1)-1)