topic Re: Assembling a string with multiple Variables - String Interpolation in Workato Pros Discussion Board

Assembling a string with multiple Variables - String Interpolation

tshoemaker — Tue, 25 Jan 2022 03:19:14 GMT

Wondering if Workato has the concept of String Interpolation similar to C# where you can assemble multiple strings into one string.

For example, I have the need to create a text string that says:

"Your Part is: ABC123, Red Widget, and it will deliver on Feb 1 2022"

This is made up of three variables PartNum, PartDesc, and DelDate.

I know that I could use a formula such as:

"Your Part is: "+PartNum+", "+PartDesc+", and it will deliver on: "+DelDate

BUT.. in C# and other languages there is the concept of String Interpolation. The above could be written like this:

"Your Part is: {0}, {1}, and it will deliver on: {3}",PartNum, PartDesc, DelDate

Is this a thing in Workato Forumlas?

Re: Assembling a string with multiple Variables - String Interpolation

roland-daane — Tue, 25 Jan 2022 03:28:00 GMT

Hi Tim, Welcome on board!

Do you mean something like this?

Are you Dutch by any means?
I’m with Royal BAM, and work from NL…..

Re: Assembling a string with multiple Variables - String Interpolation

kkrivonos — Tue, 25 Jan 2022 03:30:23 GMT

Just drag Datapills to the text area and here you go:)

Re: Assembling a string with multiple Variables - String Interpolation

tshoemaker — Tue, 25 Jan 2022 03:32:25 GMT

Nope, that doesn't quite do what I want. The interpolation formula is very easy to read.

And my name has Dutch roots.. Originally Schoonmaker, but my family migrated to USA in the 1500's... Heinrick Hockem Schoonmaker was the first to come across the atlantic. But there has been 10 generations since then, so it is hard to call myself "Dutch". 😉

Re: Assembling a string with multiple Variables - String Interpolation

dcornwell — Tue, 25 Jan 2022 04:01:20 GMT

Yep, that's what I was going to suggest. Workato is designed to make building as low-code as possible, so whilst you CAN do it as a formula, you don't need to if you're just concatenating strings together.

Re: Assembling a string with multiple Variables - String Interpolation

tshoemaker — Tue, 25 Jan 2022 04:05:05 GMT

ANSWER! Yes you can... RUBY does have the concept of String Interpolation (see http://ruby-for-beginners.rubymonstas.org/bonus/string_interpolation.html

To test this, i did the following in a string variable setting formula: (as seen in the attached image). The result was "My Name Is Tim Shoemaker and my email address is tshoemaker@epicor.com"

This makes the assembly of long text messages easier because you don't need all those quotes and plus signs.

Re: Assembling a string with multiple Variables - String Interpolation

kkrivonos — Tue, 25 Jan 2022 04:17:28 GMT

Yes, that's also doable:) you can also add "present ? <true datapill> : <false data>" construct to handle nulls

Re: Assembling a string with multiple Variables - String Interpolation

vinny-sosa — Tue, 25 Jan 2022 08:24:33 GMT

The closest thing I have encountered to something similar is join or format on arrays. Still using functions.

Re: Assembling a string with multiple Variables - String Interpolation

gabriel-sim — Tue, 25 Jan 2022 10:01:07 GMT

Hi Tim, string interpolation and string format are supported.

More examples: https://app.workato.com/recipes/2111405

Re: Assembling a string with multiple Variables - String Interpolation

gabriel-sim — Tue, 25 Jan 2022 10:56:02 GMT

This is useful when you need to apply formulas to the datapills before you form the string. Otherwise, Kirill Krivonos solution of dragging datapills to text mode would be ideal

Re: Assembling a string with multiple Variables - String Interpolation

tshoemaker — Tue, 25 Jan 2022 12:12:56 GMT

Ahhh… now I get it… you don’t NEED to do string interpolation to get it to work. You can simply insert the variables into he string and it works. I was overthinking it.

You might want to include an example of it working that way in the string section of the guide… I was way overthinking it.