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,
Solved! Go to Solution.
Hey @Myusrename001,
Don't need regex can just use the replace function in a formula tool:
Replace([Field1], "+", " ")
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 - My output will show as "FUO202205112EKEceIM0INSFBC35231" without spaces... can you please review.
Works Perfect ! Thanks so much @IraWatt
No worries @Myusrename001 ! glad it worked :)