I feel I am missing something basic. I have a rule to pull in contact data from an outside source with a field called "Alternative Email Address". Now, we want to use that so the field is of type 'EMail address", but if the customer leaves it blank on our Customer Portal, we add "--" in the field as a placeholder (it can't be null the way we have it submitting".
Now, reading "--" into Gainsight to load into an email address won't work so I'd like to replace or blank out that text so the rest of the record gets read in. Right now, those fail and are excluded from the load.
I have two data sets and a merge, and it seems all I need to do is transform the text. However, what is the best way to replace text "--" with "" or null?
Question
Transformation of text from one value to another
Hi Tim,
In the rules engine actions, you have an option to set any field in the target object to null.
You can set the email id to null using action criteria "Email = "--"
Let me know if that helps.
Regards,
Jitin
In the rules engine actions, you have an option to set any field in the target object to null.
You can set the email id to null using action criteria "Email = "--"
Let me know if that helps.
Regards,
Jitin
1 person likes this
Yes, I had not considered using "Criteria" to split into two actions. I will do different actions, but there are other instances where I wonder if I can transform or replace text. Are you aware if this is possible?
+11Bionic Rules *might* have a solution for you.
I don't know that you can truly transform and/or replace in Bionic Rules, but a carefully-written Bionic Rule would allow you to generate a new value within the Rule Tasks, which we might call "Email Address Plus". Then you can write logic to populate that new value with Email address, where it exists, or -- when that exists.
Not a true transform, but it might get you there.
I had a use case where I needed to concatenate the values from two fields into a third field, and used Bionic Rules to handle this. When my Bionic Rule was complete, I had three fields: the original two plus a third one with the concat, which I could take into the Actions. I didn't truly replace anything, but I got the transformed value I needed.
That said, in this context I think I would lean toward a simpler Bionic Rule and two actions, each with Criteria.
I don't know that you can truly transform and/or replace in Bionic Rules, but a carefully-written Bionic Rule would allow you to generate a new value within the Rule Tasks, which we might call "Email Address Plus". Then you can write logic to populate that new value with Email address, where it exists, or -- when that exists.
Not a true transform, but it might get you there.
I had a use case where I needed to concatenate the values from two fields into a third field, and used Bionic Rules to handle this. When my Bionic Rule was complete, I had three fields: the original two plus a third one with the concat, which I could take into the Actions. I didn't truly replace anything, but I got the transformed value I needed.
That said, in this context I think I would lean toward a simpler Bionic Rule and two actions, each with Criteria.
Agreed and thank you.
If I may learn the limits, when you concatenate, how do you avoid getting "Matthew" and "Lind" into "MatthewLind" when you want "Matthew Lind"?
If I may learn the limits, when you concatenate, how do you avoid getting "Matthew" and "Lind" into "MatthewLind" when you want "Matthew Lind"?
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.