Solved

Extract substring using other fields as parameters

  • 5 October 2020
  • 4 replies
  • 138 views

Userlevel 1
Badge +2

Hello, I need to create a field that has the Email Domain for a person record, so if their email address is marysmith@abc.com, then the email domain would be “abc.com”.

 

I’ve tried doing it with Substring() via a calculated field and also a rule. I tried in a rule to do the transform task to get the position first and then added another transform task to use the position in a substring function, but it wouldn’t take a fieldname. It seems like it requires a hard coded number, so instead of being able to do something like substring(email address, @position, length), it seems that it wants something like substring(email address, 4, 10).

Is there any way for me to do this in Gainsight?

Thanks!

icon

Best answer by jean.nairon 5 October 2020, 18:14

View original

4 replies

Userlevel 6
Badge +4

Hi @tammy_c

I think you’re on the right track but I would recommend using the Right formula. It allows you to grab all the characters on the right up to a certain field. 

 

RIGHT(field, substring): extracts the right part of the string with the appearance of a string character. For example, RIGHT(johndoe@gainsight.com, @) will return “gainsight.com” as the output.

 

Here’s the rest of the support article to help you out: 

https://support.gainsight.com/SFDC_Edition/Rules_Engine/Admin_Guides/Formula_Builder_in_Bionic_Rules#String_Formulas 

 

Hope this helps!

Userlevel 1
Badge +2

Hi @jean.nairon 

That worked! Thanks! I think I had looked at right() in the formula field on the object and there it’s asking for a number, so I didn’t catch that right() in rules is looking for the substring.

 

Thanks again!

Userlevel 6
Badge +4

You’re welcome @tammy_c. Glad I was able to help!!

Userlevel 7
Badge +2

Thanks for the assist here @jean.nairon !

Reply