Regex_replace for text that contains + with space

[Myusrename001]

Team,

if we have a text that contains - FUO20220511++2EKE+ceIM0INSFBC35231, this needs to be replace + with spaces. 

This is what my output should look like - (FUO20220511  2EKE ceIM0INSFBC35231 ). can anyone guide me. Thanks ! 

Thanks,

[IraWatt]

Hey @Myusrename001,

Don't need regex can just use the replace function in a formula tool:

Replace([Field1], "+", " ")

[IraWatt]

If you really want to use Regex you could do this:

(\++)

This will match with 1 or more +'s and replace it with a space

[Myusrename001]

Hi @IraWatt Thanks -

but the output contains only one space, if we have ++ then it should show "  " (2 space), if we have 3 + then we need to have 3 space... likewise.

[IraWatt]

Hey @Myusrename001,

In that case just use this in the parse tool:

(\+)

[Myusrename001]

@IraWatt  - My output will show as "FUO202205112EKEceIM0INSFBC35231" without spaces... can you please review.  

[IraWatt · Accepted solution]

@Myusrename001 Make sure there is a space here:

This tells the tool what to replace the + with

[Myusrename001]

Works Perfect ! Thanks so much @IraWatt 

[IraWatt]

No worries @Myusrename001 ! glad it worked :)