Skip to main content
andrew_biehle
Gainsight Employee ⭐️
Gainsight Employee ⭐️
October 27, 2020
New Idea

Find and replace text using rules.

Related products:CS Rules Engine
  • October 27, 2020
  • 3 replies
  • 143 views

Posting on behalf of customer. Currently in rules it doesn’t appear that we have the ability to find and replace text using rules efficiently. 

An example is a text field with 'Test;Test'. You would find ';' and replace that with 'and'. 

Would be nice to have an easy ‘find and replace’ option in a transformation task or something.

3 replies

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
November 20, 2020

Hi @andrew_biehle 

This is a nice idea. @All, please upvote this if you need this soon! 

john.cowles
Helper ⭐️
August 14, 2024

Having this ability in general would be really nice when working with text strings.  One recent situation we ran into is a issue where there was hidden characters in a text string that we were trying to compare to another.  It would be nice if there was a easy way to find these and in this case either remove them or replace them.

john.cowles
Helper ⭐️
January 5, 2026

Any update on this one?

We are having to send text data to another system simply to replace double quotes with single quotes in a user entered text string.  The transform workaround doesn’t work because we don’t know how many occurrences we will have of a quote in our strings.  

We are pushing some messages to Google chat and have to do that with JSON format.  So the double quotes that users enter in the text break the parsing.  So our only workaround is to send it to our platform, clean up the text, and then have it call google API.  We would prefer to have a direct call from Gainsight to the google API.  Even better would be to have a out of the box Google connected system like you have with slack now.