Replace a specific character

[wcamarg3]

Hi all,

I'm trying to replace 3 characters "&&&" by only one character "&".

I used this formula:

Replace([field], "&&&", "&")

but it keeps "&&&".

Does anyone know how to solve it?

Many thanks,

Wilson

[markcurry]

Hi @wcamarg3 

The formula you have should work, so I'm not sure what the issue is.  You could also try a RegEx replace formula..

REGEX_Replace([Input], "&{3}", "&")

Hope that helps

[vizAlter · Accepted solution]

Hi @wcamarg3 — Use this expression in a Formula tool, like below:

REGEX_Replace([Field1], "&&&*", "&")

[wcamarg3]

I only made a small change like that:

REGEX_Replace([Field], "&&&*", "")

It worked like that.

Many thanks for your help.

[vizAlter]

@wcamarg3 — Glad to know!

Please mark that post "Solved" or "Solved" with a Like if resolved your query. This will help other users find the same answer/resolution.  Thank you.