Using conditional logic to remove "_"

Question

Hello Community,

Fighting this one up to a point i could really wish some help..

I have an automation rule that triggers every time a new customer is added to a list from Salesforce. It is than look for spaces and replaces them with "_" as it will be transform to a label field.

At this point i run on each customer, validate it, adding specific comments and update the label field.

My problem is that sometimes i get a space at the beginning of the customer name, causing it to be looking like "_Customer" instead of "Customer"

Been trying to use multiple ways (2 examples), but none are working....

1. {{#if(({{Custo}}.startsWith("_")),({{Custo}}.substringAfter("_")),{{Custo}})}}{{/}}

2. {{#if(issue.customfield_10193.replace(" ","_").startsWith("_")),(issue.customfield_10193.replace(" ","_").substringAfter("_")),(issue.customfield_10193.replace(" ","_"))}}

Any idea how can i break the list based on spaces and also validate no space at the beginning?

Bill Sheboy · Accepted Answer

Hi @Gilad Waldman

What are some examples of the contents of your customfield_10193?  That may help to decide when / how to perform the replacement of spacing to underscores.

For example, some possible configurations might be:

* Alice (Single value, with no delimiter)
* Alice Jones (Single value with first and last name, and no delimiter)
* Alice Jones, Bob Smith, Eve (Multiple names with a comma-space delimiter)
* Alice Jones,Bob Smith,Eve (Multiple names with a comma delimiter)
* etc.

From what you describe, I suspect it is a variation of #3, where the delimiter between names is a comma followed by a space.

In that case, you could try:

* change the source so the delimiter is only a comma
* replace the delimiter first in the advanced branch source, such as with:

{{issue.customfield_10193.split(", ").join(",").replace(" ","_").split(",")}}

Kind regards,
Bill