Hi, I was trying to create a formula to get an acronym. I have one that works but it is manual and not elegant. I'm wondering if anyone has a better formula to offer.
The pattern placed between the forward slashes are interpreted in this manner:
\b refers to word boundaries -- a space in this case
\w refers to alphanumeric characters that come after non-alphanumeric characters
The join formula puts lists or arrays together, joined by the character specified between the quotes. You can use other characters aside from the period.
The pattern placed between the forward slashes are interpreted in this manner:
\b refers to word boundaries -- a space in this case
\w refers to alphanumeric characters that come after non-alphanumeric characters
The join formula puts lists or arrays together, joined by the character specified between the quotes. You can use other characters aside from the period.
Saul Macht
Formula to get acronym of a phrase
Hi, I was trying to create a formula to get an acronym. I have one that works but it is manual and not elegant. I'm wondering if anyone has a better formula to offer.
Mine:
[Phrase].split.first[0]+[Phrase].split.first(2).last[0]+[Phrase].split.first(3).last[0]+[Phrase].split.first(4).last[0]).slice(0..[Phrase].split.length-1)
Limitation: This works only for up to 4 words in the phrase.
Hi Saul!
You can try using this formula:
Here is how this formula works:
The scan formula looks through your string and returns a list of results that matches the pattern you put in between the forward slashes. You can learn more here: https://support.workato.com/solution/articles/1000244152-formula-mode-how-to-use-the-scan-function-
The pattern placed between the forward slashes are interpreted in this manner:
\b refers to word boundaries -- a space in this case
\w refers to alphanumeric characters that come after non-alphanumeric characters
The join formula puts lists or arrays together, joined by the character specified between the quotes. You can use other characters aside from the period.
I hope this helps!
Patricia Guevarra
Hi Saul!
You can try using this formula:
Here is how this formula works:
The scan formula looks through your string and returns a list of results that matches the pattern you put in between the forward slashes. You can learn more here: https://support.workato.com/solution/articles/1000244152-formula-mode-how-to-use-the-scan-function-
The pattern placed between the forward slashes are interpreted in this manner:
\b refers to word boundaries -- a space in this case
\w refers to alphanumeric characters that come after non-alphanumeric characters
The join formula puts lists or arrays together, joined by the character specified between the quotes. You can use other characters aside from the period.
I hope this helps!