RegEx or Formula tool to identify strings with two dots in a column

[AKPWZ]

Hi everyone, 

I have question regarding a formula or say RegEx
Can you please help me to find a regex to find two dots in these two strings:

- properties.hs_legal_basis.value

- properties.hs_legal_basis.versions.0.value
Say above two values are in a column and I want to keep only a string which has only two dots in it and rest it exclude from the column and the final output would be one string left as mentioned below.
- properties.hs_legal_basis.value

I tried some of the RegEx in RegEx tool and Formula in Formula tool but nothing works for me.

Please help me on this. 

Thank you

[Christina_H · Accepted solution]

Try this in a filter tool:

REGEX_Match([Field1],"[^\.]*\.[^\.]*\.[^\.]*")

[Hammad_Rashid · Accepted solution]

One possible regex that can do this is:

^[^.]*\.[^.]*\.[^.]*$

This regex means:

• ^ matches the start of the string
• [^.]* matches zero or more characters that are not dots
• \. matches a literal dot
• [^.]* matches zero or more characters that are not dots
• \. matches a literal dot
• [^.]* matches zero or more characters that are not dots
• $ matches the end of the string

[binuacs · Accepted solution]

@AKPWZ @Add the below condition in the filter tool

REGEX_CountMatches([Field],’\.’) <= 2