Remove Multiple Different Strings

Question

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.

Remove Dot Dot.PNG

ImadZidan · Accepted Answer

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 Answer

Hi @mohdhafiz , try this.

Regex- \.\.+

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

Thanks.

vizAlter · Accepted Answer

Hi @mohdhafiz — Try to use this formula:

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