Formula

[azakharyan]

Can someone help me with writing a formula. 

My dynamic input has an output record that comes with one space in between the two words and instead I'm looking to be able to add another space using a formula. In other words, instead of having one space I need to have two spaces. 

Any ideas on how to write this formula? 

[christine_assaad]

Hi @azakharyan 

I used a simple Replace function as below. As you can see from the Space Count formula below, it now sees 2 white space.

You can also use Regex but I believe this is simpler. Cheers!

[flying008]

嗨，@azakharyan 

Maybe you want the formula below:

替换（[输出] ，'' ， '' ）

[Emmanuel_G]

@azakharyan ,

Two ways to achieve that :