Remove Multiple Different Strings

[mohdhafiz]

Hi, is there any ways I can do to remove the dots (.....) from the fields. There are many dots in my data where some of it have 5 dots and others have 3 dots. Currently, I am using the Multi-Field Formula to remove each cases. I am really appreciate if you guys can help. Attached below is the sample data that I working on right now. Thank you.

[ImadZidan · Accepted solution]

Hello @mohdhafiz ,

You can use a formula to do this.

See attached. two formula tools. One to replace many dots with one and another with nothing. Choose whichever convenient.

It will at least give you an idea.

[grazitti_sapna · Accepted solution]

Hi @mohdhafiz , try this.

Regex- \.\.+

If you could provide a sample dataset I could verifiy the regex.

Thanks.

[vizAlter · Accepted solution]

Hi @mohdhafiz — Try to use this formula:

REGEX_Replace([Field1], "(\s)([.]+)(\d)", "$1$3")