Remove all characters after a dot, dot included

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. “” should be “country”

Hi @lucascorintho

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

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


Thanks for the help! Worked perfectly

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.