Hello,
I have a flow where I extract specific text from an email through a split variable. The text on each line of the email, for example, looks like this, "Origin Destination: New York". I use the ":" as the split point for the variable, as well as the "last" function in order to only retain the text on the right side of ":", so "New York" in this example. When the variable writes into a spreadsheet through the add row into excel function, There is always a space before the imported data. My need is to get rid of that space. I have tried using ': ' adding the space that follows that ":", however that returns the full text instead of just the text on the right side. I have attached screenshots below of the input. Any help would be greatly appreciated
this one would return full text
This one would return the text I need, but with a space
