Regex_replace for text that contains + with space

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,

Regex

Accepted answers

@Myusrename001 Make sure there is a space here:

This tells the tool what to replace the + with

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

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

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

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.

In that case just use this in the parse tool:

(\+)

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

@Myusrename001 Make sure there is a space here:

This tells the tool what to replace the + with

Works Perfect ! Thanks so much @IraWatt

No worries @Myusrename001 ! glad it worked