Remove all characters after a dot, dot included

[lucascorintho]

Hi Guys,

I’m trying to remove all characters after a dot in a column with the function regexReplace, can you help me with the expression? I tried regexReplace(§column§,“.*”,“”) but didin’t work out.

e.g. “country.store” should be “country”

[ArjenEX]

Hi @lucascorintho

Almost there. You can use regexReplace($column1$,"[.].*","")

Note that .* is a general wildcard so it needs to explicitly refer to the dot

[lucascorintho]

@ArjenEX

regexReplace($column1$,“[.].*”,“”)

Thanks for the help! Worked perfectly