Replacing Characters

[Otto]

Hi Fellow Flow-ers,

I'm not familar with the replace expression so need some help please.

We have an issue where our website does not allow ; as a valid seperator for multiple email addresses.

We have found that if we transfer into ASCII it will go through but form cannot be saved by client without changing the ; to a ,

How can I change the ; (example below shows %3B) to , (example would be %2C)

test%40xyz.com%3Btest%40gmail.com.au to test%40xyz.com%2Ctest%40gmail.com.au

[RobElliott]

Hi @Otto , one thing which you can try which worked in my test was to add a Compose action, add the addresses into it separated by a comma, and then use the Output from that in the To field of the Send an Email.

Rob
Los Gallardos

[Otto]

Thanks but does not help me unfortunately. I need to replace the characters for my full flow to work

[RobElliott]

The solution I gave does replace the semi-colons with a comma and my full flow worked fine. You'll need to give more detail about why it wouldn't work for you as sorry but I don't understand.
Rob
Los Gallardos

[Otto]

Hi Rob,

Basically what I need to do is change semi colon to comma so when i fill a webform with the data it shows as email,email as email;email is not supported.

I believe i need to use the expression replace but im not 100%.

If your solution did this i did not realise.

My flow does the following,

Parses data from email by html to text then encodes it and sends the data via sms,email,xml for various systems.

[Otto · Accepted solution]

Hi @RobElliott thanks for your assistance on this.

I actually had some spare time and when through the forum and found that replace() may do the trick.

I ended up using compose and expression

replace(outputs('Email_Encoded'),'%3B','%2C')

So the ASCII semi colon (%3B) is converted to comma (%2C)

[RobElliott]

Hi Otto, that's good. I'm pleased you resolved it.

Rob
Los Gallardos