Look for canonical pattern like word.word.word

Question

Hi

I need to validate some entries like

dataserver.database.datatable as you can see this canonical form a kind of hierarchy and dot between the three words

 

Reguards

---

Every one was a beginner once

Answer 1

either the very simplest form:

^[a-z]+\.[a-z]+\.[a-z]+$

Or:

^[a-z]+(\.[a-z]+){2}$

or

^([a-z]+(\.|$)){3}

Answer 2

Hi

Thank you for the answer however if I test this pattern against TEST.dbo.TAB for example it is not matching 

Thank you

---

Every one was a beginner once

Answer 3

On Sat, 23 Jul 2011 15:45:38 +0000, moss888 wrote:

 

>

>

>Hi

>

>Thank you for the answer however if I test this pattern against TEST.dbo.TAB for example it is not matching 

>

 

Well, either include capital letters in your character classes, or use the option to ignore case.

 

---

Ron

Answer 4

Hi,

Use case insesitive, or change [a-z] to [a-zA-Z] may be you need digits [a-zA-Z0-9] may be "_" symbol [a-zA-Z0-9_]

In my practice i have a situation where database have "." in name in this case is used [database].[scheme].[table] for example [Services.Users].dbo.User or [Services.Users].[dbo].[User]

in this case we need other regex:

^(([a-zA-Z0-9_]+)|(\[[a-zA-Z0-9_\.]+\]))(\.(([a-zA-Z0-9_]+)|(\[[a-zA-Z0-9_\.]+\]))){2}$

i want to mentionate that 

^([a-z]+(\.|$)){3} - is wrong regex because it match "sadasd.as.qweqwe."

Answer 5

Thank you a lot rotaru

---

Every one was a beginner once